Page 1 of 1

Catalog table details

PostPosted: Sun Apr 19, 2015 5:26 pm
by tjegan
Hi All,

When a plan is bound by the BIND COMMAND,DB2 loads the data into the following DB2 catalog tables:
SYSIBM.SYSDBRM
SYSIBM.SYSPACKLIST
SYSIBM.SYSPLANAUTH
SYSIBM.SYSPLSYSTEM
SYSIBM.SYSTABAUTH
SYSIBM.SYSPACKAUTH
SYSIBM.SYSPLAN
SYSIBM.SYSPLANDEP
SYSIBM.SYSSTMT

Question: Can anyone please share us the list of field names(columns) for the above tables and let me know if any table names need to be corrected/added/removed.

Thanks much in advance.

Re: Catalog table details

PostPosted: Sun Apr 19, 2015 7:10 pm
by enrico-sorichetti
why not look Yourself at the manuals for Your version of db2...
the system tables have the bad habit of changing a bit between different db2 versions.

Re: Catalog table details

PostPosted: Mon Apr 20, 2015 4:40 pm
by NicC
I did a quick look in my DB2 Refernce Summary (v3 !) and you should too. SYSTABLES.