IBM Support

How to find the name of a range partition table from the object ID referred in the db2dart report?

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

DB2DART

[{"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"}}]

Document Information

Modified date:
16 June 2018

UID

swg21586273

Page Feedback