PI75543: SQLCODE -904 REASON 00C9009C TYPE 00000210 DURING HIGH CONCURRENT RANDOM INSERT TO PBG

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Insert job was interrupted with reason code 00C9009C on a PBG
  object with more parts available to be added for more insert
  activities.
  
  Additional Keyword: DB2IAG2/K IAG2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 for z/OS V12 users of Insert Algorithm 2.            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When inserting into a table space defined as Partition By    *
  * Growth (PBG), one partition was filled up to the end, but    *
  * this information was not communicated properly, causing      *
  * SQLCODE -904 being issued incorrectly.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• DSNISRTI is modified to prevent the issuing of SQLCODE -904 when
  there are more space for insert transaction.
  

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:

  UI44908

Modules/Macros

• DSNISRTI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI44908

     UP17/03/07 P F703

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.