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 IC95142 Status: Geschlossen

UPGRADE FROM DOWNLEVEL PERMITS OTHER CONNECTION FROM SAME USER PERFORMING
UPGRADE TO CONNECT AND CRASH THE SERVER.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
When  restore a downlevel database backup on a higher level 
instance which is quiesced we end up downgrading the upgrade 
connection from super exclusive to exclusive. This can allow 
other  connections from user performing upgrade to get through 
and crash the server. 
 
db2diag.log 
*********** 
 
 
-------------------------------- 
240 I366813102E621        LEVEL: 
Error 
PID     : 543                  TID : 140723445819136 PROC : 
db2sysc 0 
INSTANCE: xxxx                 NODE : 000            DB   : 
APPHDL  : 0-563                APPID: 
*LOCAL.xxxx.999999999999 
AUTHID  :                 HOSTNAME: testibm 
EDUID   : 588                  EDUNAME: db2agent 0 
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, 
probe:10 
MESSAGE : Error in agent servicing application with APPLICATION 
NAME: 
DATA #1 : Hexdump, 8 bytes 
0x00000002196D83F2 : 7065 726C 352E 3130 
perl5.10  <-- other connection during migration 
 
 
Stack trace: 
*********** 
0x00007FFFF00A6DBA 
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 
0x020a 
 
(/var/ibmdb2/nyuit003/sqllib/lib64/libdb2osse.so.1) 
0x00007FFFF00A6B4B ossDumpStackTraceV98 + 0x002b 
 
(/var/ibmdb2/nyuit003/sqllib/lib64/libdb2osse.so.1) 
0x00007FFFF00A1A73 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x0103 
 
(/var/ibmdb2/nyuit003/sqllib/lib64/libdb2osse.so.1) 
0x00007FFFF393ABF7 sqlo_trce + 0x0407 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF3985DE7 sqloEDUCodeTrapHandler + 0x0277 
 
(/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1)Page 7 of 31 
0x00007FFFF7BD04A0 address: 0x00007FFFF7BD04A0 ; dladdress: 
0x00007FFFF7BC1000 ; offset in lib: 0x000000000000F4A0 ; 
                (/lib64/libpthread.so.0) 
0x00007FFFF483FBD3 _ZN16sqlrlCatalogScan5fetchEv + 0x03a3 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF25C9740 
_Z23sqlrlFetchEnabledWlDefsP8sqlrr_cbPPvbPP12sqlrw_wl_def + 
0x02c0 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF23A2AD5 
_Z19sqlrwBuildWlDefListP8sqlrr_cbPP12sqlrw_wl_defPib 
+ 0x00d5 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF23A2849 _Z23sqlrwCreateCatWlDefListP8sqlrr_cb + 
0x0079 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF23ACB82 _Z22sqlrwPopulateCatWLMCbsP8sqlrr_cb + 0x0082 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF234B260 _Z15sqlrr_appl_initP8sqeAgentP5sqlca + 
0x1cd0Page 8 of 31 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF17E3DDC 
_ZN14sqeApplication20InitEngineComponentsEcP8sqeAgentP8SQLE_BWAP 
5sqlcaP2 
2SQLESRSU_STATUS_VECTORc + 0x069c 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF17E2877 
_ZN14sqeApplication13AppStartUsingEP8SQLE_BWAP8sqeAgentccP5sqlca 
Pc + 
0x0697 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF17DC0F5 address: 0x00007FFFF17DC0F5 ; dladdress: 
0x00007FFFF0597000 ; offset in lib: 0x00000000012450F5 ; 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF17DAD49 
_ZN14sqeApplication13AppLocalStartEP14db2UCinterface 
+ 0x01a9 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF1985AB0 _Z11sqlelostWrpP14db2UCinterface + 0x0020Page 
9 of 31 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF1984D7F _Z14sqleUCengnInitP14db2UCinterfacet + 0x052f 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF198404F sqleUCagentConnect + 0x038f 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1) 
0x00007FFFF1A3A6D9 
_Z18sqljsConnectAttachP13sqljsDrdaAsCbP14db2UCinterface + 0x00d9 
                (/var/ibmdb2/nyuit003/sqllib/lib64/libdb2e.so.1)
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See problem description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First Fixed in Version DB2 10.1Fix Pack 4.                   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
First Fixed in Version DB2 10.1Fix Pack 4.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC97759 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.08.2013
18.04.2014
18.04.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.4 FixList