PM21044: DB2 HPU ISSUES INZI187E ERRONEOUSLY IN DATA SHARING ENVIRONMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In a DB2 data sharing environment, if the DB2 HPU PARM option of
  the EXEC card specifies the DB2 group attachment name, HPU can
  stop after issuing msgINZI187E and msgDSN9016I on DB2 DISPLAY
  GROUP. This occurs if the user that runs the unload job does not
  have the DISPLAY authority although the user specified by
  DISPLUSR has the required authority."
  
  The problem does not occur if a PARM specifying the name of a
  subsystem (instead of the group name) is used.
  
  SAMPLE MSGS:
  
  INZI187E DB2 COMMAND ERROR, DB2 RETURN CODE: 8
           REASON CODE: 00E60820   EXPLANATION:
           DSN9016I  -DAD1 '-DISPLAY' COMMAND REJECTED,
           UNAUTHORIZED REQUEST
           DSN9023I  -DAD1 DSN9SCND '-DISPLAY GROUP'
                     ABNORMAL COMPLETION
  INZI174E ERROR WHEN TRYING TO DETERMINE ENFM STATUS.
  ---------------------------------------------------------------
  INZU281I - UNLOAD STARTING AT POS(1, 6)
  INZU277I - PROCESSING UNLOAD 00001 FROM TABLESPACE
  INZU279I - SELECT STATEMENTS USING SINGLE TABLE SPECIFICATION
  INZU280I - SELECT 00001 STARTING AT POS(4, 6)
  INZU282I   OUTPUT DDNAME=UNLDDN1
  INZI147E ERROR WHEN CLOSING UTILITY PLAN, ERROR CODE: 200
           REASON CODE: 00C10203
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x109a003)
  PB10848
  

Local fix

• The problem does not occur if a PARM specifying the name of a
  subsystem (instead of the group name) is used.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In a DB2 data sharing environment, if   *
  *                      the DB2 HPU PARM option of the EXEC     *
  *                      card specifies the DB2 group attachment *
  *                      name, HPU can stop after issuing        *
  *                      msgINZI187E and msgDSN9016I on DB2      *
  *                      DISPLAY GROUP. This occurs if the user  *
  *                      that runs the unload job does not have  *
  *                      the DISPLAY authority although the user *
  *                      specified by DISPLUSR has the required  *
  *                      authority.                              *
  *                      PB 10848                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inzctrlh and inzrun modules were fixed to use the correct DB2
  subsystem identifier.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK61474 UK61476 UK61475

Modules/Macros

•    INZI01   INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK61474

     UP10/10/25 P F010

• R320 PSY UK61475

     UP10/10/25 P F010

• R410 PSY UK61476

     UP10/10/25 P F010

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.