DSNTXAZP tool
The DSNTXAZP tool updates a CLIST defaults input member (DSNTIDxx) with certain current subsystem parameter and buffer pool settings that are defined in a specified Db2 subsystem.
Job DSNTIJXZ invokes the DSNTXAZP tool.
The DSNTXAZP tool requires Resource Recovery Services (RRS).
The DSNTXAZP tool does not update all entries in the DSNTIDxx member. For a list of entries that are not updated, see Updating the CLIST defaults input member: job DSNTIJXZ .
The batch program requires the following arguments:
//STEP01 EXEC PGM=DSNTXAZP,PARM='ssid action'
ssid is the subsystem ID.
action is one of the following values:
- UPDATE_ALL
- Creates a new CLIST defaults input member and updates it with the current subsystem parameter and buffer pool settings.
- UPDATE_BPOOL
- Creates a new CLIST defaults input member and updates it with the current buffer pool settings only (no subsystem parameter changes).
- UPDATE_ZPARM
- Creates a new CLIST defaults input member and updates it with the current subsystem parameter settings only (no buffer pool changes).
- XAINPUT
- Used as input to the DSNTXAZP program. It allocates the current CLIST defaults input member that will be used as the source for creating a new CLIST defaults input member. The version of the member should match the version of the selected Db2 subsystem.
- XAOUTPUT
- Used as output by the DSNTXAZP program. It allocates the generated CLIST defaults input member with updated subsystem parameter and buffer pool settings. This should be a member of a PDS that is defined with RECFM=FB, LRECL=80.
- SYSPRINT
- Used as output by the DSNTXAZP program for informational and error messages. It also contains a report on the parameters that were processed and modified. For additional details on the report, see the example below.
The following JCL is an example of running the tool:
//DSNTIXZ EXEC PGM=DSNTXAZP,PARM='DSN UPDATE_ALL'
//XAINPUT DD DSN=prefix.SDSNSAMP(DSNTIDXA),DISP=SHR
//XAOUTPUT DD DSN=prefix.SDSNSAMP(DSNTIDNU),DISP=SHR
//SYSPRINT DD SYSOUT=*
The tool generates a CLIST input member with the current subsystem parameter settings, buffer pool settings, or both, and the following prolog:
* **********************************************************************
* CREATED MEMBER = MY.DATASET.NAME(DSNTIDNU) *
* *
* CREATED ON = MAR 24, 2010 11:12:30 *
* *
* SOURCE MEMBER = MY.SOURCE.NAME(DSNTIDXA) *
* *
* DESCRIPTIVE NAME = DB2 INSTALLATION DATA *
* *
* FUNCTION = PROVIDE UPDATED VALUES FOR MIGRATING TO A NEW RELEASE *
* OF DB2 OR INSTALLING A NEW RELEASE OF DB2 *
* *
* PARAMETERS: *
* PARM NAME = NAME FOR ISPF PANEL VARIABLE *
* PARM TYPE = TYPE FOR VALIDITY CHECKING *
* DS SCP = DATA SHARING SCOPE: G = GROUP, M = MEMBER *
* MIN, MAX = RANGE VALUES FOR VALIDITY CHECKING *
* CURRENT VALUE = VALUE USED AS INPUT FOR NAMED ISPF VARIABLE *
* *
* **********************************************************************
* ************************************************* *
* PARM PARM DS MIN MAX CURRENT *
* NAME TYPE SCP VALUE VALUE VALUE *
* ************************************************* *In addition to creating a new CLIST input member, the DSNTXAZP tool provides a report of all parameters. The report indicates whether each parameter was updated or if the original value from the input member was retained. It also shows the mapping between the subsystem parameter and the CLIST parameter. This is a sample report:
CLIST INPUT MEMBER GENERATION REPORT ** 2010-03-24 08:25:35
-----------------------------------------------------------
CLIST PARAMETER REPORT:
0001 PARAMETER NAME = ABEXP
ZPARM/BUFFERPOOL PARAMETER = ABEXP
PARAMETER TYPE = CHAR
DATA SHARING SCOPE = M
MINIMUM VALUE = NO
MAXIMUM VALUE = YES
CURRENT CLIST VALUE = YES
CURRENT INSTALLED VALUE = YES
STATUS = RETAINED
0002 PARAMETER NAME = ABIND
ZPARM/BUFFERPOOL PARAMETER = ABIND
PARAMETER TYPE = CHAR
DATA SHARING SCOPE = M
MINIMUM VALUE = NONE
MAXIMUM VALUE = NONE
CURRENT CLIST VALUE = YES
CURRENT INSTALLED VALUE = NO
STATUS = UPDATED
:
nnnn PARAMETER NAME = DB2REL
ZPARM/BUFFERPOOL PARAMETER = N/A
PARAMETER TYPE = CHAR
DATA SHARING SCOPE = M
MINIMUM VALUE = NONE
MAXIMUM VALUE = NONE
CURRENT CLIST VALUE = 1010
CURRENT INSTALLED VALUE = N/A
STATUS = RETAINED
:
CHANGE SUMMARY REPORT:
CLIST PARAMETER ZPARM/BUFFERPOOL PARAMETER VALUE
----------------------------------------------------------------------------------
ABEXP -SAME- YES
* ABIND -SAME- NO (YES)
:
* BP0_VPSEQT BP0 VPSEQT 50 (35)
* BP0_DWQT BP0 DWQT 50 (35)
* BP0_VDWQT BP0 VDWQT 10,0 (20)
:
BUFMAX00 BPO VPSIZE 20000
:
DB2REL -NONE- 1010
:
* NUMCONCR CTHREAD 220 (200)
OVDSMAX DSMAX 20000
:
----------------------------------------------------------------------------------
SOURCE MEMBER : prefix.SDSNSAMP(DSNTIDXA)
CREATED MEMBER : DB2.CLIST.MEMBER(DSNTIDX0)
PARAMETERS PROCESSED : n
PARAMETERS MODIFIED : m
----------------------------------------------------------------------------------