IBM Support

IC79620: USER'S ROUTINE MAY BE TERMINATED ABNORMALLY IF SOME SYSTEMROUTINES WERE RUN IN DB2FMP BEFORE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • User's routine was terminated abnormally when the system
    routines in the library db2dbroutext were run. The library was
    loaded into the db2fmp process.
    Typically, the health monitor may run the routine internally.
    
    In the db2diag.log, we would see SQL1224N(0xFFFFFB38) and
    SQL1131N(0xFFFFFB95), and the messages like this.
    
    2011-07-01-07.15.31.863793+540 I119867E509         LEVEL: Error
    PID     : 21361                TID  : 46912812083520PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000          DB   : TESTDB
    APPHDL  : 0-15872              APPID:
    xxx.xxx.xx.x.xxxxx.xxxxxxxxxxxx
    AUTHID  : db2inst1
    EDUID   : 69                   EDUNAME: db2agent (TESTDB)
    FUNCTION: DB2 UDB, routine_infrastructure,
    sqlerInvokeFencedRoutine, probe:40
    DATA #1 : Hex integer, 4 bytes
    0x8136001C
    DATA #2 : Hex integer, 4 bytes
    0xFFFFFB38
    
    2011-07-01-07.15.31.864001+540 I120377E509         LEVEL: Error
    PID     : 21361                TID  : 46912812083520PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000          DB   : TESTDB
    APPHDL  : 0-15872              APPID:
    xxx.xxx.xx.x.xxxxx.xxxxxxxxxxxx
    AUTHID  : db2inst1
    EDUID   : 69                   EDUNAME: db2agent (TESTDB)
    FUNCTION: DB2 UDB, routine_infrastructure,
    sqlerInvokeFencedRoutine, probe:45
    DATA #1 : Hex integer, 4 bytes
    0x8136001C
    DATA #2 : Hex integer, 4 bytes
    0xFFFFFB95
    
    2011-07-01-07.15.32.167129+540 E132474E393         LEVEL: Error
    PID     : 21359                TID  : 46912698837312PROC :
    db2wdog
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 2                    EDUNAME: db2wdog
    FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler,
    probe:15
    DATA #1 : <preformatted>
    A non-EDU child crashed. Process id: 31059, OSS term code:
    0x102, signal: 9
    
    2011-07-01-07.15.32.167620+540 E132868E3477        LEVEL: Severe
    PID     : 21361                TID  : 46912812083520PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000          DB   : TESTDB
    APPHDL  : 0-15872              APPID:
    xxx.xxx.xx.x.xxxxx.xxxxxxxxxxxx
    AUTHID  : db2inst1
    EDUID   : 69                   EDUNAME: db2agent (TESTDB)
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerReturnFmpToPool,
    probe:900
    DATA #1 : String, 50 bytes
    Marking fmp as unstable, fmp is forced or aborted:
    .......
    

Local fix

  • Not available.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All who run user routine.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * As same as Error description.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 9.7 FixPack 6.                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 FixPack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79620

  • 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

    2011-11-04

  • Closed date

    2012-02-21

  • Last modified date

    2012-03-05

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

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

    IC84376

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC79620

Modified date: 05 March 2012