In DB2 there is catalog tables which will have the entire table details at the db2 sub system. Like that, is there any place where all the IMS databases will store automatically when ever a new IMS Database or Segments is created. My understanding is at DBRC, if we register then only it will have the entry. Otherwise the new database entry will not be there.
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
This is a part of the creation of one of our databases, segments included. Parent=0 means rootsegment. It uses plain VSAM.
Code:
DBD NAME=DBZABNL,ACCESS=(HIDAM,VSAM)
DATASET DD1=TNLDBZAB,DEVICE=3350,SIZE=18432,SCAN=3
SPACE
** NAMENSSCHLUESSEL (SEGMENT 02)
SEGM NAME=QSNAMSCH,PARENT=0,BYTES=14,POINTER=TB,
FREQ=560000
LCHILD NAME=(IXNAME,IXNLZAB),PTR=INDX
FIELD NAME=(Q02SCHL,SEQ),BYTES=14,START=1,TYPE=X
SPACE
** NAMENS- UND ADRESS-SEGMENT (SEGMENT 03)
SEGM NAME=QSADRESS,PARENT=QSNAMSCH,BYTES=74,FREQ=1 X
FIELD NAME=(Q03SCHL,SEQ,M),BYTES=69,START=1,TYPE=X
FIELD NAME=Q03DATA,BYTES=74,START=1,TYPE=X
SPACE
** ADRESSZUSATZ (SEGMENT 04)
SEGM NAME=QSADRZUS,PARENT=QSADRESS,BYTES=136,FREQ=0
FIELD NAME=Q04DATA,BYTES=136,START=1,TYPE=X
SPACE
** NAMENSKUERZUNG (SEGMENT 48)
SEGM NAME=QSNAMKRZ,PARENT=QSADRESS,BYTES=32,FREQ=0
FIELD NAME=Q48DATA,BYTES=32,START=1,TYPE=X
SPACE
** PERSONENDATEN
SEGM NAME=QSZABPER,PARENT=QSADRESS,BYTES=374
DBDGEN
FINISH
END
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
In IMS DB environment there is no catalog tables.
But instead there is a way you can look at which Database are available.
Any new database should be assembled (DBDGen) and will be stored in IMS standard DBD libraries like IMS.DBDLIB. and the source code will be some thing like IMS.DBD.SRC etc. Any changes to Database like segment is added or changed should be in the DBD source library.
You need to check with someone at your site and get the DBD libraries.
For IMS DC online the database or new database will not available until the DBA adds entries, or creates ACB Gen.
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
What Devzee wrote about no catalog info for IMS DB environment is either wrong or he means something else like: there are no systables like there are for DB2.
Devzee pointed out where the source of the DBD may be found and what steps it takes to have a database up and running. The original question was about the catalog. Below a piece of the listcat (IDCAMS) of the database I posted the DBDGEN of. It shows details about the database including cataloginformation. Mind you: an IMS database is not on tape but like I said plain VSAM.
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
*note to myself: improve your reading technics*
After rereading the posts and the original question Devzee was right there are no systables for IMS databases like there are for DB2. Listcat shows cataloginformation of the individual IMS databases since they are VSAM. However, not every VSAM-file is a database so to find out which databases exist the DBDLIB shows you. Mind you; not the DBD-lib where the sources are stored because a DBD only exists after a DBDGEN and it's no guaranty each source was involved in a DBDGEN..
