Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Difference between DBD and Catalog tables !

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 181
Location: Globe, India

PostPosted: Mon Jul 12, 2010 10:38 pm    Post subject: Difference between DBD and Catalog tables !
Reply with quote

Hi,
What is the difference between DBD and Catalog tables ?
Also which is efficient ?

Regards,
ROHAN
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Jul 13, 2010 11:15 am    Post subject:
Reply with quote

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
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Tue Jul 13, 2010 11:26 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us