PK74184: ABEND08B RC = 00C1001D AS HPU UNLOADS A CLOB DEFINED AS A VSAM CLUSTER WITH EXTENDED AND EXTENDED ADDRESSABLE ATTRIBUTES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU unload of a CLOB ( Large OBject ) defined as a vsam
  Cluster with extended and extended addressable attributes
  ( as seen in the output of an IDCAMS LISTC ENTRY(entry ) ALL )
  fails with ABEND08B return code 00C1001D.
  EXT-ADDR.
  ADDITIONAL SYMPTOMS:
  1. HPU 220 only: The result of a DIGITS scalar function
     processed natively by HPU is incorrect when it applies on an
     expression that adds two decimal columns with same scale but
     a different precision.
     HPU 310 and 220: the DIGITS function returns an incorrect
     length when the DB2 subsystem installation variable DECARTH
     is equal to DEC15, and when the precision of the operand of
     the DIGITS function is greater than 15.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: For INZ220 only:                        *
  *                      1. For a select processed natively      *
  *                      that contains a SUBSTR scalar function  *
  *                      without the lenth parameter, the        *
  *                      output data type is VARCHAR while it    *
  *                      should be CHAR. PB 9592                 *
  *                      2. The result of a DIGITS scalar        *
  *                      function processed natively by HPU is   *
  *                      incorrect when it applies on an         *
  *                      expression that adds two decimal        *
  *                      columns with same scale but a           *
  *                      different precision. PB 9649            *
  *                      For INZ220 and INZ310:                  *
  *                      3. The DIGITS function returns an       *
  *                      incorrect length when the DB2           *
  *                      subsystem installation variable         *
  *                      DECARTH is equal to DEC15, and when     *
  *                      the precision of the operand of the     *
  *                      DIGITS function is greater than 15.     *
  *                      PB 9649                                 *
  *                      For INZ310:                             *
  *                      4. EXPRESSION EVALUATION ERROR (227)    *
  *                      issued when processing a SELECT clause  *
  *                      involving concatenation with a large    *
  *                      number of items. PB 9604                *
  *                      5. Wrong processing of substring in     *
  *                      template expressions. Irrelevant        *
  *                      msgINZT008E may be issued. PB 9625      *
  *                      6. Troubles when unloading LOB data     *
  *                      may occur  when CCSID translaction is   *
  *                      involved. ABEND U1134 when unloading    *
  *                      LOB data into CLOBF. PB 9628            *
  *                      7. The  content of a BLOBF is           *
  *                      corrupted for resulting from a CCSID    *
  *                      translation where it should be handled  *
  *                      as binary data. PB 9629                 *
  *                      8. Wrong handling of indexes with       *
  *                      RANDOM keys leads to incorrect sort     *
  *                      processing in the following two         *
  *                      situations: a. the output data is not   *
  *                      sorted as requested by the ORDER BY     *
  *                      clause, b. the ORDER CLUSTER option     *
  *                      is processed although it makes no       *
  *                      sense for there is no actual            *
  *                      clustering index. PB 9650               *
  *                      9. ABEND S08B  occurs when unloading    *
  *                      LOB data if the LOB table space is      *
  *                      defined with EXTENDED ADDRESSABILITY    *
  *                      option having CI size different from    *
  *                      4K. PB 9651                             *
  *                      10. The outpout field for DIGITS        *
  *                      (decimal_expression) is longer than     *
  *                      the actual size. This occurs if the     *
  *                      decimal_expression has a precision      *
  *                      greater than 15 and the subsystem       *
  *                      settings specify DECARTH=DEC15. PB 9654 *
  *                      11. Potential CPU loop may occur when   *
  *                      unloading LOB data. PB 9674             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Modules inztyacc and inznode were changed to avoid this
  problem.
  2. Module UDBSPXWR was changed handle the specific case where
  scales are identical but precisions are different.
  3. Module UDBSPXWR was changed handle the specific case where
  scales are identical but precisions are different.
  4. Module inzpabf was changed to allow larger expression
  handling.
  5. Module inztyacc was changed to avoid this problem.
  6. In module udbcrlob, missing intialization was added.
  7. Module inzctrlh  was changed to suppress CCSID translation
  for BLOB data.
  8. Modules osysibm, inzctrl, inzpab ere changed to check if the
  index as the RANDOM attribute and not to use a random index for
  index scan processing.
  9. Module UDBLOBR  was changed not to use DIV for VSAM access
  when extended VSAM LDS are involved.
  10. Module inznode was changed to fix the way the external
  format for the output of DIGITS is computed.
  11. Module UDBSPGBF was changed to avoid the loop.
  

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:

  UK42260 UK42261

Modules/Macros

•    INZUTILB INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK42260

     UP09/01/06 P F901

• R310 PSY UK42261

     UP09/01/07 P F901

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.