PM70048: ABENDU1132 REASON CODE 10 WITH RACF ERROR OCCURS WHEN DB2 HPU ATTEMPTS TO READ AN AUXILIARY TABLE SPACE REFERING TO XML COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Message such as follows are issued:
  ICH408I USER(DEVL7   ) GROUP(DEVLGRP ) NAME(ROBERT SMITH     )
  978
    DB2USR.DSNDBC.MYDB.MYXMLTS1.I0001.A001  CL(DATASET )
  VOL(DSK227)
    INSUFFICIENT ACCESS AUTHORITY
    FROM DB2USR.DSNDBC.DSNDB*.** (G)
    ACCESS INTENT(READ   )  ACCESS ALLOWED(NONE   )
  IEC161I 040(056,006,IGG0CLFT)-002,DEVLHPUL,UNLD1,D0010001,,, 979
  IEC161I DB2USR.DSNDBC.MYDB.MYXMLTS1.I0001.A001
  INZZ001S(0001): ABEND IN INZSTI00 - CODE=S000 U1132
  REASON=00000010
  
  This occurs when both following conditions are fullfilled:
  - An unload is requested against an XML column
  - the user running the unload does not have
    READ ACCESS authority for the LDS of the
    involved auxiliary table spaces
  
  PB11646
  ABENDU1132 U1132 1132 ABEND1132 ICH408I ICH408
  IEC161I IEC161I INZZ001S INZZ001 MSGINZZ001S
  

Local fix

• Run the unload with a userid having the READ ACCESS authority
  for the LDS of the involved auxiliary table spaces.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABENDU1132 with reason code 10       *
  *                      occurs and a RACF message occurs when   *
  *                      DB2 HPU attempts to read an auxiliary   *
  *                      table space.                            *
  *                      Message such as follows are issued:     *
  *                      ICH408I USER(DEVL7   ) GROUP(DEVLGRP )  *
  *                       NAME(JAMES WHITE         )  978        *
  *                        DB2USR.DSNDBC.DSNDB06.SYSPLUXA.       *
  *                      I0001.A001 CL(DATASET ) VOL(DSK227)     *
  *                        INSUFFICIENT ACCESS AUTHORITY         *
  *                        FROM DB2USR.DSNDBC.DSNDB*.** (G)      *
  *                        ACCESS INTENT(READ   )  ACCESS        *
  *                       ALLOWED(NONE   )                       *
  *                      ICH408I USER(DEVL7   ) GROUP(DEVLGRP )  *
  *                       NAME(JAMES WHITE         )  982        *
  *                      IEC161I 040(056,006,IGG0CLFT)-002,      *
  *                      DEVLHPUL,UNLD1,D0010001,,,  979         *
  *                      IEC161I DB2USR.DSNDBC.DSNDB06.          *
  *                      SYSPLUXA.I0001.A001                     *
  *                      INZZ001S(0001): ABEND IN INZSTI00 -     *
  *                      CODE=S000 U1132 REASON=00000010         *
  *                      This occurs when both following         *
  *                      conditions are fullfilled:              *
  *                      - An unload is requested against LOB    *
  *                      or XML columns                          *
  *                      - the user running the unload does not  *
  *                      have the READ ACCESS authority for the  *
  *                      LDS of the involved auxiliary table     *
  *                      spaces                                  *
  *                      PB 11646                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  mfunc, inzrdlds, udblobr and udbspgbf  modules were changed so
  that the supervisor mode is used before reading an auxilairy
  table space.
  

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:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK82661

     UP12/10/23 P F210

• R420 PSY UK82662

     UP12/10/23 P F210

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.