PK79701: ABENDU1210

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABENDU1210
  LSCX010 **** ERROR ****
           ABEND occurred in    ABORT called from line   574 of
  @@335874(IGCT2D) ,offset 0000C6
           Extended name: _inzgct2dProcessLobTsname
           Program terminated by call to abort. ABEND code = U1210
  
  The problem occurs when the following 3 conditions are all
  true:
   -The select statement is processed using SQL access.
   -The tablespace is partitioned
    (in DB2 V9 implicit tablespaces are partitioned by growth).
   -The &TS variable is used in the TEMPLATE for XML and/or LOB
    data.
  ADDITIONAL SYMPTOMS:
  1. Getting message * FIELD OVERLAPS END OF RECORD trying
     to unload a table. When DB2 FORCE is specified it works
     OK.
  2. INZU238E UNEXPECTED UNSUPPORTED SELECT
              UTILITY CANNOT SWITCH TO SQL PROCESSING
              REASON 0Xc001c / 0X2d7fc350
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. APAR PK75504 introduced the          *
  *                      possibility to generate                 *
  *                      IDENTITYOVERRIDE in the load sysin in   *
  *                      DB2 V9. This possibility was            *
  *                      incorrectly limited to DB2 NFM while    *
  *                      this is possible in all modes (CM,      *
  *                      ENFM and NFM). This fix removes the     *
  *                      limitation and this option is not       *
  *                      available for all V9 installations.     *
  *                      PB 9678                                 *
  *                      2. Error in the text of error message   *
  *                      INZU239I. Message number displayed is   *
  *                      INZINZU239I.                            *
  *                      PB 9706                                 *
  *                      3. An unload enters an endless wait     *
  *                      state in the following case:            *
  *                      - Partitioned Table Space               *
  *                      - LOB column                            *
  *                      - Partition parallelism is activated    *
  *                      - ORDER BY or ORDER CLUSTER             *
  *                      - Single output file                    *
  *                      - One of the unloaded partitions is     *
  *                      empty.                                  *
  *                      An other symptom can be an abend        *
  *                      U1133-03.                               *
  *                      PB 9800                                 *
  *                      4. Error messages * 227 * EXPRESSION    *
  *                      EVALUATION ERROR * are issued when      *
  *                      converting SMALLINT data into a         *
  *                      DECIMAL ZONED(3,0) field.               *
  *                      This applies to the INTO clause of      *
  *                      HPU, FastUnload and Unload Plus         *
  *                      syntaxes, to the REFORMAT clause of     *
  *                      HPU syntax and to the FORMAT USER of    *
  *                      HPU syntax.                             *
  *                      PB 9818                                 *
  *                      5. Abend U1210 when unloading LOB or    *
  *                      XML into CLOBF using a TEMPLATE with a  *
  *                      CLOBF specification in the following    *
  *                      case:                                   *
  *                      The select statement is processed       *
  *                      using SQL access, the tablespace is     *
  *                      partitioned and the &TS variable is     *
  *                      used in the TEMPLATE for XML and/or     *
  *                      LOB data. In this specific case,        *
  *                      instead of replacing the &TS with       *
  *                      UNKNOWN in the templates used for XML   *
  *                      and LOB data, as described in the       *
  *                      manual, HPU tries to use a real table   *
  *                      space name. As this name has not been   *
  *                      retrieved from the DB2 catalog, an      *
  *                      abend U1210 occurs.                     *
  *                      PB 9824                                 *
  *                      6. An abend 1135 code 6 can occur       *
  *                      when a TEMPLATE used for a LOB file     *
  *                      reference using a PDS generates a       *
  *                      dsname longer than 44 characters.       *
  *                      The correct behavior is to issue an     *
  *                      error message INZT041E.                 *
  *                      PB 9873                                 *
  *                      7. Error messages *218 * FIELD          *
  *                      OVERLAPS END OF RECORD can occur in     *
  *                      DB2 V9 NFM when an UNLOAD process a     *
  *                      partitioned tablespace, when the some   *
  *                      of the partitions are in BRF (Basic     *
  *                      Row Format) and some others are in      *
  *                      problems occurs when parallelism is     *
  *                      NOT used to read the partitions, or     *
  *                      when unload is made from a global       *
  *                      Full Image copy of the tablespace.      *
  *                      This same error message can also        *
  *                      occur when unloading data just after    *
  *                      a REORG that changed BRF into RRF and   *
  *                      no QUIESCECAT is made.                  *
  *                      This APAR also fixes a potential bug    *
  *                      (potential S0C4 or other system abends) *
  *                      when invoking an EDITPROC in V9 NFM:    *
  *                      the RFMTTYPE indicator is incorrectly   *
  *                      set: for non partitioned TS, the        *
  *                      indicator is never set to RRF, and for  *
  *                      partitioned TS, it can be set to RRF    *
  *                      (x'08') even if the rows are not        *
  *                      variable length.                        *
  *                      PB 9882                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module inzrload, function inzrloadChangeColName was changed
  to also accept the new behavior in V9 CM and ENFM.
  2. Message identifier was fixed.
  3. Modules INZPAB was fixed to avoid this wait state.
  4. Module inzctrl, function inzcontrolFormateConstant, and
  module inzcol, function inzcolSubstituteDecimalType were
  changed to convert correctly smallint data into decimal in all
  cases.
  5. Module inzgct2d, function inzgct2dGenerate was changed to
  generate correctly the dsname from the TEMPLATE even when the
  name of the LOB or XML tablespace is not known.
  6. Module inzctrlh, functions inzctrlhCheckEcsLob and
  inzctrlhCheckDdn were changed to correctly check the length of
  the generated in all cases and issue error message INZT041E
  when this length is greater than 44.
  7. Module udbcrrts was changed to check the FORMAT (RRF/BRF)
  when switching to another partition for a single task on more
  than one partition of the unloaded TS or copy and not only for
  the first partitionprocessed by the task.
  Module inzqryv8 was changed to read in SQL the value ot column
  FORMAT from SYSIBM.SYSTABLEPART, when running with
  SQLACCES=MINIMAL in parmlib.
  

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:

  UK45123

Modules/Macros

•    INZQRYV8 INZQUERY INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK45123

     UP09/03/26 P F903

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.