PI57969: NEW CQMPARMS PARAMETERS ARE BEING ADDED FOR ALLOCATING WORK DATASETS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This enhancement adds 2 new CQMPARMS parameters TEMP_UNITNAME
  and TEMP_VOLUME for controlling the allocation of temporary work
  files, as described below:
  *
    TEMP_UNITNAME
  
    Required: No
  
    Default: SYSALLDA
  
    Description: The TEMP_UNITNAME parameter enables you to
     specify an esoteric name, generic device type or a device
     address for Query Monitor's temporary work files.
  
    Syntax: TEMP_UNITNAME(unitname)
  
    Where unitname is the unit name, generic device type, or
    device address for allocation of Query Monitor's temporary
    work files.
  
    Example: TEMP_UNITNAME(TMPUNIT)
  *
    TEMP_VOLUME
  
    Required: No
  
    Default: If no value is specified for TEMP_VOLUME, Query
     Monitor work files will allocate to the unit defined by the
     TEMP_UNITNAME.
  
    Description: The TEMP_VOLUME parameter enables you to specify
     a volume for allocation of Query Monitor's temporary work
     files.
  
    Syntax: TEMP_VOLUME(volume)
  
    Where volume is the volume for allocation of Query Monitor's
    temporary work files.
  
    Example: TEMP_VOLUME(TMPVOL)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor z/OS.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: This enhancement adds 2 new CQMPARMS    *
  *                      parameters TEMP_UNITNAME and            *
  *                      TEMP_VOLUME for controlling the         *
  *                      allocation of temporary work files,     *
  *                      as described below:                     *
  *                      *                                       *
  *                        TEMP_UNITNAME                         *
  *                        Required: No                          *
  *                        Default: SYSALLDA                     *
  *                        Description: The TEMP_UNITNAME        *
  *                      parameter enables you to specify an     *
  *                      esoteric name, generic device type or   *
  *                      a device address for Query Monitor's    *
  *                      temporary work files.                   *
  *                         Syntax: TEMP_UNITNAME(unitname)      *
  *                         Where unitname is the unit name,     *
  *                      generic device type, or device address  *
  *                      for allocation of Query Monitor's       *
  *                      temporary work files.                   *
  *                                                              *
  *                         Example: TEMP_UNITNAME(TMPUNIT)      *
  *                       *                                      *
  *                         TEMP_VOLUME                          *
  *                         Required: No                         *
  *                         Default: If no value is specified    *
  *                      for TEMP_VOLUME, Query Monitor work     *
  *                      files will allocate to the unit         *
  *                      defined by the TEMP_UNITNAME.           *
  *                         Description: The TEMP_VOLUME         *
  *                      parameter enables you to specify a      *
  *                      volume for allocation of Query          *
  *                      Monitor's temporary work files.         *
  *                         Syntax: TEMP_VOLUME(volume)          *
  *                        Where volume is the volume for        *
  *                      allocation of Query Monitor's temporary *
  *                      work files.                             *
  *                                                              *
  *                        Example: TEMP_VOLUME(TMPVOL)          *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to enhance the product.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI38047

Modules/Macros

• CQM#CIDC CQM#INIX CQM#PARM
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI38047

     UP16/05/26 P F605

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.