About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
How to find the name of a range partition table from the object ID referred in the db2dart report?
Answer
Below is the example of the db2dart report entry.
Table inspection start:
Data inspection phase start. Data obj: 1233 In pool: 10
Partitioned table info: Type: Partition DPID: 35 GID: (65530:32858)
The DB2DART report shows the object ID as 1233. This object ID does not exists in the syscat.tables.
When you query syscat.tables with object ID 1233, no records are selected.
db2 "select tabschema,tabname from syscat.tables where TABLEID=1233"
TABSCHEMA TABNAME
--------------------------------------------------------------------------------------------------------------------------------
0 record(s) selected.
For a range partition table the Object ID referred in db2dart is the PARTITIONOBJECTID and not the actual Object ID
You need to execute the following query to get tablename for the object
db2 "select tabname from SYSCAT.DATAPARTITIONS where PARTITIONOBJECTID=1233"
TABNAME
--------------------------------------------------------------------------------------------------------------------------------
TAB_RANGE_PART
Related Information
[{"Product":{"code":"SSFMRK","label":"IBM Smart Analytics Optimizer for Db2 for Linux, UNIX, and Windows"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"All Editions","Line of Business":{"code":"LOB18","label":"Miscellaneous LOB"}}]
Was this topic helpful?
Document Information
More support for:
IBM Smart Analytics Optimizer for Db2 for Linux, UNIX, and Windows
Software version:
Version Independent
Operating system(s):
AIX, HP-UX, Linux, Windows
Document number:
468195
Modified date:
16 June 2018
UID
swg21586273
Manage My Notification Subscriptions