|
Problem IT17673
|
Status: Closed |
DB2CAT -G DOES NOT GENERATE A USABLE PACKED DESCRIPTOR FOR PARTITIONED TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - 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 11.1 Mod 2 Fix Pack 2 or higher *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 11.1 Mod 2 Fix Pack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.10.2016
23.06.2017
23.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
