Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question