|
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
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 |
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
|
 |
