IBM Support

IT14857: DB2 MAY HANG ON LINUX WITH SQLO_LOCALTIME

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 may hang on Linux.  db2fodc -hang may not write any stack
    file but generate a core file instead.
    From the associated core file, it may have below stack trace
    back.
    
    #0  0x0000003675cf619e in __lll_lock_wait_private () from
    /lib64/libc.so.6
    #1  0x0000003675c9cc9d in _L_lock_2163 () from /lib64/libc.so.6
    #2  0x0000003675c9ca57 in __tz_convert () from /lib64/libc.so.6
    #3  0x00007f3c77cbf165 in sqlo_localtime () from
    /db2inst1/sqllib/lib64/libdb2e.so.1
    #4  0x00007f3c793eb964 in sqloWriteTimeStamp(OSSTrapFile&) ()
    from /db2inst1/sqllib/lib64/libdb2e.so.1
    #5  0x00007f3c793eb9fd in sqloWriteTrapFileHeader(OSSTrapFile&)
    () from /db2inst1/sqllib/lib64/libdb2e.so.1
    #6  0x00007f3c793ec7ca in sqlo_trce () from
    /db2inst1/sqllib/lib64/libdb2e.so.1
    #7  0x00007f3c79439d04 in sqloDumpDiagInfoHandler () from
    /db2inst1/sqllib/lib64/libdb2e.so.1
    #8  <signal handler called>
    #9  0x0000003675cf619c in __lll_lock_wait_private () from
    /lib64/libc.so.6
    #10 0x0000003675c9cc9d in _L_lock_2163 () from /lib64/libc.so.6
    #11 0x0000003675c9ca57 in __tz_convert () from /lib64/libc.so.6
    #12 0x00007f3c75a5da86 in ossTimeLocalTime () from
    /db2inst1/sqllib/lib64/libdb2osse.so.1
    #13 0x00007f3c5c09a220 in wlmCopyGMTToTimestamp(char*, unsigned
    long, sqlo_gmt) () from
    /db2inst1/sqllib/bin/routine/db2dbrouttrusted
    #14 0x00007f3c5c0b1eef in
    monFormatConnectionMetrics(sqlmMetricOutputFunction,
    sqlrwApplicationTFMetrics*, connectionParameters&, unsigned int,
    sqlca*) () from /db2inst1/sqllib/bin/routine/db2dbrouttrusted
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 UDB Version 10.5                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 10.5 FixPack 8.                           *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 10.5 FixPack 8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT14857

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-19

  • Closed date

    2017-05-08

  • Last modified date

    2017-05-08

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA50 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.5

Reference #: IT14857

Modified date: 08 May 2017