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