|
Problem IC95372
|
Status: Closed |
DB2CAT FAILS TO GENERATE A NEW PACKED DESCRIPTOR (-G OPTION) IN DB2 V10.1, WHEN TABLE HAS INDEXES |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
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 Fixed In 10.5.0.3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
30.04.2014
30.04.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
