|
Problem IC72083
|
Status: Closed |
AUTOMATIC REORG FOR INDEX FAILED WITH -2205 DUE TO MISSING OF SCHEMA NAME. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Users may see the following information in db2diag.log:
2010-09-24-03.09.40.350836-240 I2023046A716 LEVEL: Error
PID : 1245372 TID : 1211 PROC : db2acd
0
INSTANCE: db2nbp NODE : 000
EDUID : 1211 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Automatic Table Maintenance,
db2AutoReorgExec, probe:190
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2205 sqlerrml: 1
sqlerrmc: 1
sqlerrp : db2Reorg
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFF38 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
In SYSTOOLS.HMON_ATM_INFO table, REORG_DETAIL column will
contain the string of REORG query and the error code for
SQL2205N. The schema name is missing in the REORG statement,
which caused it failed for reorganizing indexes. |
| Problem Summary: |
Problem Description:
AUTOMATIC REORG FOR INDEX FAILED WITH -2205 DUE TO MISSING OF
SCHEMA NAME.
Problem Summary:
Users may see the following information in db2diag.log:
2010-09-24-03.09.40.350836-240 I2023046A716 LEVEL: Error
PID : 1245372 TID : 1211 PROC : db2acd
0
INSTANCE: db2nbp NODE : 000
EDUID : 1211 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Automatic Table Maintenance,
db2AutoReorgExec, probe:190
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2205 sqlerrml: 1
sqlerrmc: 1
sqlerrp : db2Reorg
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFF38 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
In SYSTOOLS.HMON_ATM_INFO table, REORG_DETAIL column will
contain the string of REORG query and the error code for
SQL2205N. The schema name is missing in the REORG statement,
which caused it failed for reorganizing indexes. |
| Local Fix: |
n/a |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 |
Problem is first fixed in Version 9.7 Fixpack 4 |
| Workaround |
n/a |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.10.2010
29.04.2011
29.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
