PI21191: ABENDU1136-RSN21 UNLOADING DATA FROM AN XML COLUMN, IN DB2 11 NFM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• AN ABENDU1136-RSN21 occurs when unloading the data from an XML
  column, in native mode, in a DB2 V11 NFM environment.
  
  Messages such as the following are issued:
  
  IEA995I SYMPTOM DUMP OUTPUT  339
    USER COMPLETION CODE=1136 REASON CODE=00000021
   TIME=15.37.54  SEQ=21870  CPU=0000  ASID=0029
   PSW AT TIME OF ERROR  077D1001   92D1B842  ILC 2  INTC 0D
     ACTIVE LOAD MODULE           ADDRESS=12D0C000
  OFFSET=0000F842
     NAME=INZUTILX
     DATA AT PSW  12D1B83C - 00181610  0A0DA7F4  002CA71E
     GR 0: 00000000_C4000000   1: 00000000_C4000470
        2: 00000000_12D91478   3: 00000000_12D1C2B0
        4: 00000048_00200040   5: 00000000_12D20AD0
        6: 00000048_03900040   7: 00000000_12E6D480
        8: 00000000_00001D60   9: 00000048_00200100
        A: 00000000_12D8E060   B: 00000000_000000A0
        C: 00000000_12E14D60   D: 00000000_12E6D388
        E: 00000000_0000000A   F: 00000000_00000021
   END OF SYMPTOM DUMP
  
  ABENDU1136 ABEND1136  ABEND U1136 REASON 21
  PB12392
  

Local fix

• use the SQL mode by specifying DB2 FORCE.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: AN ABENDU1136-RSN21 occurs when         *
  *                      unloading the data from an XML column,  *
  *                      in native mode, in a DB2 V11 NFM        *
  *                      environment.                            *
  *                      Messages such as the following are      *
  *                      issued:                                 *
  *                      IEA995I SYMPTOM DUMP OUTPUT  339        *
  *                       USER COMPLETION CODE=1136              *
  *                       REASON CODE=00000021                   *
  *                      TIME=15.37.54  SEQ=21870  CPU=0000      *
  *                        ASID=0029                             *
  *                      PSW AT TIME OF ERROR  077D1001          *
  *                         92D1B842  ILC 2  INTC 0D             *
  *                        ACTIVE LOAD MODULE                    *
  *                         ADDRESS=12D0C000   OFFSET=0000F842   *
  *                        NAME=INZUTILX                         *
  *                        DATA AT PSW  12D1B83C - 00181610      *
  *                         0A0DA7F4  002CA71E                   *
  *                        GR 0: 00000000_C4000000               *
  *                           1: 00000000_C4000470               *
  *                           2: 00000000_12D91478               *
  *                           3: 00000000_12D1C2B0               *
  *                           4: 00000048_00200040               *
  *                           5: 00000000_12D20AD0               *
  *                           6: 00000048_03900040               *
  *                           7: 00000000_12E6D480               *
  *                           8: 00000000_00001D60               *
  *                           9: 00000048_00200100               *
  *                           A: 00000000_12D8E060               *
  *                           B: 00000000_000000A0               *
  *                           C: 00000000_12E14D60               *
  *                           D: 00000000_12E6D388               *
  *                           E: 00000000_0000000A               *
  *                           F: 00000000_00000021               *
  *                      END OF SYMPTOM DUMP                     *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzxread and inzxmlr module were changed.
  

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:

  UI21116

Modules/Macros

•    INZUTILK INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI21116

     UP14/09/06 P F409

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.