PH48133: IKJ56231I TEXT UNIT X'0001' CONTAINS INVALID PARAMETER IF DDNAMEWITH '$'/'@'/'#' FOR DISPLAY_PARMLIB/EXPLAIN COMMANDS REPORT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload completes successfully without having produced one of
  the following dataset:
  - the dataset meant for the DISPLAY_PARMLIB feature (requested
  by specifying the DISPLAY_PARMLIB option or by setting the
  DISPPARM parmlib parameter to YES)
  - the dataset containing the report of the EXPLAIN commands run
  by Db2 HPU (VUU087/DISPEXPL set to YES)
  because of an allocation error reported through the following
  messages
     IKJ56231I UTILITY DATA SET NOT ALLOCATED, SYSTEM OR
  INSTALLATION ERROR+
     IKJ56231I TEXT UNIT X'0001' CONTAINS INVALID PARAMETER
  and the following message having been issued to the SYSPRINT
  dataset:
     INZI143E ERROR: DURING ddname ALLOCATION
  issued to the SYSPRINT dataset where ddname is similar to the
  ddname specified for the dataset in question where some
  characters have been substituted by characters such as '$', '@'
  or '#'.
  This occurs when all the following conditions are fulfilled:
  a) an output dataset is requested for the DISPLAY_PARMLIB
  feature or the report of EXPLAIN commands as follows:
  - for the DISPLAY_PARMLIB feature, the VUU083/DISPPARM  parmlib
  parameter is set to YES,ddname
  - for the report of EXPLAIN commands, the  VUU087/DISPEXPL
  parmlib parameter is set to YES,ddname and the processing of the
  unload requires an EXPLAIN command to be issued
  - with a ddname:
     - containing at least one of the characters among '$' ,'@'
  and '#'.
     - and not allocated by the JCL
  b) the code of one of the characters among '$', '@' or '#'
  contained in the ddname in the EBCDIC ccsid of the Db2 subsystem
  is different from the code of this character in CCSID 37
  

Local fix

• If applicable, consider specifying a ddname without any
  character among '$', '@' and '#'.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload completes successfully        *
  *                      without having produced one of the      *
  *                      following dataset:                      *
  *                      - the dataset meant for the             *
  *                      DISPLAY_PARMLIB feature (requested by   *
  *                      specifying the DISPLAY_PARMLIB option   *
  *                      or by setting the DISPPARM parmlib      *
  *                      parameter to YES)                       *
  *                      - the dataset containing the report of  *
  *                      the EXPLAIN commands run by Db2 HPU     *
  *                      (VUU087/DISPEXPL set to YES)            *
  *                      because of an allocation error reported *
  *                      through the following messages          *
  *                         IKJ56231I UTILITY DATA SET NOT       *
  *                                   ALLOCATED, SYSTEM OR       *
  *                                   INSTALLATION ERROR+        *
  *                         IKJ56231I TEXT UNIT X'0001' CONTAINS *
  *                                   INVALID PARAMETER          *
  *                      and the following message having been   *
  *                      issued to the SYSPRINT dataset:         *
  *                         INZI143E ERROR: DURING ddname        *
  *                                  ALLOCATION                  *
  *                      issued to the SYSPRINT dataset where    *
  *                      ddname is similar to the ddname         *
  *                      specified for the dataset in question   *
  *                      where some characters have been         *
  *                      substituted by characters such          *
  *                      as '$', '@' or '#'.                     *
  *                                                              *
  *                      This occurs when all the following      *
  *                      conditions are fulfilled:               *
  *                      a) an output dataset is requested for   *
  *                      the DISPLAY_PARMLIB feature or the      *
  *                      report of EXPLAIN commands as follows:  *
  *                      - for the DISPLAY_PARMLIB feature, the  *
  *                        VUU083/DISPPARM  parmlib parameter is *
  *                        set to YES,ddname                     *
  *                      - for the report of EXPLAIN commands,   *
  *                        the  VUU087/DISPEXPL parmlib          *
  *                        parameter is set to YES,ddname and    *
  *                        the processing of the unload requires *
  *                        an EXPLAIN command to be issued       *
  *                      - with a ddname:                        *
  *                         - containing at least one of the     *
  *                           characters among '$' ,'@' and '#'. *
  *                         - and not allocated by the JCL       *
  *                      b) the code of one of the characters    *
  *                      among '$', '@' or '#' contained in the  *
  *                      ddname in the EBCDIC ccsid of the Db2   *
  *                      subsystem is different from the code of *
  *                      this character in CCSID 37              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  IKJ56231I TEXT UNIT X'0001' CONTAINS INVALID PARAMETER if ddname
  with '$'/'@'/'#' for DISPLAY_PARMLIB/EXPLAIN commands report
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

Comments

• ×**** PE23/07/04 FIX IN ERROR. SEE APAR PH55541  FOR DESCRIPTION
  ×**** PE23/07/04 FIX IN ERROR. SEE APAR PH55541  FOR DESCRIPTION
  ×**** PE23/07/04 FIX IN ERROR. SEE APAR PH55541  FOR DESCRIPTION
  ×**** PE23/07/04 FIX IN ERROR. SEE APAR PH55541  FOR DESCRIPTION
  

APAR Information

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

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

  UI82184

Modules/Macros

• INZ$$PRM INZMQRY  INZPARM  INZTDSC  INZTOOLS INZTVAR  INZUTIB1
  INZUTIB2 INZUTILC INZUTILD INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI82184

     UP22/09/03 P F209

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.