Topic
1 reply Latest Post - ‏2012-11-23T19:13:38Z by nivanov1
SystemAdmin
SystemAdmin
17917 Posts
ACCEPTED ANSWER

Pinned topic db2dart on range partition table

‏2012-11-23T09:10:58Z |
Hi,

i want to check for corruption in (full) partition table which is having day wise partition and each month is having its own tablespace how can i use db2dart for this table.

thanks in advance
pradip.
Updated on 2012-11-23T19:13:38Z at 2012-11-23T19:13:38Z by nivanov1
  • nivanov1
    nivanov1
    231 Posts
    ACCEPTED ANSWER

    Re: db2dart on range partition table

    ‏2012-11-23T19:13:38Z  in response to SystemAdmin
    13- For partitioned tables, the /DD, /DM, /DEMP, /DDEL, /DP, /DXA, /DXH
    actions use partitionobjectid and tbspaceid from syscat.datapartitions
    as the input to the table object ID (/OI) and table space ID (/TSI)
    for a specific partition. The table name option (/TN) is not supported
    for these actions. ** The /T action supports the table name or logical table
    object ID when use with logical table space ID to check the entire table, **
    and also supports using partitionobjectid and tbspaceid from
    syscat.datapartitions as the input to /OI and /TSI to check a specific
    partition.