|
Problem IC92699
|
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 / A10 - 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: *
* Upgrade to DB2 Version 10.1 Fix Pack 3. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 10.1 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC95372
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.05.2013
02.10.2013
02.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
