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: |
****************************************************************
* 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. *
**************************************************************** |
