DSNTXAZP tool

Start of changeThe DSNTXAZP tool updates a CLIST defaults input member (DSNTIDxx) with information about the current subsystem parameter settings, buffer pool settings, and other installation settings that are defined in a specified Db2 subsystem.End of change

Start of change

Before running DSNTXAZP

  • You can run the DSNTIJXZ job to invoke the DSNTXAZP tool. For more information, see Updating the CLIST defaults input member: job DSNTIJXZ .

  • Ensure that you have configured 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 .

  • Before running the DSNTIJXZ job, you might need to bind or refresh the package and plan for the DSNTXAZP program. The necessary bind commands are in installation job DSNTIJSG.

  • If the DSNTXAZP job action to be used is UPDATE_APPL_DEF, UPDATE_IRLM, UPDATE_LOG, or UPDATE_ALL, ensure that the following requirements are met:

    • SYSOUT data sets for started tasks are available:
      • JOBCLASS(STC) OUTPUT must be set to YES
      • OUTCLASS(x) OUTPUT must be set to PRINT or PUNCH, where x is the JOBCLASS(STC) MSGCLASS value
    • The load library with the enhanced DSNTXAZP module resides in an APF-authorized library.
    • If you plan to invoke DSNTXAZP from a TSO CALL command, you must add DNTXAZP to the AUTHPGM and AUTHTSF sections of IKJTSOxx.

  • For the following DSNTXAZP job actions, ensure that each user ID who executes DSNTXAZP has, at a minimum, the following access to JES SPOOL data sets:

    • UPDATE_APPL_DEF: READ access to the JES SPOOL JESMSGLG data set of the Db2 started task (ssidMSTR) where the DSNHDECP module name is specified.
    • UPDATE_IRLM: READ access to the JES SPOOL JESJCL data set of the IRLM started task (IRLMPROC - the IRLM startup procedure name) where the IRLM startup options are specified.
    • UPDATE_LOG: READ access to the JES SPOOL JESJCL data set of the Db2 started task (ssidMSTR) where the BSDS names are specified.
    • UPDATE_ALL: READ access to the JES SPOOL data sets listed above for the UPDATE_APPL_DEF, UPDATE_IRLM, and UPDATE_LOG actions.
  • For the DSNTXAZP job actions, UPDATE_JAVA or UPDATE_ALL, ensure that each user ID who executes DSNTXAZP, has at minimum, read access to the files and members in the JAVAENV, JAVAENVV, and JVMPROPS parameters.
End of change
Start of change

DSNTXAZP actions

The DSNTXAZP tool updates a CLIST defaults input member (DSNTIDxx) with the following configuration information:

  • Application defaults module setting
  • Authorization IDs used in installation jobs
  • Authorization IDs used in IVP jobs
  • BSDS and active log settings
  • Buffer pool settings
  • Data parameters settings
  • Db2 catalog sizes
  • DDF settings
  • Start of changeJava settingsEnd of change
  • IRLM startup parameters
  • MVS parmlib settings
  • Routine settings
  • Subsystem parameter settings
  • Work file database and table spaces settings
End of change

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
Start of changeCreates a new CLIST defaults input member and updates current subsystem parameter settings, buffer pool settings, and various other installation settings. That is, UPDATE_ALL has the effect of executing all of the following actions at the same time.End of change
Start of changeUPDATE_APPL_DEFEnd of change
Start of changeThis action creates a new CLIST defaults member and updates it using the name of the application defaults module. The following DSNTIDxx entry (CLIST parameter) is updated: DSNHDECP.End of change
Start of changeUPDATE_AUTH_INSTALLEnd of change
Start of changeCreates a new CLIST defaults member and updates it using the authorization IDs used in installation jobs only. The following DSNTIDxx entries (CLIST parameters) are updated: INSSQLID, INSPKOWN, INSGRLST.End of change
Start of changeUPDATE_AUTH_IVPEnd of change
Start of changeCreates a new CLIST defaults member and updates it using the authorization IDs used in IVP jobs only. The following DSNTIDxx entries (CLIST parameters) are updated: IVPSQLID, IVPPKOWN, IVPGRLST.End of change
UPDATE_BPOOL
Creates a new CLIST defaults input member and updates it with the current buffer pool settings only.
Start of changeUPDATE_CATALOG_SIZEEnd of change
Start of changeThis action creates a new CLIST defaults member and updates it using the current Db2 catalog sizes only. The following DSNTIDxx entries (CLIST parameters) are updated: NUMCOLUM, NUMDATAB, NUMPKGS, NUMPKSTS, NUMPLANS, NUMPLPL, NUMTABLE, NUMTABSP, NUMVIEWS.End of change
Start of changeUDPATE_DATA_PARAMEnd of change
Start of changeThis action creates a new CLIST defaults member and updates it using the attributes of the non-VSAM data sets and storage groups created by the installation and IVP jobs only. The following DSNTIDxx entries (CLIST parameters) are updated:
  • VOLSDAT3, DATACLS3, MGMTCLS3, STORCLS3
  • INSICPRE
