?
Solved

Data dictionary in DB2

Posted on 2003-03-11
3
Medium Priority
?
1,789 Views
Last Modified: 2008-02-01
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.
0
Comment
Question by:k_murli_krishna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
ghp7000 earned 400 total points
ID: 8113440
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
 
LVL 13

Expert Comment

by:ghp7000
ID: 8113603
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
 
LVL 17

Author Comment

by:k_murli_krishna
ID: 8117322
Thank you. Make sure you do not post duplicate comments.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question