DB2 is a database management system produced by IBM. To store your geodatabase in a DB2 DBMS, you need to use the DB2 Spatial Extender.
Geodatabases stored in a DB2 DBMS have system tables, which are created and maintained in the schema of the ArcSDE administrator. These system tables maintain information about and manage the data in the geodatabase.
Geodatabases stored in DB2 also contain user-defined datasets such as feature classes and raster catalogs. These tables store the spatial and attribute information of your GIS data. They are stored in the schema of the user who creates them. User-defined datasets should not be stored in the ArcSDE administrator's schema; therefore, you should use another user name to connect to the geodatabase when you are creating datasets.
Be aware: DB2 does not support renaming a table if there is a referential constraint of any kind on the table such as a trigger. All spatially enabled tables have triggers. This means you will not be able to rename any feature classes, feature datasets, raster datasets, or raster catalogs.
The following topics describe both the user-defined and system tables found in a geodatabase in DB2.
