DB2 - Problembeschreibung
Problem IC92699 | Status: Geschlossen |
DB2CAT FAILS TO GENERATE A NEW PACKED DESCRIPTOR (-G OPTION) IN DB2 V10.1, WHEN TABLE HAS INDEXES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
db2cat is not able to generate a new packed descriptor for a table with indexes: db2cat -d <DATABASE> -n <TABLE> -s <SCHEMA> -g new.pd -o db2cat2.out returns: Error during error: Select SYSINDEXES in idCreate(). Error Message = SQL0420N Invalid character found in a character string argument of the function "". SQLSTATE=22018 SQLCA Size = 136 SQLCODE = -420 Tokens = Function= SQLADRBO RC = 0x8021004C = -2145320884 Reason = 0x004C = 76 Reason2 = 0x0000 = 0 Warning flags = Press ENTER to Continue ... Error during idCreate(). Error Message = SQL0420N Invalid character found in a character string argument of the function "". SQLSTATE=22018 SQLCA Size = 136 SQLCODE = -420 Tokens = Function= SQLADRBO RC = 0x8021004C = -2145320884 Reason = 0x004C = 76 Reason2 = 0x0000 = 0 Warning flags = Note: This functionality (db2cat option -g) requires a service mode turned on, which can and should only be run on the advice of IBM DB2 Service personal. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 3. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 10.1 Fix Pack 3. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95372 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 31.05.2013 02.10.2013 02.10.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 | |
10.1.0.3 |