DB2 - Problem description
Problem IT17670 | Status: Closed |
DB2CAT -G DOES NOT GENERATE A USABLE PACKED DESCRIPTOR FOR PARTITIONED TABLE | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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: * * See SYSROUTE APARs to see where this APAR is addressed * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT17671 IT17672 IT17673 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.10.2016 09.05.2017 09.05.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |