Zero Downtime Installation Guide for IBM DB2

10.3 HotFix 1

Back Next

Remove ZDT Replication on IBM DB2

You can remove Zero Downtime from your environment.

On the source sytsem, connect to GGSCI.

GGSCI> DBLOGIN SOURCEDB srcdb USERID gg PASSWORD password
GGSCI> STOP *

Verify that all EXTRACT and REPLICAT processes are stopped.

GGSCI> INFO ALL
GGSCI> DELETE *
GGSCI> DELETE CHECKPOINTTABLE MDM_SAMPLE.GGS_EVENT_CHECKPOINT
GGSCI> DELETE CHECKPOINTTABLE MDM_SAMPLE.GGS_CHECKPOINT
GGSCI> STOP MGR
GGSCI> EXIT

If you installed Oracle GoldenGate as a Windows service, delete the service.

 INSTALL.EXE DELETEEVENTS DELETESERVICE

To reduce transaction log space use, run the following script:

--#SET TERMINATOR ~
CONNECT TO SRCDB USER gg USING password
~
SET SCHEMA MDM_SAMPLE
~
SET PATH MDM_SAMPLE, CURRENT PATH
~
SET SERVEROUTPUT ON
~
CALL DBMS_OUTPUT.ENABLE(1024000)
~
BEGIN
   DECLARE stmt VARCHAR(1000);
   FOR f1 AS c1 CURSOR WITH HOLD FOR 
       SELECT 
           TABSCHEMA,TABNAME,DATACAPTURE 
       FROM 
           SYSCAT.TABLES 
       WHERE 
           TABSCHEMA = CURRENT SCHEMA 
           AND TYPE = 'T' 
           AND DATACAPTURE <> 'N'
   DO
      SET stmt = 'ALTER TABLE '||TRIM(CURRENT SCHEMA)||'.'||f1.TABNAME||' DATA CAPTURE NONE';
      CALL DBMS_OUTPUT.PUT_LINE(stmt);
      COMMIT;
   END FOR;
END
~
COMMIT
~

Rename Saved Search

Table of Contents

Zero Downtime Installation Guide for IBM DB2

Zero Downtime Installation Guide for IBM DB2

Remove ZDT Replication on IBM DB2