PK96998: UNLOAD PARALLELISM ABEND 878 RC10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unload when TS has many Partitions and Parallelism is specified
  terminates with Abend878 rc10 .
  AbendS878 S878 S878-10
  Additional Symptom:
  After applying PTF for APAR PK93336 the character used for
  padding the records, when the output data set record is longer
  than the record to be unloaded, may be incorrect. Its value is
  unpredictable for it depends on the content of a non initialized
  memory area.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: For HPU 310 and 320:                    *
  *                      1. S878-10 when processing partitioned  *
  *                      TS with a very large total number of    *
  *                      partitions. The job may fail even with  *
  *                      REGION=0M specified. The fact that the  *
  *                      job fails does not depend on the number *
  *                      of unloaded partitions, only on the     *
  *                      total number of partitions of the table *
  *                      space. This fix introduces a new        *
  *                      parmlib variable that allows limiting   *
  *                      the number of partitions processed at   *
  *                      a time, and dramatically reduces the    *
  *                      memory used when unloading large        *
  *                      partitioned tablespaces.                *
  *                      PB 10340                                *
  *                      2. When a BIGINT value that comes from  *
  *                      a constant or is the result of an       *
  *                      expression is converted into another    *
  *                      data type (internal or external)        *
  *                      produces an incorrect value.            *
  *                      PB 10387                                *
  *                      3. DDLDDN: In the CREATE TABLE          *
  *                      statement, HPU only accepts the IN      *
  *                      dbname.tsname justa after the list of   *
  *                      columns of the table. The following     *
  *                      error message can be issued when the    *
  *                      IN dbname.tsname is found elsewhere:    *
  *                      INZI503E DDL ANALYSING: SYNTAX ERROR    *
  *                      AT POS(line, column)                    *
  *                      PB 10392                                *
  *                                                              *
  *                      For HPU320:                             *
  *                      4. This APAR implements in HPU 320      *
  *                      requirement MR0527084624. Support in    *
  *                      HPU syntax of null byte indicator on    *
  *                      more than 1 byte specified in SYSIN.    *
  *                      Support in BMC Unload Plus syntax of    *
  *                      NULLTYPE T2 and NULLTYPE L2.            *
  *                      PB 9349                                 *
  *                      5. CA FastUnload Syntax, when           *
  *                      OUTPUT-FORMAT FIXED is used, the LOAD   *
  *                      sysin generated in the SYSCTLnn DD      *
  *                      statement is incorrect. The nullbytes   *
  *                      have a wrong position and the fields    *
  *                      that follow any nullable field are      *
  *                      shifted on he left by 2 bytes.          *
  *                      PB 10252                                *
  *                      6. The MOD scalar function used on a    *
  *                      DECFLOAT column/expression gives an     *
  *                      incorrect result.                       *
  *                      PB 10256                                *
  *                      7. Conversion of a DECLOAT value into   *
  *                      a CHAR smaller than 42 character        *
  *                      results in truncated data.              *
  *                      PB 10257                                *
  *                      8. Various problems on DECFLOAT data:   *
  *                      - Select of a DECFLOAT constant in      *
  *                      FORMAT EXTERNAL gives an incorrect      *
  *                      value.                                  *
  *                      - Conversion of a FLOAT column into a   *
  *                      DECFLOAT EXTERNAL may give an abend     *
  *                      S0C4.                                   *
  *                      - Conversion of a DECFLOAT column into  *
  *                      another data type in DB2 FORCE may      *
  *                      give an abend U1210.                    *
  *                      PB 10312                                *
  *                      9. Error message INZU238E UNEXPECTED    *
  *                      UNSUPPORTED SELECT is issued for a      *
  *                      SELECT statement that should be         *
  *                      supported and that contains a CASE      *
  *                      predicate on a site that has            *
  *                      DECARTH=DEC15.                          *
  *                      PB 10402                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Not a bug
  2. Module udbcrfel was changed to process correctly the BIGINT
  constants/expressions.
  3. Modules oddlx2, oddlx2y and omsgsmsg were changed to accept
  the IN database.tsname a all valid locations.
  4. Not a bug
  5. Module inzctrlf  was changed to process correctly the
  position of the null indicator on 2 bytes in case of
  OUTPUT-FORMAT FIXED.
  6. Module udbcrfel was changed to process correctly the MOD
  scalar function when used whith DECFLOAT data.
  7. Module inzctrlh was changed to use left alignment when
  conversion of a DECFLOAT to a CHAR.
  8. Modules udbcrfel , inzgcxtr, inzpabf and inznode were changed
  to fix the problems found on processing of DECFLOAT data.
  9. Module inznode was changed to process correctly the CASE
  predicate on sites with DECARTH=DEC15.
  

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:

  UK54185 UK54186

Modules/Macros

•    INZRSAVE INZUTILK INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK54185

     UP10/02/13 P F002

• R320 PSY UK54186

     UP10/02/13 P F002

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.