description of system tables

[ddiamond]

In oracle, if you want a list of all of the system tables along with their description, you could run the following query:

select * from dictionary;

Is there anything like this for DB2/UDB?

 

[blom0344]

Select * from SYSIBM.SYSTABLES WHERE CREATOR = 'SYSIBM' AND TYPE = 'T'

Ties Blom
Information analyst

 

[ddiamond]

Thanks Ties. Your query does give me a list of the system tables, but it does not give me a discription. The remarks field is always blank. Are there any other systables that might have a description? If not, do you know of any websites that have a list of the systables and a description of them?

 

[MarcLodge]

ddiamond,
If you have a look at the flip manual here: ftp://ftp.software.ibm.com/software/db2storedprocedure/db2zos390/v6books/DSNRS0G1.PDF round about page 197 there is a description of each table and what it does. I'm sure there must be a more up to date version (as this is version 6) that a google would find.

In fact if you go to here:

http://ca.com/products/posters/download.htm

you will find a great downloadable .exe poster file from CA that has all the info you need. It's a pretty easy to use if I remember correctly.

Marc

 

[rbod]

this command will give a list of all the system tables/views, but not description :
list tables for system

 

[ddiamond]

I finally found a good link for DB2 UDB system tables:
[URL unfurl="true"]http://grdelin.phy.hr/~ivo/Nastava/Baze_podataka/arhiva/sql/db2/rocatv.htm#HDRROCATV[/url]