PI07913: ABENDS878 S878 878

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An ABENDS878 occurs if a single UNLOAD command contains at least
  two logical unloads (SELECT statements) and the following
  conditions are satisfied:
   - each of the two logical unloads involve a LOB column
     coming from two distinct tables
   - one of the logical unload is processed in SQL mode
   - one of the logical unload is processed in native mode
  as in the example below:
  
  DSN 'ME.FILES.&DB..&TS..P&PART..&UQ.'
  UNIT SYSDA SPACE(5,1) TRK
  TEMPLATE OUTLOB
           DSN MZLFRD.&DB..&TS..P&PART.(&UQ.) UNIT SYSDA
  SPACE(5,1) TRK
           DIR 5
  UNLOAD TABLESPACE
  OPTIONS REFORMAT (TYPE CLOB INTO CHAR(80) CLOBF OUTLOB)
  PARALLELISM (2,2,2)
     SELECT  COL_LOB1
     FROM ME,MYTABLE1
     OUTDDN(SYSREC01)
     SELECT COL_LOB2, COL3
     FROM ME.MYTABLE2, ME.TABLE3
     OUTDDN(SYSREC02)
  
  where COL_LOB1 and COL_LOB2 are LOB columns.
  
   PB12072 ABENDS878 S878 878 ABEND878
  

Local fix

• Separate the two logical unloads into distinct UNLOAD commands
  or add a DB2 FORCE option to make sure both logical unloads are
  processed in SQL mode (be aware that this might have an impact
  on performance though).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABENDS878 occurs if two logical      *
  *                      unloads (SELECT) from a single UNLOAD   *
  *                      command request unloading LOB columns   *
  *                      from distinct tables as in the example  *
  *                      below:                                  *
  *                      DSN 'MZLFRD.&DB..&TS..P&PART..&UQ.'     *
  *                      UNIT WORK SPACE(5,1)TRK                 *
  *                      TEMPLATE OULOB                          *
  *                               DSN MZLFRD.&DB..&TS..P&PART    *
  *                      .(&UQ.) UNIT WORK SPACE(5,1) TRK        *
  *                      DIR 5                                   *
  *                      UNLOAD TABLESPACE                       *
  *                      OPTIONS REFORMAT (TYPE CLOB INTO        *
  *                       CHAR(80) CLOBF OULOB)                  *
  *                      PARALLELISM (2,2,2)                     *
  *                         SELECT  COL_LOB1                     *
  *                         FROM ME,MYTABLE1                     *
  *                         OUTDDN(SYSREC01)                     *
  *                         SELECT COL_LOB2                      *
  *                         FROM ME.MYTABLE2                     *
  *                         OUTDDN(SYSREC02)                     *
  *                      where COL_LOB1 and COL_LOB2 are LOB     *
  *                       columns.                               *
  *                      This occurs if one of the SELECT is     *
  *                      processed in native mode and the        *
  *                      other one is processed in SQL mode.     *
  *                      PB 12072                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzpab and inzrunh modules were fixed.
  

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:

  UI14568 UI14569

Modules/Macros

•    INZ$$PRM INZTDSC  INZTPMEM INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UI14568

     UP14/02/01 P F401

• R420 PSY UI14569

     UP14/02/01 P F401

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.