PI91355: CODE=S0C7 U0000 REASON=00000000 AND UNPREDICTABLE FAILURES IF TABLESPACE WITH CISIZE DIFFERENT FROM PAGE SIZE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ABEND or another unpredictable failure occurs
  when unloading a table space in native mode if the following
  conditions are fulfilled:
  - the table space CI size is different from its PAGE size
    (in other words, the tablespace bufferpool is not a 4K
    bufferpool and the DB2 parameter CONTROL INTERVAL
    (parameter on installation panel DSNTIP7) is set to NO)
  - the tablespace is either compressed or versioned
  
    SRB ABEND - CODE=S0C7 U0000 REASON=00000000
     PSW AT TIME OF ERROR  077C2001   BE904A84  ILC 4  INTC 07
       DATA AT PSW  3E904A7E - 00E2B263  00E4A714  FFFEA7B4
       GR 0: 00000000_00004300   1: 00000050_84F2D000
          2: 00000000_42D361B4   3: 00000000_3E9058D8
          4: 00000000_426BD5E2   5: 00000000_00000065
          6: 00000000_00000000   7: 00000000_426C0F06
          8: 00000000_3E904A00   9: 00000000_3E902D68
          A: 00000000_426BD5DC   B: 00000050_84F0F730
          C: 00000050_84F0F4B0   D: 00000000_42D28280
          E: 00000000_42D361B4   F: 00000000_00004000
    END OF SRB ABEND
  
  Customers have also reported 0C4 and 0C1 like the following.
  
  INZZ001S(0004): ABEND IN ........ - CODE=S0C4 U0000
  REASON=00000038
  
  INZZ001S(0021): ABEND IN ******** - CODE=S0C1 U0000
  REASON=00000001
  
  ABENDS0C7 ABEND0C7 S0C7 0C7
  ABENDS0C4 ABEND0C4 S0C4 0C4
  ABENDS0C1 ABEND0C1 S0C1 0C1
  
  PB51337
  

Local fix

• Run the unload in SQL mode.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of High Performance Unload                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An ABEND or another unpredictable failure occurs when        *
  * unloading a table space in native mode if the following      *
  * conditions are fulfilled:                                    *
  *                                                              *
  * -  the table space CI size is different from its PAGE size   *
  * (in other words, the tablespace bufferpool is not a 4K       *
  * bufferpool and the DB2 parameter CONTROL INTERVAL (parameter *
  * on installation panel DSNTIP7) is set to NO)                 *
  *                                                              *
  * -  the tablespace is either compressed or versioned          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF for problem resolution                         *
  ****************************************************************
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UI52999

Modules/Macros

• INZTDSC  INZ$$PRM INZUTILK INZTVAR
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI52999

     UP18/01/09 P F801

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.