PI86313: CORRECT LONG RUN TIMES THAT CAN RESULT WHEN A CONVERSION BETWEENTHE SYSREC AND TABLE OCCURS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When UET encounters an incompatibility between the table
  definition and the SYSREC, a sort order with reduced precision
  is the result. If large volumes of SYSREC are present an
  out-of-sort-order conditions occurs and DB2 Load switches to
  insert mode. This can result in long run times. This update
  introduces data conversions to resolve this.
   .
   The supported data conversions are:
  SMALLINT, BIGINT, INTEGER, DECIMAL, CHAR, CHAR Mixed, VARCHAR,
  VARCHAR Mixed, DATE, TIME, TIMESTAMP.
   .
   The unsupported data conversions are:
  BINARY, VARBINARY, TIMESTAMP WITH TIMEZONE, GRAPHIC, VARGRAPHIC,
  FLOAT, DECFLOAT, STRIP, Decimal when the ZPARM setting
  DECIMAL=Comma is set.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Utilities Enhancement Tool      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When UET encounters an                  *
  *                      incompatibility between the table       *
  *                      definition and the SYSREC, a sort       *
  *                      order with reduced precision is the     *
  *                      result. If large volumes of SYSREC      *
  *                      are present an out-of-sort-order        *
  *                      conditions occurs and DB2 Load          *
  *                      switches to insert mode. This can       *
  *                      result in long run times. This update   *
  *                      introduces data conversions to resolve  *
  *                      this.                                   *
  *                                                              *
  *                      The supported data conversions are:     *
  *                      SMALLINT, BIGINT, INTEGER, DECIMAL,     *
  *                      CHAR, CHAR Mixed, VARCHAR,              *
  *                      VARCHAR Mixed, DATE, TIME, TIMESTAMP.   *
  *                                                              *
  *                      The unsupported data conversions are:   *
  *                      BINARY, VARBINARY,                      *
  *                      TIMESTAMP WITH TIMEZONE, GRAPHIC,       *
  *                      VARGRAPHIC, FLOAT, DECFLOAT, STRIP,     *
  *                      Decimal when the ZPARM setting          *
  *                      DECIMAL=Comma is set.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to fix this problem
  

Problem conclusion

• Apply the PTF for problem resolution
  

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:

  UI50733

Modules/Macros

•    ABP$$PRM ABPADPLC ABPGSRVS ABPMSGEN ABPPCHCK
  ABPPCOPY ABPPDITB ABPPDOBJ ABPPEXEC ABPPFSPC ABPPLIST ABPPLOAD
  ABPPOPTS ABPPQUIS ABPPREBU ABPPRECO ABPPREOR ABPPRUNS ABPPSTMT
  ABPPTMPL ABPPUNLD ABPPUTLM ABPPUTLU ABPPUTLX ABPSCSRV ABPSINIT
  ABPUFSPC ABPUMAIN ABPUSE15 ABPUSE35 ABPVS20I
  

Fix information

• Fixed component name

  DB2 UTIL ENHANC

• Fixed component ID

  5655T5800

Applicable component levels

• R220 PSY UI50733

     UP17/10/04 P F710

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.