| adding checkpoint table [message #641889] |
Wed, 26 August 2015 18:26  |
 |
eswararaodba@gmail.com
Messages: 3
Registered: July 2015
|
Junior Member |
|
|
Hi Team,
We created replicate process with nodbcheckpoint Option by using below command.
ADD REPLICAT REP1234, EXTTRAIL /opt/app/prod/ggs/ab, begin now, nodbcheckpoint
Now I am looking to add check point table for above replicate with below command. However I facing error.
step 1:
GGSCI > add checkpointtable ggsuser.CHKPT_REP1234
Successfully created checkpoint table ggsuser.CHKPT_REP1234.
Step 2:
GGSCI > ALTER REPLICAT REP1234, NONINTEGRATED, CHECKPOINTTABLE ggsuser.CHKPT_ REP1234
ERROR: Invalid parameter specified for ALTER REPLICAT.
Can you please help me here to add check point table without drop and recreate of replicate process and it won't be any impact for data loss.
Thanks
Eswar
|
|
|
|
| Re: adding checkpoint table [message #645917 is a reply to message #641889] |
Wed, 16 December 2015 05:07  |
 |
ssumesh
Messages: 5
Registered: May 2015
Location: delhi
|
Junior Member |
|
|
hi
the correct sequence for adding chkpt table to your rep should be.
create new chkpt table. (you have already created)
stop replicat
info replicat detail (note down current trail LOGSEQNO and EXTRBA
delete replicat
ADD REPLICAT REP1234, EXTTRAIL <trail_name>, BEGIN EXTSEQNO <seq_no> EXRBA <rba>, CHECKPOINTTABLE owner.table
start replicat
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
