Step 1: Schema Enablement


The first step of the enablement process is
Schema Enablement which data definition language (DDLs) are enabled to run on DB2.


Business Problem: Other RDBMS using non-standard data types


The heart of every database is its data. Mismatched types or mismatched semantics of these types can seriously impact the ability to enable an application to another RDBMS. So to allow Oracle applications to run on DB2, it is crucial to support its non-standard basic types, such as strings, dates, and numerics.



DB2 new data types


DB2 9.7 supports some Oracle data types to make DB2 enablement more easily and quickly. DB2 new data types are: