Database Management for DB2 for Z/OS : How do I find out what cdbaparm members are being used and what datasets are actually allocated at the startup?
search cancel

Database Management for DB2 for Z/OS : How do I find out what cdbaparm members are being used and what datasets are actually allocated at the startup?

book

Article ID: 20958

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Administration Suite

Issue/Introduction

When a user enters the Database Management for DB2 for z/os products main menu , settings from the parmlib (hlq.CDBAPARM ) are automatically brought in.

Settings such as which members of *.CDBAPARM are being used of the many on that library to choose from.

Also settings like dataset allocations for the various product and DB2 libraries.

 

Environment

Release: R20
Component: GEN

Resolution

When in the Database Management for DB2 for z/os products main menu there are two Option line or Command line commands that will give the user information about the settings used.

The STATUS command lists the actual CDBAPARM members being used and the FILES command lists the actual datasets that have been allocated.

20.0.08  Database Management Solutions for Db2 for z/OS       yyyy/mm/dd hh:mm
OPTION ===> status                                            SCROLL ===> CSR

The STATUS command also tells the user the actual xmanager started task identifier that is being used. If there a problem then STATUS will tell you that also.

----------- Parmlib Processing Status Messages ----------- yyyy/mm/dd hh:mm:ss
COMMAND ===>                                                  SCROLL ===> PAGE

   The following list shows the status of each PARMLIB member processed.
   Correct any errors that may have occurred in the member(s) specified.

MEMBER     MESSAGE
PTISYS00   PROCESSED SUCCESSFULLY
SETUP00    THE XMAN CONNECTION WILL USE XMANID(2000)
SETUP00    PROCESSED SUCCESSFULLY
PLANS00    PROCESSED SUCCESSFULLY
DSNAME00   PROCESSED SUCCESSFULLY

The report from the FILES command can be used to track back to the DSNAME00 and PTISYS00 members in hlq.CDBAPARM to see that the correct libraries are in use.

In the FILES report the actual CDBAPARM library that was allocated can be found assigned to the PTIPARM DD.

The IBM ISRDDN diagnostic utility can also be used to list the datasets allocated.........TSO ISRDDN

The TSO ISRDDN command can be typed from the command line also!!

Additional Information

ISRDDN diagnostic utility

To read more about the FILES and STATUS command , start at the Database Management for DB2 for z/os products main menu.
Place a "?" in the OPTION ===> field and press enter.

Scroll down till you see these two commands in the list.
Then place a "?" next to the command like this :  ? FILEs    or  ? STATUS
The help text will describe the command.

To run the command from the list place an "s" next to it like this : s STATUS    or    s FILEs