check tablespace utilization in DB2 (v9.7)

[tsminst1@omer ~]$ db2 connect to tsmdb1

   Database Connection Information

 Database server        = DB2/LINUXX8664 9.7.5
 SQL authorization ID   = TSMINST1
 Local database alias   = TSMDB1

[tsminst1@omer ~]$ db2 “select substr(tbsp_name,1,30) as Tablespace_Name, tbsp_type as Type,
> substr(tbsp_state,1,20) as Status, (tbsp_total_size_kb / 1024 ) as Size_Meg,
> smallint((float(tbsp_free_size_kb)/ float(tbsp_total_size_kb))*100)as Percent_Free_Space,
> int((tbsp_free_size_kb) / 1024 )as Meg_Free_Space from sysibmadm.tbsp_utilization”
;

TABLESPACE_NAME                TYPE       STATUS               SIZE_MEG             PERCENT_FREE_SPACE MEG_FREE_SPACE
—————————— ———- ——————– ——————– —————— ————–
SYSCATSPACE                    DMS        NORMAL                                192                  6             12
TEMPSPACE1                      SMS        NORMAL                                118                  0              0
USERSPACE1                      DMS        NORMAL                              15520                  0             24
TSMTEMP                           SMS        NORMAL                                  0                  0              0
IDXSPACE1                         DMS        NORMAL                              44224                  0             25
LARGESPACE1                   DMS        NORMAL                               8832                  0             20
LARGEIDXSPACE1           DMS        NORMAL                               7904                  0             21
LGTMPTSP                         SMS        NORMAL                                  4                  0              0
SYSTOOLSPACE                DMS        NORMAL                                 32                 94             30
SYSTOOLSTMPSPACE     SMS        NORMAL                                  0                  0              0
REPLTBLSPACE1               DMS        NORMAL                                 32                 82             26
REPLIDXSPACE1               DMS        NORMAL                                 32                 85             27
  12 record(s) selected.

check tablespace utilization in DB2 (v9.7)

Leave a Reply

Your email address will not be published.