<data:blog.pageTitle/>

This Page

has moved to a new address:

https://vmvirtual.blog

Sorry for the inconvenience…

Redirection provided by Blogger to WordPress Migration Service
BIOLNX: check tablespace utilization in DB2 (v9.7)

martedì 4 dicembre 2012

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.

0 Commenti:

Posta un commento

Iscriviti a Commenti sul post [Atom]



<< Home page