End of change
Start of changeUPDATE_DDFEnd of change
Start of changeCreates a new CLIST defaults member and updates it using the current DDF settings only. The following DSNTIDxx entries (CLIST parameters) are updated: DDLOC, DDLUNAM, GENLUNM, IPNAME, TCPPORT, SECPORT, RESYNPRT End of change
Start of changeUPDATE_IRLMEnd of change
Start of changeThis action creates a new CLIST defaults member and updates it using the IRLM startup procedure parameters only. The following DSNTIDxx entries (CLIST parameters) are updated: IRLMDISC, IRLMGRPN, IRLMIDEN, IRLMLKSZ, IRLMLTE, IRLMMLMT, IRLMMLTU, IRLMPGPR, IRLMTRAC.End of change
Start of changeUPDATE_JAVAEnd of change
Start of changeThis action creates a new CLIST defaults member and updates it using the Java parameter settings only. The following DSNTIDxx entries (CLIST parameters) are updated: DB2BASE, CLASPATH, JAVAENVV, JAVAHOME, JCCHOME, JVMPROPS, LIBPATH, JVMAPPH, and JVMHEAP.End of change
Start of changeUPDATE_LOGEnd of change
Start of changeCreates a new CLIST defaults member and updates it using the BSDS and active log settings only. The following DSNTIDxx entries (CLIST parameters) are updated:
  • LOGSPRE1, LOGSPRE2
  • BSDSNAM1, BSDSNAM2
  • VBSDSLOG
  • VOLSDAT6, DATACLS6, MGMTCLS6, STORCLS6
  • VOLSDAT7, DATACLS7, MGMTCLS7, STORCLS7
  • LOGSNUM
End of change
Start of changeUPDATE_MVS_PARMLIBEnd of change
Start of changeThis action creates a new CLIST defaults member and updates it using the current MVS parmlib settings only. The following DSNTIDxx entry (CLIST parameters) are updated: MVSSPREF, SGRPATNM End of change
Start of changeUPDATE_ROUTINEEnd of change
Start of change

This action creates a new CLIST defaults member and updates it using the current routine settings only. The following DSNTIDxx entries (CLIST parameters) are updated:

  • AUTHID, SECDEFID
  • WLMENVG, WLMENVP, WLMENV1, WLMENVU, WLMENVX, WLMENVJ, WLMENVR, WLMENVD, WLMENVC, WLMENVM, WLMENVW
  • RTxnnACL, RTxnnPKO, RTxnnWLM
  • STOGJRT, STGIJRT
End of change
Start of changeUPDATE_WKFL_DBEnd of change
Start of changeThis action creates a new CLIST defaults member and updates it using the current Db2 work file database and table space settings only. The following DSNTIDxx entries (CLIST parameters) are updated:
  • WKDBNAME
  • S32KNOTS, S32KSGSZ, S4KNOTS, S4KSGSZ
  • T32KNOTS, T32KSGSZ, T4KNOTS, T4KSGSZ
End of change
UPDATE_ZPARM
Creates a new CLIST defaults input member and updates it with the current subsystem parameter settings only.
The following DD statements are required for processing:
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, and other installation settings that are defined in a specified Db2 subsystem, and the following prolog:

* **********************************************************************
*  CREATED MEMBER = MY.DATASET.NAME(DSNTIDNU)                          *
*                                                                      *
*  CREATED ON = 2025-04-03 12:30:38                                    *
*                                                                      *
*  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, which indicates the following information:

  • Whether each parameter was updated or if the original value from the input member was retained.
  • When a parameter cannot be discovered.
  • The mapping between the subsystem parameter and the CLIST parameter.

This is a sample report:

CLIST INPUT MEMBER GENERATION REPORT ** 2025-04-03 12:30:38  
-----------------------------------------------------------

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
 :

0212 PARAMETER NAME             = DATACLS6        
     ZPARM/BUFFERPOOL PARAMETER = N/A             
     PARAMETER TYPE             = CHARR           
     DATA SHARING SCOPE         = M               
     MINIMUM VALUE              = NONE            
     MAXIMUM VALUE              = NONE            
     CURRENT CLIST VALUE        = MYDACLS6        
     CURRENT INSTALLED VALUE    = (NOT DISCOVERED)
     STATUS                     = RETAINED        

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
   :
  DATACLS6                      -NONE-                        MYDACLS6
   :
  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                              
  ----------------------------------------------------------------------------------