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?
Article ID: 20958
Updated On:
Products
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
Feedback
