PH21840: AFTER APAR PH19393/PB5993 FIX, JOB HANGS IF DB2 SETTINGS EBCDIC SBCS CCSID IS NOT 37 AND VUM032/ACTLGUSR NOT SET TO CURRENT_USER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.1 only) After the fix for APAR PH19393/PB5993 has been
  applied, a Db2 HPU job hangs after having only issued the
  following messages:
  
  INZU219I PTFLEVEL=apar-Znnn-internalref
  
  INZI529I THE PARMLIB PARAMETERS HAVE BEEN READ FROM:
  
  where nnn > 690.
  
  
  
  This occurs when the following conditions are fulfilled:
  
  - the unload is run against a Db2 subsystem set with an EBCDIC
  SBCS CCSID different from 37
  
  - the VUM032/ACTLGUSR parmlib parameter is not set to
  CURRENT_USER
  

Local fix

• If applicable, set VUM032/ACTLGUSR to CURRENT_USER and run the
  unload on behalf of a userid having the privileges required for
  the ""User who issues SELECT by using dynamic SQL
  (VUM032/ACTLGUSR)"".
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the fix for APAR PH19393/PB5993   *
  *                      has been applied, a Db2 HPU job hangs   *
  *                      after having only issued the following  *
  *                      messages                                *
  *                      INZU219I PTFLEVEL=apar-Znnn-internalref *
  *                      INZI529I THE PARMLIB PARAMETERS HAVE    *
  *                      BEEN READ FROM:                         *
  *                      where nnn > 690.                        *
  *                                                              *
  *                      This occurs when the following          *
  *                      conditions are fullfilled:              *
  *                      - the unload is run against a Db2       *
  *                        subsystem set with an EBCDIC SBCS     *
  *                        CCSID different from 37               *
  *                      - the VUM032/ACTLGUSR parmlib parameter *
  *                        is not set to CURRENT_USER            *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  After APAR PH19393/PB5993 fix, job hangs if DB2 settings EBCDIC
  SBCS CCSID is not 37 and VUM032/ACTLGUSR not set to CURRENT_USER
  

Problem conclusion

• Code has been changed to fix this problem.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• INZ$$PRM INZTDSC  INZTVAR  INZUTIB1 INZUTIB2 INZUTILC INZUTILK
  INZUTILL
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI68215

     UP20/03/18 P F003 {

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.