PK23790: HPU UNLOAD ABEND0C4 WHEN A PARTIAL SELECT ( NOT 'SELECT *' ) AND THE TABLE IS IN A TS WITH PAGES LARGER THAN 4K. PB 8024

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU may ABEND with S0C4 when
  - a "partial select" is requested ( not ' SELECT * ' )
     - the table to unload is in a tablespace having pages larger
       than 4k.
  LSCX041 **** ERROR ****
          ABEND occurred in line  1968 of @@219178(IRUN)   ,offset
  00027A
          Extended name: _inzrunUnload
  Calling trace:
      Function        Line    Offset    Context
  @@219178(IRUN)    == "_inzrunUnload"
                      1968    00027A
  @@219193(IRUN)    == "inzrunRun"
                      2256    000AB4
      MAIN(IMAIN)      796    0020BC
  PB 8024
  ADDITIONAL SYMPTOMS:
  
  
  
  
  
  
  
  
  
  1) During UNLOAD of a view with DB2 YES receive
     MSGINZU063I UNSUPPORTED SELECT :
           - SELECT *  FROM CSI.VIEW01
     MSGINZU103W DB2 YES SPECIFIED, WILL ATTEMPT DB2 PROCESSING.
     and with DB2 NO receive
     MSGINZU080E ERROR : SELECT FROM VIEW 'view.name' IS NOT
     SUPPORTED BY THE UTILITY. INZU103W INZU080E
     PB 8039
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. HPU may ABEND with S0C4 when         *
  *                       - a "partial select" is requested      *
  *                      ( not ' SELECT * ' )                    *
  *                       - the table to unload is in a          *
  *                      tablespace having pages larger than 4k. *
  *                      LSCX041 **** ERROR **** ABEND occurred  *
  *                      1968 of @@219178(IRUN)   ,offset        *
  *                      00027A  Extended name: _inzrunUnload    *
  *                      Calling trace:  Function        Line    *
  *                      Offset    Context                       *
  *                      @@219178(IRUN)    == "_inzrunUnload"    *
  *                       1968    00027A                         *
  *                      @@219193(IRUN)    == "inzrunRun"        *
  *                       2256    000AB4                         *
  *                      MAIN(IMAIN)      796    0020BC          *
  *                      PB 8024                                 *
  *                      2. During UNLOAD of a view with DB2     *
  *                      YES receive MSGINZU063I UNSUPPORTED     *
  *                      SELECT : - SELECT *  FROM CSI.VIEW01    *
  *                      MSGINZU103W DB2 YES SPECIFIED, WILL     *
  *                      ATTEMPT DB2 PROCESSING. and with DB2    *
  *                      NO receive MSGINZU080E ERROR : SELECT   *
  *                      FROM VIEW 'view.name' IS NOT SUPPORTED  *
  *                      BY THE UTILITY. INZU103W INZU080E       *
  *                      PB 8039                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module Inzbab was changed to remove an invalid optimization
  on the size of internal buffers.
  2. Module inzdyacc was changed to process correctly the CREATE
  VIEW that contains delimited identifiers.
  

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:

  UK14616 UK14617

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK14616

     UP06/05/26 P F605

• R220 PSY UK14617

     UP06/05/26 P F605

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.