IBM Support

IC74047: DB2 gets TRAP in FUNCTION CALL "GET_DBSIZE_INFO(?,?,?,0)", or SQL1226N when upgrading DB to V9.73a

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Function call "get_dbsize_info(?,?,?,0)" could result in Trap
    and log error in db2diag.log
    
    The call get_dbsize_info(?,?,?,0) is executing successful but it
    generates this trap and error in the db2diag log:
    
    2011-01-04-13.47.51.311806+660 I155485E630         LEVEL: Severe
    PID     : 23792                TID  : 140736909535568PROC :
    db2sysc 0
    INSTANCE: testinst               NODE : 000          DB   :
    
    DZSPADBA
    APPHDL  : 0-13764              APPID: *LOCAL.dbdasp.110104024717
    AUTHID  : DBA
    EDUID   : 87                   EDUNAME: db2agent (DBA) 0
    FUNCTION: DB2 UDB, RAS/PD component,
    pdResilienceIsSafeToSustain, probe:50
    MESSAGE : Trap Sustainability Criteria Failure : Nested trap
    detected during
              trap sanity check.
    DATA #1 : Hex integer, 8 bytes
    0x600000024200001F
    DATA #2 : Hex integer, 8 bytes
    0x0000000400000000
    
    2011-01-04-13.47.51.312055+660 I156116E661         LEVEL:
    Warning
    PID     : 23792                TID  : 140736909535568PROC :
    db2sysc 0
    INSTANCE: testinst               NODE : 000          DB   :
    
    DBA
    APPHDL  : 0-13764              APPID: *LOCAL.dba.110104024717
    AUTHID  : AUTHID
    EDUID   : 87                   EDUNAME: db2agent (DBA) 0
    FUNCTION: DB2 UDB, oper system services,
    sqloInvokeInterruptible, probe:20
    DATA #1 : String, 208 bytes
    An unfenced User Defined Function (UDF) was abnormally
    terminated.
    This may leave the DB2 engine in inconsistent state.
    It is recommended that DB2 server instance is stopped and
    restarted as soon as possible.
    
    Signal 11 is observed:
    
    </Siginfo_t>
    Signal #11 (SIGSEGV): si_addr is 0x00000000000000B0, si_code is
    0x00000001 (SEGV_MAPERR:Address not
    mapped to object.)
    
    ---------------------------------------------------------
    
    SQL1226N when trying to upgrade DB to V9.7 Fixpack 3a generates
    this db2diag.log output:
    
    2011-01-14-17.07.24.416122-300 I2254E301           LEVEL:
    Warning
    PID     : 17626                TID  : 47194958118832PROC : db2bp
    INSTANCE: testinst             NODE : 000
    APPID   : *LOCALtestinst.110114220500
    FUNCTION: DB2 UDB, base sys utilities, sqlemgdb, probe:10
    MESSAGE : Begin engn migration
    
    2011-01-14-17.07.24.419661-300 I2556E406           LEVEL: Info
    PID     : 13002                TID  : 47602137557312PROC :
    db2sysc 0
    INSTANCE: testinst             NODE : 000
    EDUID   : 15                   EDUNAME: db2ipccm 0
    FUNCTION: DB2 UDB, base sys utilities,
    sqeAppServices::CreateAppl, probe:100
    DATA #1 : <preformatted>
    Addr[2B4B3C7FDA50] Nodes=[1]:: Appl[0
    156]AppNodes[1],krcbNodes[1],maxNode=[0]
    
    2011-01-14-17.07.24.435074-300 I2963E485           LEVEL: Info
    PID     : 13002                TID  : 47601932036416PROC :
    db2sysc 0
    INSTANCE: testinst             NODE : 000          DB   : USAGE1
    APPHDL  : 0-156                APPID:
    *LOCAL.testinst.110114220724
    AUTHID  : MSDB2
    EDUID   : 64                   EDUNAME: db2agent (USAGE1) 0
    FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify,
    probe:1037
    RETCODE : ZRC=0xFFFFEC55=-5035 ----> Starting migration to the
    current release
    DATA #1 : unsigned integer, 4 bytes
    936
    
    2011-01-14-17.08.03.714620-300 I97620E1144         LEVEL: Error
    PID     : 13002                TID  : 47601932036416PROC :
    db2sysc 0
    INSTANCE: testinst             NODE : 000          DB   : USAGE1
    APPHDL  : 0-156                APPID:
    *LOCAL.testinst.110114220724
    AUTHID  : MSDB2
    EDUID   : 64                   EDUNAME: db2agent (USAGE1  ) 0
    FUNCTION: DB2 UDB, ABP, ABPIcoordAgent::spawnIcoordAgent,
    probe:200
    MESSAGE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
              "SQLCA has been built and saved in component specific
    control block."
    CALLED  : DB2 UDB, base sys utilities,
    sqeIcoordCB::DispatchIndependentDBAgent
    RETCODE : ZRC=0x80A90442=-2136406974=ABP_NO_AGENT
              "Maximum number of connections reached."
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -5035   sqlerrml: 0
     sqlerrmc:
     sqlerrp : SQL09073
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0x00000000      (6)
    0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
    
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    

Local fix

  • This may leave the DB2 engine in inconsistent state.
    It is recommended that DB2 server instance is stopped and
    restarted as soon as possible.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 LUW                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * CALL "GET_DBSIZE_INFO(?,?,?,0)" results in a trap.           *
    *                                                              *
    * Maximum number of connections reached (SQL1226N) when trying *
    * to upgrade DB to V9.7 Fixpack 3a.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v97fp4.                                           *
    ****************************************************************
    

Problem conclusion

  • CALL "GET_DBSIZE_INFO(?,?,?,0)" no longer traps as
    
    SNAPSHOT_CNTRFS has been changed to FENCED UDF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC74047

  • 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-01-23

  • Closed date

    2011-05-12

  • Last modified date

    2011-05-12

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC74047

Modified date: 12 May 2011