home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC74047 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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:
Problem-Zusammenfassung:
**************************************************************** 
* 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.                                           * 
****************************************************************
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.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
CALL "GET_DBSIZE_INFO(?,?,?,0)" no longer traps as 
 
SNAPSHOT_CNTRFS has been changed to FENCED UDF.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.01.2011
12.05.2011
12.05.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList