IBM Support

IC94396: Microseconds portion in RESOLUTION_TIMESTAMP is always 0

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The microseconds portion of RESOLUTION_TIMESTAMP column in the
    output of COMPILATION_ENV TABLE function is always reported as
    0. For example --
    
    $ SELECT VARCHAR(NAME, 30), VARCHAR(VALUE, 50) FROM
    TABLE(COMPILATION_ENV((SELECT COMP_ENV_DESC FROM
    TABLE(MON_GET_PKG_CACHE_STMT(NULL,
    x'00000001000000000000000000000001000000000002201307251355586770
    16', NULL, -1)) AS t))) AS s
    
    1                              2
    ------------------------------
    --------------------------------------------------
    ISOLATION                      CS
    QUERY_OPTIMIZATION             5
    MIN_DEC_DIV_3                  NO
    DEGREE                         1
    SQLRULES                       DB2
    REFRESH_AGE                    +00000000000000.000000
    RESOLUTION_TIMESTAMP           2013-07-25-13.55.58.000000
    FEDERATED_ASYNCHRONY           0
    CURRENT TEMPORAL BUSINESS_TIME 0000-00-00-00.00.00.000000000000
    CURRENT TEMPORAL SYSTEM_TIME   0000-00-00-00.00.00.000000000000
    PATH
    "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","XXXXXXXX"
    MAINTAINED_TABLE_TYPE          SYSTEM
    
      12 record(s) selected.
    
    In the above example, the microseconds part in the timestamp
    2013-07-25-13.55.58.000000 is all zeroes.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Recommended to upgrade to DB2 for LUW v97 fixpack 9.         *
    ****************************************************************
    

Problem conclusion

  • The fix is available from v97fp9 onwards.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC94396

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-25

  • Closed date

    2014-12-01

  • Last modified date

    2014-12-01

  • APAR is sysrouted FROM one or more of the following:

    IC94387

  • APAR is sysrouted TO one or more of the following:

    IT05754

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC94396

Modified date: 01 December 2014