vijayamadhuri
Active User
Joined: 06 Apr 2005 Posts: 180
|
|
|
|
The DB2 catalog is a set of tables that contain information about all the DB2 objects (tables, views, plans, etc.).
Like when the table is create the table name is stored in the SYSIBM.SYStable.
IF there is apan associated with it then that info is stored in the SYSIBM.SYSPLAN.
If there is an alternate table name for the parent table that info is stored in SYSIBM.SYSSYNONYMS
SYSIBM.SYSCOPY-contains information about image copies made of the tablespaces.
SYSIBM.SYSLINKS -contains information about the links between tables created by referential constraints.
SYSIBM.SYSDBAUTH-information about the type of database authority held by a user
SYSIBM.SYSINDEXES-whether a column has been defined as an index
SYSIBM.SYSVIEWS-When a view is created, system information about the view is stored |
|