|
Problem IC78160
|
Status: Closed |
DATABASE UPGRADE VIA BACKUP IMAGE WILL FAIL IF DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
The problem is first fixed in DB2 Version 9.7 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.08.2011
02.01.2012
02.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP*,
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
