When using extended indexes, additional catalog views provide useful information complementing the SYSCAT catalog views. These views are not created automatically. The views are created in the OBJCAT schema and SELECT privilege on all views is granted to PUBLIC by default.
| WARNING: | This set of views is for temporary use only until the next version that supports catalog migration. Applications should not presume that these views exist in every database and should consider that these catalog views may not be provided in future versions. The information from these views will be supported through the SYSCAT views in a future version. |
The views can be created by following these steps:
db2 -tvf sqllib/bin/objcat.db2
db2 -tvf sqllib\bin\objcat.db2
The views created by objcat.db2 can be removed by following these steps:
db2 -tvf sqllib/bin/objcatdp.db2
db2 -tvf sqllib\bin\objcatdp.db2
| Note: | If the database already includes a schema called OBJCAT, you may need to make your own copy of the file objcat.db2 and change the schema names in the second and third CREATE SCHEMA statements to suitable names. |
The statements in the OBJCAT.DB2 file will create all additional OBJCAT catalog views.
This appendix contains a description of each of the OBJCAT catalog views. For the associated SYSCAT views, see Appendix D, Catalog Views.
The catalog views are updated during normal operation, in response to SQL data definition statements, environment routines, and certain utilities. Data in the catalog views is available through normal SQL query facilities. Columns have consistent names based on the type of objects that they describe: