|
Problem IC96117
|
Status: Closed |
POST UPGRADE TO V10.5 DDL ON TABLE HAVING TEXT INDEX MAKES THE TABLE UNUSABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Post Upgrade to v10.5 , a DDL on an Upgraded table having Text
Index , can corrupt the table pd, making the table unusable
example.
$ db2 "select count(*) from myschema.tb1"
1
-----------
5
1 record(s) selected.
$ db2 "create index myschema.idx4 on myschema.tb1(C4 asc)"
DB20000I The SQL command completed successfully.
$ db2 "select count(*) from myschema.tb1"
SQL0727N An error occurred during implicit system action type
"2".
Information returned for the error includes SQLCODE "100",
SQLSTATE "02000"
and message tokens "". SQLSTATE=56098
$ db2cat -d testdb -s MYSCHEMA -n TB1 -v -t
________________________________________________________________
____
_____ DB2 Relational Data Services Tools _____
I B M
DB2CAT
This tool is a utility designed to help in examining
packed
descriptor information stored in the system catalog
tables.
________________________________________________________________
____
DB2 Version 10.5, 5622-044 (c) Copyright IBM Corp. 2012
Licensed Material - Program Property of IBM
IBM DATABASE 2 Catalog Analysis and Repair Tool
Please use single quote for delimited name
Connecting to the Database.
Connect to Database Successful.
DB2 Version 10.5, 5622-044 (c) Copyright IBM Corp. 2012
Licensed Material - Program Property of IBM
IBM DATABASE 2 Catalog Analysis and Repair Tool
Please use single quote for delimited name
****************************************************************
*
Validating Packed Descriptor: MYSCHEMA.TB1
Potential corruption detected (-290).
Potential problem detected in index for colid 0.
Potential problem detected in index for colid 1.
Memory fault |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 3 or subsequent later *
* Fix Packs. If already Upgraded to v10.5 , please see Local *
* Fix *
**************************************************************** |
| Local Fix: |
None.
If the database has already been upgraded to v10.5 which does
not have this APAR fix. The table pd will have to be patched
manually. Please contact IBM support |
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem is first fixed in DB2 Version 10.5 Fix Pack 3 and all
subsequent Fix Packs. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.09.2013
08.09.2014
08.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
