<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: dicembre 2012

BIOLNX

martedì 18 dicembre 2012

SVC and Global Mirror Whit Change Volumes

In recent days I have configured and activated LBGM I read this redbook
and the implementation is easy. Now I have a replica every 12H

To check the last volume main change that has finished copying to the secondary site:

- Connect to SVC using CLI
- type :
IBM_2145:SVCMO:admin>lsrcconsistgrp PAUL

 and Freeze_time is the timestamp of the last completed copying
freeze_time 2012/12/18/05/02/22


Etichette: , , ,

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.