|
Problem IT17672
|
Status: Closed |
DB2CAT -G DOES NOT GENERATE A USABLE PACKED DESCRIPTOR FOR PARTITIONED TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When using db2cat -g to generate a new Packed Descriptor for a
partitioned table (with indexes) the result Packed descriptor
generated will have incorrect fields.
If it is used with -r , drop table or access to the table will
fail with
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "itoken is invalid".) SQLSTATE=58004
FUNCTION: DB2 UDB, buffer pool services, sqlbDMScheckObjAlloc,
probe:825
MESSAGE : ZRC=0x8402001A=-2080243686=SQLB_EMP_MAP_INFO_END "EMP
MAP INFO END"
DATA #1 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
Obj: {pool:0;obj:65535;type:0} Parent={0;65535}
lifeLSN: 0000000000000010
tid: 0 0 0
extentAnchor: 1
initEmpPages: 0
poolPage0: 0
poolflags: 3102
objectState: 27
lastSMP: 0
pageSize: 8192
extentSize: 4
bufferPoolID: 1
partialHash: 4294901760
bufferPool: 0x00007fedf5764900
pdef: 0x00007ffaf801abe0
DB2 support will have to manually correct the Packed descriptor. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 10.5 Fix Pack 9 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in Db2 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.10.2016
29.09.2017
29.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
