|
Problem IC78935
|
Status: Closed |
RESTORE DATABASE WITH TRANSPORT OPTION FAILS WITH SQL0902C |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The problem occurs when using the RESTORE DATABASE command with
the TRANSPORT option to transport a table with a primary key
whose underlying index requires a rebuild. The following
warning followed by the following severe error will be reported
in the db2diag.log:
2011-09-27-10.39.42.424163-240 E103025E520 LEVEL:
Warning
PID : 7398 TID : 47580654332224PROC :
db2sysc
INSTANCE: dbuser NODE : 000 DB :
TARDB99
APPHDL : 0-65 APPID: *LOCAL.dbuser.110927143845
AUTHID : DBUSER
EDUID : 194 EDUNAME: db2agent (TARDB99)
FUNCTION: DB2 UDB, data management, sqldLoadTCB, probe:7522
MESSAGE : ADM5572I One or more indexes on table "AAAA .TAB1"
are marked
invalid and require rebuilding.
2011-09-27-10.39.42.424505-240 I103546E3488 LEVEL: Severe
PID : 7398 TID : 47580654332224PROC :
db2sysc
INSTANCE: dbuser NODE : 000 DB :
TARDB99
APPHDL : 0-65 APPID: *LOCAL.dbuser.110927143845
AUTHID : DBUSER
EDUID : 194 EDUNAME: db2agent (TARDB99)
FUNCTION: DB2 UDB, data management, sqldLockTableForInxBld,
probe:7641
MESSAGE : numIndexes not set for index recreation! |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* An error in transport tablespace causes the database to be *
* marked bad. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7.0.6. *
**************************************************************** |
| Local Fix: |
Perform the following actions:
1. Rebuild the indexes in the source database by accessing the
table with any query.
2. Take another backup of the source database.
3. Rerun the failing RESTORE DATABASE command with the new
backup image. |
| available fix packs: |
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 fixed in DB2 9.7.0.6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.09.2011
05.06.2012
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0.6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
