Data dictionary in DB2

1) In oracle, we have user_triggers, user_tables etc. for various objects. For constraints we have user_cons_priv and user_constraints. Similarly dba_% & all_%. For default values for columns in tables also, storage in DD exists.

2) Please give me a detailed list of what all is possible to be queried and seen similarly in DB2.

3) If some of them are not possible from DD, please give alternative methods apart from using control center.
LVL 17
k_murli_krishnaAsked:
Who is Participating?
 
ghp7000Connect With a Mentor Commented:
connect to the database
issue:
list tables for schema syscat.
These are the tables that correspond to Oracle's data dictionary.
To see what each table contains issue:
db2 describe table syscat.<table_name>
All of thse tables can be seen from Control Center.

Alternate method:
list tablespaces
list packages
list tables
list tablespaces
list tablespace containers

all these commands launch executables which query the syscat tables for you

Note that DB2 does not have seperate tables like Oracle for user, dba, view etc. All data that pertains to the current structure of the db is found in the syscat tables.
0
 
ghp7000Commented:
connect to the database
issue:
list tables for schema syscat.
These are the tables that correspond to Oracle's data dictionary.
To see what each table contains issue:
db2 describe table syscat.<table_name>
All of thse tables can be seen from Control Center.

Alternate method:
list tablespaces
list packages
list tables
list tablespaces
list tablespace containers

all these commands launch executables which query the syscat tables for you

Note that DB2 does not have seperate tables like Oracle for user, dba, view etc. All data that pertains to the current structure of the db is found in the syscat tables.
0
 
k_murli_krishnaAuthor Commented:
Thank you. Make sure you do not post duplicate comments.
0
All Courses

From novice to tech pro — start learning today.