Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is the Database Catalog for IMS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
devadoz
Warnings : 1

New User


Joined: 02 Feb 2007
Posts: 9
Location: London

PostPosted: Tue Feb 06, 2007 10:54 pm    Post subject: What is the Database Catalog for IMS
Reply with quote

Hi,

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.

Please clarify.

Thanks.

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

Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Feb 07, 2007 12:48 am    Post subject:
Reply with quote

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         
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Wed Feb 07, 2007 9:06 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
devadoz
Warnings : 1

New User


Joined: 02 Feb 2007
Posts: 9
Location: London

PostPosted: Wed Feb 07, 2007 2:46 pm    Post subject: Re: What is the Database Catalog for IMS
Reply with quote

Hi Devzee,

Thanks for your reply.

I am learning things through this good forum and good people like you.

Thanks again.

- Alan
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Feb 07, 2007 4:13 pm    Post subject:
Reply with quote

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. icon_wink.gif

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.
Code:
IDCAMS  SYSTEM SERVICES                                           TIME: 11:32:3
                                                                               
 LISTCAT ENTRIES(NBDBIMS.DBNLZAB.ES) ALL                                0008224
CLUSTER ------- NBDBIMS.DBNLZAB.ES                                             
     IN-CAT --- SYS1.UCAT.VTSOT21                                             
     HISTORY                                                                   
       DATASET-OWNER-----(NULL)     CREATION--------2006.345                   
       RELEASE----------------2     EXPIRATION------0000.000                   
     SMSDATA                                                                   
       STORAGECLASS -----NSCSTD     MANAGEMENTCLASS----MCTSO                   
       DATACLASS ----------DCDB     LBACKUP ---2007.020.2101                   
       BWO STATUS------00000000     BWO TIMESTAMP---00000 00:00:00.0           
       BWO---------------(NULL)                                               
     RLSDATA                                                                   
       LOG ----------------(NULL)   RECOVERY REQUIRED --(NO)     FRLOG --------
       VSAM QUIESCED -------(NO)    RLS IN USE ---------(NO)                   
       LOGSTREAMID-----------------------------(NULL)                         
       RECOVERY TIMESTAMP LOCAL-----X'0000000000000000'                       
       RECOVERY TIMESTAMP GMT-------X'0000000000000000'                       
     PROTECTION-PSWD-----(NULL)     RACF----------------(NO)                   
     ASSOCIATIONS                                                             
       DATA-----NBDBIMS.DBNLZAB.ES.DATA                                       
   DATA ------- NBDBIMS.DBNLZAB.ES.DATA                                       
     IN-CAT --- SYS1.UCAT.VTSOT21                                             
     HISTORY                                                                   
       DATASET-OWNER-----(NULL)     CREATION--------2006.345                   
       RELEASE----------------2     EXPIRATION------0000.000                   
 .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .  . 
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Feb 07, 2007 5:51 pm    Post subject:
Reply with quote

*note to myself: improve your reading technics* icon_redface.gif

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..
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Database backup on IMS DB HABBIE IMS DB/DC 1 Wed Aug 12, 2015 9:02 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us