|
Problem IC96117
|
Status: Geschlossen |
POST UPGRADE TO V10.5 DDL ON TABLE HAVING TEXT INDEX MAKES THE TABLE UNUSABLE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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 |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem is first fixed in DB2 Version 10.5 Fix Pack 3 and all
subsequent Fix Packs. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 20.09.2013
08.09.2014
08.09.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.4
|
 |
