IBM Support

IC86889: FENCED WRAPPER GETS HANG SPORADICALLY AFTER -1131 ERROR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Fenced wrapper may get hang sporadically after a -1131 error in
    db2diag.log. For this problem, only the specific query hang and
    anything else ran fine on the server at the same time.
    
    You will see following error messages from db2diag.log:
    
    2012-09-29-02.44.53.139002-240 I1951E322           LEVEL: Severe
    PID     : 19415                TID  : 139708008859408PROC :
    db2fmp (
    INSTANCE: db2inst1              NODE : 000
    APPID   : 9.26.121.169.48208.120929064451
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerFedFmpListener,
    probe:20
    RETCODE : ZRC=0xFFFFFB95=-1131
    
    2012-09-29-02.44.53.139333-240 I2274E454           LEVEL:
    Warning
    PID     : 19415                TID  : 139708008859408PROC :
    db2fmp (
    INSTANCE: db2inst1              NODE : 000
    APPID   : 9.26.121.169.48208.120929064451
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging func, probe:0
    MESSAGE : Thread of db2fmp terminated with nonzero rc
    DATA #1 : Hexdump, 4 bytes
    0x00007F104E3D7E84 : 95FB FFFF
    ....
    
    2012-09-29-02.44.53.170265-240 I2729E373           LEVEL: Error
    PID     : 19415                TID  : 139708008859408PROC :
    db2fmp (
    INSTANCE: db2inst1              NODE : 000
    FUNCTION: DB2 UDB, drda wrapper,
    FencedDRDA_Server::get_diagnostic, probe:10
    MESSAGE : DiagRec han_type
    DATA #1 : Hexdump, 2 bytes
    0x00007F104E3D7158 : 0300
    ..
    
    The problem was introduced in v97 fix pack 5 by APAR IC76273, so
    you should not have this problem in v97 fix pack 4 or earlier.
    

Local fix

  • Set ASLHEAPSZ to a value no less than 17 and recycle db2 server.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * The users are running DRDA wrapper when ASLHEAPSZ is set to  *
    * a value less than 17.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 and Fix Pack 8.                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 Version 9.7 and Fix Pack 8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC86889

  • 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

    2012-09-29

  • Closed date

    2013-04-02

  • Last modified date

    2013-04-02

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

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

    IC89712 IC89884

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC86889

Modified date: 02 April 2013