DB2 - Problembeschreibung
Problem IC71052 | Status: Geschlossen |
INSTANCE CRASH CAN BE CAUSED BY DATABASE MIGRATION FROM DB2 V9.1 TO V9.7 OF DB BACKUP IMAGE INCLUDING XML COLUMN | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When database restore is attempted on DB2 V9.7 with the older version of backup ( from V9.1 ) which includes XML column tables, the restoring database can fail with SQL2519N error and the instance goes to down during database migration phase. The database migration command also fails with SQL1224N error and the instance goes to down. db2diag.log shows XMLRN_RC_BUFFER_TOO_SMALL error in sqlrlmUpgradeXmlrnStatsPathV9 duringmigrating catalog table: SYSTABLES as below.. 2010-08-13-18.03.42.192034-240 I949473E489 LEVEL: Warning PID : 27210 TID : 47086397548864PROC : db2sysc 0 INSTANCE: XXXX NODE : 000 DB : XXXX APPHDL : 0-249 APPID: *XXXX AUTHID : XXXX EDUID : 202 EDUNAME: db2agent (XXXX ) 0 FUNCTION: DB2 UDB, catalog migration, sqlrlm_catalog_migrate, probe:4945 DATA #1 : <preformatted> Begin migrating catalog table: SYSTABLES 2010-08-13-18.03.45.114604-240 I949963E1577 LEVEL: Severe PID : 27210 TID : 47086397548864PROC : db2sysc 0 INSTANCE: XXXX NODE : 000 DB : XXXX APPHDL : 0-249 APPID: *LOCAL.nytit011.100813215255 AUTHID : XXXX EDUID : 202 EDUNAME: db2agent (XXXX ) 0 FUNCTION: DB2 UDB, catalog migration, sqlrlmUpgradeXmlrnStatsPathV9, probe:30 MESSAGE : ZRC=0x82A4007C=-2103181188=XMLRN_RC_BUFFER_TOO_SMALL "buffer too small" DIA11100E An XML runtime node manager error has occurred. "". DATA #1 : String, 4 bytes none CALLSTCK: [0] 0x00002AD0EAAC93FA pdLog + 0x398 [1] 0x00002AD0ED0B72A8 _Z15xmlrnLogErrorRcmiiPc + 0xD6 [2] 0x00002AD0ECB155CC _Z29sqlrlmUpgradeXmlrnStatsPathV9P8sqlrr_cbPcjPjS2_PP14XmlrnStat sPath + 0xFE [3] 0x00002AD0ECB16680 _Z28sqlrlmXmlrnStatsUnpackDescV9P8sqlrr_cbPcjPjS2_PP10XmlrnStats + 0x310 [4] 0x00002AD0ECB162A1 _Z25sqlrlmUpgradeXmlrnStatsV9P8sqlrr_cbPcjPjPP14XmlrnStatsInfo + 0x275 [5] 0x00002AD0ECB145E5 _Z23sqlrlmXmlrnStatsUpgradeP8sqeAgentP14v95sqlrg_genpdPPcPj + 0x8F [6] 0x00002AD0ECB13DD1 _Z24sqlrlm_95toCobra_tablepdP8sqeAgenttPcP10SQLD_ VALUEP8sqlr_tidP11v95sqlrg_pdmP20vCobrasqlrg_2pt_namePS1_Pj + 0xF43 [7] 0x00002AD0ECA3B796 _Z26sqlrlm_95toCobra_systablesP8sqeAgenttP10SQLD_ VALUEP8sqlr_tidPcPS5_PlPbS8_ + 0x384 [8] 0x00002AD0ECAE7959 _Z19sqlrlm_catalogFixupP8sqlrr_cbtllm17sqlrlm_cat ChangesPc8sqlr_tidPS3_P18sqlrlm_runstatsCmd + 0x1243 [9] 0x00002AD0EC9524EC _Z22sqlrlm_catalog_migrateP8sqeAgentsP5sqlca + 0x1570 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * INSTANCE CRASH CAN BE CAUSED BY DATABASE MIGRATION FROM DB2 * * V9.1 TO V9.7 OF DB BACKUP IMAGE INCLUDING XML COLUMN * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fixpak 3. * **************************************************************** | |
Local-Fix: | |
N/A | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 V9.7 Fixpak 3. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC72983 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.09.2010 29.04.2011 29.04.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |