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
[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.