IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Data Dictionary tables in IMS DB


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
HABBIE

New User


Joined: 08 Jul 2014
Posts: 24
Location: INDIA

PostPosted: Fri Aug 14, 2015 3:10 pm
Reply with quote

Hi,


I am beginer in IMS DB. Can someone kindly let me know where can I find the data dictionary information of IMS DB databases.

Like in db2 we have SYSIBM.SYSDATABASE, SYSIBM.SYSCOLUMNS etc do we have any system defined tables /segments where we can find the metadata information for IMS databases.


Thanks
Back to top
View user's profile Send private message
Gary Jacek

New User


Joined: 17 Dec 2007
Posts: 59
Location: Victoria, BC, Canada

PostPosted: Sat Aug 15, 2015 2:19 am
Reply with quote

Hi Suresh

There used to be a product called "IMS DB/DC Data Dictionary" which was used as a repository for the metadata about IMS databases, segments, fields, DBDs and PSBs. I suspect this product may have been withdrawn from marketing by IBM. That said, your shop may still be running this product.

If you are running IMS V12 or V13 and your sysprog has enabled IMS Open Database with the IMS Catalog enabled, then it is possible you have this metadata about your databases stored in IMS Catalog. This feature is very new, so it is doubtful that IMS Catalog is in place, or populated, for you to use.
Back to top
View user's profile Send private message
HABBIE

New User


Joined: 08 Jul 2014
Posts: 24
Location: INDIA

PostPosted: Sun Aug 16, 2015 9:31 am
Reply with quote

HI Gracy,

So kind of you.
Thanks for the reply. I will check with the IMS catalog now.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Column names in SYSIBM tables DB2 5
No new posts Secondary index error while loading d... IMS DB/DC 2
No new posts SKIP LOCKED DATA in UPDATE statement DB2 9
No new posts How to find which file contains my se... DFSORT/ICETOOL 6
No new posts Changing Data Type SYNCSORT 4
Search our Forums:

Back to Top