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

Crash recovery through an inplace reorg may fail with SQL1224N if a
tablespace is not available.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
If an instance crashes while an inplace reorg is in progress, if 
the tablespace in which the table that is being reorged resides 
is not available during the crash recovery, the crash recovery 
may fail with SQL1224N. 
 
The stack trace of the agent servicing the failed crash 
recovery may look like this : 
 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------ 
0x00002AAAB70ED9E5 
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 
0x0385 
                (/home/mikeho/sqllib/lib64/libdb2osse.so.1) 
0x00002AAAB70ED5EC ossDumpStackTraceV98 + 0x002c 
                (/home/mikeho/sqllib/lib64/libdb2osse.so.1) 
0x00002AAAB70E870D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00fd 
                (/home/mikeho/sqllib/lib64/libdb2osse.so.1) 
0x00002AAAB187326D sqlo_trce + 0x03ed 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB18C7F0F sqloEDUCodeTrapHandler + 0x025f 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAABD5E00 address: 0x00002AAAAABD5E00 ; dladdress: 
0x00002AAAAABC8000 ; offset in lib: 0x000000000000DE00 ; 
                (/lib64/libpthread.so.0) 
0x00002AAAB054D0D8 _Z16sqldOLRTerminateP13SQLD_DFM_WORKtmtt + 
0x0068 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB050B79B address: 0x00002AAAB050B79B ; dladdress: 
0x00002AAAAACE1000 ; offset in lib: 0x000000000582A79B ; 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB0510A4C 
_Z10sqldomUndoP8sqeAgentP10SQLDOM_LRHP9SQLP_LSN8sP15SQLD_RECOV_I 
NFO + 0x068c 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAABFDB8EC 
_Z8sqldmundP8sqeAgentP8SQLP_LRHPcP15SQLD_RECOV_INFO + 0x059c 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAF5BB5B2 
_Z8sqlptudoP8sqeAgentPmP15SQLD_RECOV_INFOP11SQLP_TENTRYP8SQLP_LR 
HPc + 0x01e2 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB19DFC02 _Z8sqlprudmP8sqeAgent + 0x0f12 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB19A5DFF _Z8sqlprbckP8sqeAgent + 0x0d6f 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB19AC98C _Z20sqlprDbBackwardPhaseP8sqeAgentRi + 0x037c 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB19AD6DD 
_Z8sqlprecmP8sqeAgentP9SQLP_LSN8Pmj10sqlprTypes + 0x052d 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB19B8E16 
_Z8sqlpresrP8sqeAgentP16sqlpRecoveryTypePbP5sqlca + 0x09d6 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB0C3C554 
_ZN16sqeLocalDatabase15RecoverDatabaseEP8sqeAgentPbS2_P5sqlca + 
0x0154 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAB0C3EB58 
_ZN16sqeLocalDatabase15RestartDatabaseEP14sqeApplicationP8sqeAge 
ntP8SQLE_BWAP22SQLESRSU_STATUS_VECTORP5sqlca + 0x02d8 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAE803AEA 
_ZN14sqeApplication20InitEngineComponentsEcP8sqeAgentP8SQLE_BWAP 
5sqlcaP22SQLESRSU_STATUS_VECTORc + 0x1e2a 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAE800351 
_ZN14sqeApplication13AppStartUsingEP8SQLE_BWAP8sqeAgentccP5sqlca 
Pc + 0x0771 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAE7F7284 
_ZN14sqeApplication13AppLocalStartEP14db2UCinterface + 0x0574 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAE9F5720 _Z11sqlelostWrpP14db2UCinterface + 0x0040 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAE9F45FC _Z14sqleUCengnInitP14db2UCinterfacet + 0x06ec 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAE9F3032 sqleUCagentConnect + 0x04d2 
                (/home/mikeho/sqllib/lib64/libdb2e.so.1)
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to 10.5.0.3                                           * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
Problem Fixed In 10.5.0.3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.11.2013
11.02.2015
11.02.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.3 FixList
10.5.0.3 FixList