IBM Support

IT20290: CLP MAY HANG IF IT GETS SIGNAL WHILE IT TERMINATES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If CLP get SIGNAL such as SIGHUP while it terminates, CLP may
    hang with grabbing db2diag.log or admin log, *.nfy.
    
    Example of stack trace of clp fp process for this hang:
    
    __nanosleep_nocancel
    ossLockGetConflict
    sqlnlscmsg
    sqlnlsMessage
    sqlnlsgmsg
    sqlogmsg
    loadMessage
    sqltfast2
    sqlt_logadmin
    pdDmpErrMsg
    PDLogFacility
    pdLogInternal
    pdLogSysRC
    sqloLogAndMapQueError
    sqlodque
    clp_fp_exitlist
    clp_fp_sig
    <signal handler called>
    munmap
    _ossMemFree
    sqlnlsFreeMsgFileList
    appLibInit::?appLibInit
    __cxa_finalize
    __do_global_dtors_aux
    _real_fini
    _fini
    _dl_fini
    __run_exit_handlers
    exit
    sqloexit
    clp_fp_exit
    

Local fix

  • Rename db2diag.log or notify log if it is garbed by hanging clp
    fp.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 11.1 Mod 2 Fix Pack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT20290

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-20

  • Closed date

    2017-06-23

  • Last modified date

    2017-06-23

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

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

    IT23978

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020