Catalog table details



IBM's flagship relational database management system

Catalog table details

Postby tjegan » Sun Apr 19, 2015 5:26 pm

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.
tjegan
 
Posts: 33
Joined: Mon Mar 25, 2013 5:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Catalog table details

Postby enrico-sorichetti » Sun Apr 19, 2015 7:10 pm

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.
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Catalog table details

Postby NicC » Mon Apr 20, 2015 4:40 pm

I did a quick look in my DB2 Refernce Summary (v3 !) and you should too. SYSTABLES.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post