logo

Vinchin Blog

Vinchin Blog View table space usage information via DB2 partitioned database

View table space usage information via DB2 partitioned database

2021-08-20

1. Through db2_all, and then use the editor to view


Db2_all "connect to dbname;db2 list tablespaces show detail"


2. Format processing through the sysibmadm.SNAPTBSP_PART table function


Select

char(TBSP_NAME,50) as TBSP_NAME,

TBSP_USABLE_PAGES,

TBSP_USED_PAGES,

1.00*TBSP_USED_PAGES/TBSP_USABLE_PAGES

DBPARTITIONNUM

from sysibmadm.SNAPTBSP_PART

order by TBSP_NAME,DBPARTITIONNUM

  • Tag:
  • Trending

Interested Blogs More

DOWNLOAD NOW YOU CAN ENJOY A 60-DAYS FULL-FEATURED FREE TRIAL !