Hello Evyone,
We have a replicat that was created/added before my lifetime with the NODBCHECKPOINT param on Windows Server 2008R2. We are now wanting to incorporate CHECKPOINTTABLE into the replicat configuration. It appears that I am unable to ALTER an existing replicat to utilize CHECKPOINTTABLE. I have created the table on the Target MS SQLDB. If I delete and add the replicat with the CHECKPOINTTABLE param, it works. Is it correct to say the only way to incorporate CHECKPOINT after a replicat is added, is to delete it and re-add? Btw, I have also tried the ALTER in conjunction with/wo NONINTEGRATED; with/wo extseqno and rba, but same result. I appreciate your time, Thank You !
GGSCI (GGSQA) 74> stop abc1
Sending STOP request to REPLICAT ABC1 ...
Request processed.
GGSCI (GGSQA) 80> ALTER REPLICAT ABC1, CHECKPOINTTABLE GGS_CHECKPOINT
GGSCI (GGSQA) 80..
ERROR: Invalid parameter specified for ALTER REPLICAT.