2011-06-20

ER

[ER신규테이블추가작업]
1.운영 edpmpp에 추가
2.운영 etetc에 추가
3.DR rtetc에 추가
4.운영 stop ext edpmpp
5.운영 stop ext etetc
6.DR INFO REP RTETC에서 Checkpoint Lag: 0K 이면 STOP REP RTETC
7.운영 start ext etetc
8.운영 start ext edpmpp
9.DR start rep rtetc

[ER HANDLECOLLISIONS 샘플 예]
1.오픈하는게 모두 없는지 확인

TACL >EOFINFO $*.LPRODDAT.TBSETL
--------------------------------------------------------------------------------
FILENAME OPEN CODE EOF FULL PRI SEC MAX ALLOC
--------------------------------------------------------------------------------
$DATA27.LPRODDAT.TBSETL 0 1506385920 7 30000 20000 500 71
$DATA26.LPRODDAT.TBSETL 0 3250925568 15 30000 20000 500 86
$DATA25.LPRODDAT.TBSETL 0 2329366528 11 30000 20000 500 57
$DATA24.LPRODDAT.TBSETL 0 1852510208 9 30000 20000 500 45
$DATA23.LPRODDAT.TBSETL 0 2208677888 10 30000 20000 500 54
$DATA22.LPRODDAT.TBSETL 0 2268676096 11 30000 20000 500 55
$DATA05.LPRODDAT.TBSETL O 0 2958569472 14 30000 20000 500 87
$DATA04.LPRODDAT.TBSETL 0 256671744 1 30000 20000 500 10

2. LAG가 없는지 확인
GGSCI > START REP ZLOGA
GGSCI > INFO REP ZLOGA
GGSCI (\AUTDM00) 1711> INFO ZLOGA
Replicat ZLOGA Last Started 2012-04-17 10:49 Status STOPPED
Process $GGR03 Checkpoint Lag: 1 files, 00:00:20 (updated 17:55:47 ago)
Log Read Checkpoint \AUTDM00.$DATA40.GGSDATA.GA000004
2012-04-17 23:05:07, RBA 96142227

3.HANDLECOLLISIONS 주석 처리
GGSCI> TEDIT PARAM ZLOGA ' 에서 HANDLECOLLISIONS 주석처리하고
GGSCI> SEND REP ZLOGA,NOHANDLECOLLISIONS '수행





댓글 없음:

댓글 쓰기