PI07914: INZU168E INZU366I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload fails with completion code 8 after having issued the
  following messages :
  
  INZU168E ERROR WHEN READING DEFAULT VALUE IN CATALOG FOR
           COLUMN column-name
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x121a002)
  
  This occurs if the column indicated in the message is a
  timestamp column defined with the WITH DEFAULT
  'yyyy-mm-dd-24.00.00.000000' attribute where yyyy-mm-dd stands
  for any valid date regardless of the SQLACCES parameter setting.
  
   PB12079 MSGINZU168E MSGINZU168 INZU168E INZU168
           MSGINZU366I MSGINZU366 INZU366I INZU366
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload fails with completion code    *
  *                      8 after having issued the following     *
  *                      messages :                              *
  *                      INZU168E ERROR WHEN READING DEFAULT     *
  *                       VALUE IN CATALOG FOR COLUMN            *
  *                       column-name                            *
  *                      INZU366I UTILITY RETURN CODE 8          *
  *                       (REASON CODE 0x121a002)                *
  *                      This occurs if the column indicated in  *
  *                      the message is a timestamp column       *
  *                      defined with the WITH DEFAULT           *
  *                      'yyyy-mm-dd-24.00.00.000000' attribute  *
  *                      where yyyy-mm-dd stands for any valid   *
  *                      date regardless of the SQLACCES         *
  *                      parameter setting.                      *
  *                      PB 12079                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The infcnv00 module was 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:

Modules/Macros

•    INZTDSC  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.