PM31681: S0C4 , U1017 OR OTHER ABEND DURING LOGICAL UNLOAD IN NON NATIVE MODE UNLROWSET OR ULROWSET > 1 AND DB2 V8 OR HIGHER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ABEND might occur during a logical unload (SELECT) performed
  in non native mode where the following conditions are
  fullfilled:
     - rowset fetch is enabled (UNLROWSET or ULROWSET > 1 and
       DB2 release is V8 or higher)
     - the resulting table is empty
     - DB2 issues SQLCODE=+354
      (cannot be seen within the HPU ouptut)
  S0C4 is one of the possible ABENDs but the exact kind of ABEND
  is unpredictable.
  
  PB11050
  

Local fix

• Add UNLROWSET 1 to OPTIONS block of the unload statement or
  set INZTVAR parameter ULROWSET to 1.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND might occur during a logical   *
  *                      unload (SELECT) performed in non native *
  *                      mode where the following conditions are *
  *                      fullfilled:                             *
  *                       - rowset fetch is enabled (UNLROWSET   *
  *                         or ULROWSET > 1 and DB2 release is   *
  *                         V8 or higher)                        *
  *                       - the resulting table is empty         *
  *                       - DB2 issues SQLCODE=+354 (cannot be   *
  *                         seen within the HPU ouptut)          *
  *                                                              *
  *                      S0C4 is one of the possible ABENDs but  *
  *                      the exact kind of ABEND is              *
  *                      unpredictable.                          *
  *                                                              *
  *                      Local fix: Add UNLROWSET 1 to the       *
  *                      unload statement (not available in HPU  *
  *                      3.1) or set INZTVAR parameter ULROWSET  *
  *                      to 1.                                   *
  *                      PB 11050                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inzcrxsm was changed to check if at least one row is returned
  by the multi-row fetch.
  

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:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK65291

     UP11/03/08 P F103

• R410 PSY UK65292

     UP11/03/08 P F103

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.