PI92244: LOAD RESUME YES NOT COMMITTING DURING INDEX BUILD PHASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Long running UR during LOAD SHRLEVEL NONE RESUME YES LOG NO
  
  Customer ran a LOAD utility with  RESUME YES SHRLEVEL NONE LOG
  NO on a table with an NPI.  The following message was observed:
  
  
  
  DSNR035I  -ssid DSNRPBCW WARNING - UNCOMMITTED UR
  AFTER n CHECKPOINTS
  CORRELATION NAME = xxxxxxxx
            CONNECTION ID  = UTILITY
            LUWID = xxxxxxx.yyyyyyyy.zzzzzzzzzzzz = nn
            PLAN NAME = DSNUTIL
            AUTHID = authid
            END USER ID = userid
            TRANSACTION NAME = tranname
            WORKSTATION NAME = wsname
  
  MSGDSNR035I
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 11 for z/OS and DB2 12 for z/OS                      *
  * users of the LOAD Utility                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Long running UR during LOAD SHRLEVEL                         *
  * NONE RESUME YES LOG NO                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Long running UR during LOAD SHRLEVEL NONE RESUME YES LOG NO
  
  Customer ran a LOAD utility with RESUME YES SHRLEVEL NONE LOG NO
  on a table with an NPI. After the index was set to PSRBDP before
  the index was rebuilt, the next commit did not occur until the
  end of index processing. MSGDSNR035I was observed.
  
  DSNR035I  -ssid DSNRPBCW WARNING - UNCOMMITTED UR
  AFTER n CHECKPOINTS
  CORRELATION NAME = xxxxxxxx
  CONNECTION ID  = UTILITY
  LUWID = xxxxxxx.yyyyyyyy.zzzzzzzzzzzz = nn
  PLAN NAME = DSNUTIL
  AUTHID = authid
  END USER ID = userid
  TRANSACTION NAME = tranname
  WORKSTATION NAME = wsname
  

Problem conclusion

• Modified LOAD to commit after an index is placed in PSRBDP.
  

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:

  UI54049 UI54050

Modules/Macros

• DSNURBXA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI54049

     UP18/03/13 P F803

• RB10 PSY UI54050

     UP18/03/13 P F803

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.