PH57029: HISTORY COLLECTION ERROR WHEN THE ELAPSED TIME EXCEEDS 35 MINUTES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.2 only) An unload fails with completion code 8 after
  having issued the following message:
  INZI193E DB2 ERROR: FROM CLI   : SQLCODE -802 - SQLSTATE 22003
  INZI193E DB2 ERROR: FROM CLI   : {DB2 FOR OS/390}{ODBC
  DRIVER}{DSN12015}
            DSNT408I SQLCODE = -802, ERROR:  EXCEPTION ERROR FIXED
  POINT OVERFLOW HAS
                     OCCURRED DURING SYSIBM.TIMESTAMPDIFF
  OPERATION ON INTEGERD DATA,
                     POSITION
            DSNT418I SQLSTATE   = 22003 SQLSTATE RETURN CODE
            DSNT415I SQLERRP    = DSNXRINT SQL PROCEDURE DETECTING
  ERROR
            DSNT416I SQLERRD    = -203  0  0  -1  0  0 SQL
  DIAGNOSTIC INFORMATION
            DSNT416I SQLERRD    = X'FFFFFF35'  X'00000000'
  X'00000000'  X'FFFFFFFFF'
                     X'00000000'  X'00000000' SQL DIAGNOSTIC
  INFORMATION
             ERRLOC=5:10:2
  INZI193E DB2 ERROR: FROM SQLCA : SQLSTATE : 22003 SQLCODE : -802
  INZI193E DB2 ERROR: FROM SQLCA : DSNXRINT
  INZI193E DB2 ERROR: FROM SQLCA : FIXED POINT OVERFLOW
  SYSIBM.TIMESTAMPDIFF INTEGERD
  INZU592I ERROR DURING UTILITY HISTORY COLLECTION, SQL ERROR
  PREVENTED TO
           UPDATE SYSIBM.SYSUTILITIES (TERM PHASE).
           UTILITY HISTORY COLLECTION FOR THIS STEP IS SWITCHED
  OFF
  and the record of the SYSIBM.SYSUTILITIES inserted for the
  unload unduly contains NULL values for the following columns:
  - ENDTS
  - ELAPSEDTIME
  - CPUTIME
  - RETURNCODE
  - NUMOBJECTS
  This occurs when all the following conditions are fulfilled:
  - the utility history collection feature is enabled
  (VUU100/ENBHIST parmlib parameter set to UTILTIY or DETAIL or
  AS_DB2_ZPARM  with Db2  UTILITY_HISTORY zparm set to either
  UTILITY or DETAIL) and applicable (Db2 version 13 and later)
  - the elapsed time of the unload step is greater than 35 minutes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload fails with completion code 8  *
  *                      after having issued the following       *
  *                      message:                                *
  *                      INZI193E DB2 ERROR: FROM CLI   :        *
  *                        SQLCODE -802 - SQLSTATE 22003         *
  *                      INZI193E DB2 ERROR: FROM CLI   :        *
  *                                {DB2 FOR OS/390}              *
  *                                {ODBC DRIVER}{DSN12015}       *
  *                               DSNT408I SQLCODE = -802,       *
  *                                        ERROR:  EXCEPTION     *
  *                                        ERROR FIXED POINT     *
  *                                        OVERFLOW HAS          *
  *                                        OCCURRED DURING       *
  *                                        SYSIBM.TIMESTAMPDIFF  *
  *                                        OPERATION ON          *
  *                                        INTEGERD DATA,        *
  *                                        POSITION              *
  *                                DSNT418I SQLSTATE   =         *
  *                                  22003 SQLSTATE RETURN CODE  *
  *                                DSNT415I SQLERRP    =         *
  *                                  DSNXRINT SQL PROCEDURE      *
  *                                  DETECTING ERROR             *
  *                                DSNT416I SQLERRD    =         *
  *                                  -203  0  0  -1  0  0 SQL    *
  *                                  DIAGNOSTIC INFORMATION      *
  *                                DSNT416I SQLERRD    =         *
  *                                  X'FFFFFF35'  X'00000000'    *
  *                                  X'00000000'  X'FFFFFFFFF'   *
  *                                  X'00000000'  X'00000000'    *
  *                                  SQL DIAGNOSTIC INFORMATION  *
  *                                 ERRLOC=5:10:2                *
  *                      INZI193E DB2 ERROR: FROM SQLCA :        *
  *                         SQLSTATE : 22003 SQLCODE : -802      *
  *                      INZI193E DB2 ERROR: FROM SQLCA :        *
  *                         DSNXRINT                             *
  *                      INZI193E DB2 ERROR: FROM SQLCA : FIXED  *
  *                      POINT OVERFLOW SYSIBM.TIMESTAMPDIFF     *
  *                      INTEGERD                                *
  *                      INZU592I ERROR DURING UTILITY HISTORY   *
  *                               COLLECTION, SQL ERROR          *
  *                               PREVENTED TO UPDATE            *
  *                               SYSIBM.SYSUTILITIES            *
  *                               (TERM PHASE).                  *
  *                               UTILITY HISTORY COLLECTION     *
  *                               FOR THIS STEP IS SWITCHED OFF  *
  *                      and the record of the                   *
  *                      SYSIBM.SYSUTILITIES inserted for the    *
  *                      unload unduly contains NULL values for  *
  *                      the following columns:                  *
  *                      - ENDTS                                 *
  *                      - ELAPSEDTIME                           *
  *                      - CPUTIME                               *
  *                      - RETURNCODE                            *
  *                      - NUMOBJECTS                            *
  *                                                              *
  *                      This occurs when all the following      *
  *                      conditions are fulfilled:               *
  *                      - the utility history collection        *
  *                      feature is enabled (VUU100/ENBHIST      *
  *                      parmlib parameter set to UTILTIY or     *
  *                      DETAIL or AS_DB2_ZPARM  with Db2        *
  *                      UTILITY_HISTORY zparm set to either     *
  *                      UTILITY or DETAIL) and applicable (Db2  *
  *                      version 13 and later)                   *
  *                      - the elapsed time of the unload step   *
  *                      is greater than 35 minutes              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  history collection error when the elapsed time exceeds 35
  minutes
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UI94933

Modules/Macros

• INZ$$PRM INZTDSC  INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UI94933

     UP24/01/04 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.