Skip to Content
avatar image
Former Member

db2dart - /DM how to create block map for table

Insert Time Clustering Tables in DB2 LUW 10.5: ... | SCN  (page 7) suggests to use db2dart with the /DM option to create a report that contains the entries of the complete block map for a specific table.  I cannot figure out where to get the information needed for the "page number to start with", the number of pages ?  Any ideas ?

db2dart <sid> /DM with more options.  I

Dumps formatted block map data. Requires five input values: either a table object ID or table name, table space ID, page number to start with, number of pages, and verbose choice. The data shows whether a block has been reclaimed for use by the table space after a reorganization to reclaim multidimensional clustering (MDC) table blocks that were empty.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 22, 2014 at 09:43 PM

    I figured it out.  yikes  - db2dart is not user friendly at all

    db2dart XEE /DM /OI 4 /TSI 58 /PS 0 /NP 3756 /V YES

    by using db2 "select NPAGES,PARTITIONOBJECTID, tbspaceid from SYSCAT.DATAPARTItiONS where tabname = <tabname>

    Add comment
    10|10000 characters needed characters exceeded