|
|
| Author |
Message |
rohanthengal
New User
Joined: 19 Mar 2009
Posts: 18
Location: Pune/Mysore
|
|
|
|
Hi,
What is the difference between DBD and Catalog tables ?
Also which is efficient ?
Regards,
ROHAN |
|
| Back to top |
|
 |
References
|
|
 |
GuyC
Active User
Joined: 11 Aug 2009
Posts: 488
Location: Belgium
|
|
|
|
database descriptors (DBDs) are internal objects primarly used by DB2 to take a lock on when there is DML,utilities or (alter/create/drop) going on.
Catalog tables are "normal" tables you can query on.
I wouldn't know how to query a DBD.
So the question of efficiency is void as far as I'm concerned. |
|
| Back to top |
|
|
LearningDb2
New User
Joined: 19 Jun 2009
Posts: 38
Location: India
|
|
|
|
Hi Rohan,
Are u looking for difference between directories and catalog tables?
if Yes..
Catalog tables are set of tables that is maintained by DB2 and contains the information of all the objects that have been defined in the DB2 subsystem.
Eg -tables,views stored proc,routines,dbrms,plans,packages database,TS etc...
Whenever u alter/define any object corresponding rows are inserted/updated/deleted from the respective catalog tables.
doing runstats with update option updates the catalog tables accordingly and allowing the DB2 optimizer to get the most optimized access path.
Most of the catalog tables are stored in DSNDB06
As far as directories are concerned ..they are stored in 5 TS in DSNDB01(System Database).
The directoried are used during normal operation of DB2 and it is not accessible by sql queries.
they are like SPT01,SCT01,SYSLGRNX,SYSUT1 ...
SPT01 stores infoemation abt access path for a package in internal form of SQL.
SCT01-stores info abt access path for a plan in internal form of SQL
SYSUT1- contains corresponding entries of the utilitiy that is running
Chek This..
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.intro/db2z_directory.htm
Hope this helps..
Thanks |
|
| Back to top |
|
|
|
|
