DB2 - Problembeschreibung
Problem IC78160 | Status: Geschlossen |
DATABASE UPGRADE VIA BACKUP IMAGE WILL FAIL IF DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When upgrading a database via the RESTORE DATABASE command and the registry variable DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES is set, the command will fail with -1224. restore db sample SQL2519N The database was restored but the restored database was not upgraded to the current release. Error "-1224" with tokens "*N" is returned. DB2 is trapping with the below call stack: 0x09000000C5DCAC50 sqle_panic__Fv + 0x110 0x09000000C61720F0 sqli_set_compfnc_array__FP8sqeAgentPP14COMP_FUNC_VECTP14COMP_FUN C_VECTT3P9SQLD_IDEFP8SQLD_KEYT6PUlUl + 0xD0 0x09000000C6173FC4 sqliScanSetupCmpFunc__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBP9sqli_ scan + 0x1E4 0x09000000C6175200 sqliScanSetup__FP7SQLI_CBP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8S QLD_KEYP12SQLI_KEYDATAP9sqli_scan + 0xA00 0x09000000C61849A8 sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_ KEYDATAP9sqli_scanPi + 0x288 0x09000000C71FDF70 sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x3D0 0x09000000C7206E70 sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT 3P12SQLD_ID_LISTP9SQLP_LSN8 + 0x1510 0x09000000C644EDDC fetch__16sqlrlCatalogScanFv + 0x37C 0x09000000C6454110 fetchOneRow__16sqlrlCatalogScanFv + 0x130 0x09000000C7E5A4BC sqlrlInsertOrUpdateDBAuth__FP8sqlrr_cbPUcsUcUiT2T3T4T5T2T5 + 0x37C 0x09000000C7E5AF90 sqlrlInsertDbCreatorPrivs__FP8sqlrr_cbPUcs + 0x170 0x09000000CAA9F3AC sqlrr_handle_restore_authorities__FP8sqeAgent + 0x4AC | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users upgrading databases to DB2 Version 9.7 GA through * * Fix Pack 4 on Linux, Unix and Windows while having * * DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES set. * **************************************************************** * PROBLEM DESCRIPTION: * * When DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES is set, * * upgrading database via restoring a backup image will fail * * with -1224. * **************************************************************** * RECOMMENDATION: * * Refer to "Local Fix" or upgrade to DB2 Version v9.7 Fix Pack * * 5. * **************************************************************** | |
Local-Fix: | |
Unset DB2_RESTORE_GRANT_ADMIN_AUTHORITIES and retry the upgrade, or upgrade the database via the UPGRADE DATABASE command instead. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
The problem is first fixed in DB2 Version 9.7 Fix Pack 5. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 16.08.2011 02.01.2012 02.01.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP*, 9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |