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

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Similar to APAR PM70048, but for LOB column rather than XML
  column.
  An ABENDU1132 with reason code 10 occurs and a RACF message
  occurs when DB2 HPU attempts to read an auxiliary table space
  related to a LOB column.
  
  Messages such as the following are issued:
  ICH408I USER(DEVL7 ) GROUP(DEVLGRP ) NAME(ROBERT SMITH  ) 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   )
  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 the following conditions are fullfilled:
  - An unload is requested against a LOB column
  - the user running the unload does not have  READ ACCESS
    authority for the LDS of the involved auxiliary table space
  
  ABENDU1132 U1132 1132 ABEND1132 ICH408I ICH408
  IEC161I IEC161I INZZ001S INZZ001 MSGINZZ001S
  PB11662
  

Local fix

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

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 related to a LOB column.    *
  *                      Message such as follows are issued:     *
  *                      ICH408I USER(DEVL7   ) GROUP(DEVLGRP    *
  *                       ) NAME(ROBERT SMITH        )  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   )                       *
  *                      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 a LOB  *
  *                       column                                 *
  *                      - the user running the unload does not  *
  *                       have the READ ACCESS authority for     *
  *                       the LDS of the involved auxiliary      *
  *                       table space                            *
  *                      pb11662                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The modules udblobr, udbspgbf and infzap were fixed.
  

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

•    INZCRXSM
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK92934

     UP13/03/30 P F303

• R420 PSY UK92935

     UP13/03/30 P F303

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.