Search

Sunday, March 17, 2013

Introduction to most useful SYSIBM DB2 tables - PART 2


Here comes some more SYSIBM tables



SYSIBM.SYSSTMT : This table is input to bind process. It contains statements for every plan known in DB2.

SYSIBM.SYSPLANS: contains information on every plan known to DB2. The plan name is unique in the DB2 subsystem.

SYSIBM.SYSFOREIGNKEYScontains information foreign keys for table. 

SYSIBM.SYSDBAUTH: Contains information on database level authorizations for each user of each database.  Entries are made into this table when database-related GRANT or REVOKE commands are issued for the location.


Please refer PART1 link to get more information on SYSIBM tables.

No comments:

Post a Comment