OGG4DB2 for IBM i PURGEOLDEXTRACTS not working

 

OGG4DB2 for IBM i PURGEOLDEXTRACTS not working

1.1        SYMPTOMS

We set PURGEOLDEXTRACTS for mgr process in OGG4DB2, but purge action not working to clean down the old trail files.

> view params mgr

Port 7809

PURGEOLDEXTRACTS /GoldenGate/dirdat/SA*, USECHECKPOINTS, MINKEEPDAYS 7

> pwd

/GoldenGate/dirdat

> ls -lrt

total 2752512

-rw-r—– 1 datahub 0 199998879 16 sep 02:15 TR0000009

-rw-r—– 1 datahub 0 199999194 17 sep 16:06 TR0000010

-rw-r—– 1 datahub 0 199999330 19 sep 10:48 TR0000011

-rw-r—– 1 datahub 0 199999576 20 sep 16:50 TR0000012

-rw-r—– 1 datahub 0 199999145 24 sep 00:06 TR0000013

-rw-r—– 1 datahub 0 199999748 26 sep 10:40 TR0000014

-rw-r—– 1 datahub 0 190970546 27 sep 14:05 TR0000015

 

> view params mgr

Port 7809

AUTOSTART ER PMP01

AUTORESTART ER PMP01, RETRIES 20, WAITMINUTES 2, RESETMINUTES 60

AUTOSTART ER EXT01

AUTORESTART ER EXT01, RETRIES 20, WAITMINUTES 2, RESETMINUTES 60

PURGEOLDEXTRACTS /GoldenGate/dirdat/SA*, USECHECKPOINTS, MINKEEPDAYS 7

 

ORA-06512: at line 1

1.2        DEBUG

GGSCI (IBMISERVER01) 10>                                      

 > info all                                                                                                                               

   Program     Status      Group       Lag at Chkpt  Time Since Chkpt

   MANAGER     RUNNING                                                

   EXTRACT     RUNNING     EXT01    00:00:00      00:00:10        

   EXTRACT     RUNNING     PMP01    00:00:00      00:00:01        

   GGSCI (IBMISERVER01) 11>                                          

 > info er *, detail                                                                                                                             

   EXTRACT    EXT01  Last Started 2019-09-04 15:04   Status RUNNING   

   Checkpoint Lag       00:00:00 (updated 00:00:04 ago)                  

   Process ID           15849                                            

   VAM Read Checkpoint  2019-09-30 14:05:40.370816     

                                                                             

        Journal               Receiver               Timestamp (UTC)         

 Sequence Number                                                             

    @JRNLIB/JRNOPE    |   @JRNLIB/JRNOPE7442|Sep 30 2019 12:05:40.370816|00000

 000000134167452                                                              

 System Sequence Number: 00000000000134167452                                

                                                                             

   Target Extract Trails:                                                     

                                                                             

   Trail Name                                       Seqno        RBA     Max M

 B Trail Type                                                                 

                                                                             

   /goldengate/dirdat/SA                               16  156767993        20

 0 EXTTRAIL                                                                   

                                                                              

     Extract Source                          Begin             End            

                                                                              

     Not Available                           2019-09-03 16:26  2019-09-30 14:05

     Not Available                           * Initialized *   2019-09-03 16:26

     Not Available                           * Initialized *   First Record   

     Not Available                           * Initialized *   First Record   

     Not Available                           * Initialized *   First Record   

     Not Available                           * Initialized *   First Record   

     Not Available                           * Initialized *   First Record   

     Not Available                           * Initialized *   First Record   

     Not Available                           * Initialized *   First Record   

                                                                               

                                                                              

   Current directory    /GoldenGate                                           

 Report file          /GoldenGate/dirrpt/EXT01.rpt                 

 Parameter file       /GoldenGate/dirprm/EXT01.prm                 

 Checkpoint file      /GoldenGate/dirchk/EXT01.cpe                 

 Process file         /GoldenGate/dirpcs/EXT01.pce                 

 Error log            /GoldenGate/ggserr.log                           

                                                                      

 EXTRACT    PMP01  Last Started 2019-09-30 14:03   Status RUNNING  

 Checkpoint Lag       00:00:00 (updated 00:00:06 ago)                 

 Process ID           29448                                           

 Log Read Checkpoint  File /goldengate/dirdat/TR0000016             

                      2019-09-30 14:05:34.229728  RBA 156767993       

                                                                       

   Target Extract Trails:                                             

                                                                             

   Trail Name                                       Seqno        RBA     Max M

 B Trail Type                                                                 

                                                                             

   /u01/app/ogg/dirdat/PBCN/TI                         13   72070274        20

 0 RMTTRAIL                                                                   

                                                                             

   Extract Source                          Begin             End             

                                                                              

   /goldengate/dirdat/TR0000016          2019-09-29 16:49  2019-09-30 14:05

   /goldengate/dirdat/TR0000016          2019-09-18 13:14  2019-09-29 16:49

   /goldengate/dirdat/TR0000011          2019-09-04 16:45  2019-09-18 13:14

   /goldengate/dirdat/TR0000005          2019-09-04 14:49  2019-09-04 16:45

   /goldengate/dirdat/TR0000003          * Initialized *   2019-09-04 14:49

   /goldengate/dirdat/TR0000000          * Initialized *   First Record

   /goldengate/dirdat/TR0000000          * Initialized *   First Record

                                                                        

                                                                        

 Current directory    /GoldenGate                                        

                                                                        

 Report file          /GoldenGate/dirrpt/PMP01.rpt                   

 Parameter file       /GoldenGate/dirprm/PMP01.prm                   

 Checkpoint file      /GoldenGate/dirchk/PMP01.cpe                   

 Process file         /GoldenGate/dirpcs/PMP01.pce                   

 Error log            /GoldenGate/ggserr.log                            

                                                                         

                                                                        

 GGSCI (IBMISERVER01) 12>                                           

  GGSCI (IBMISERVER01) 12>      

> send manager GETPURGEOLDEXTRACTS  

   

 Sending GETPURGEOLDEXTRACTS request to MANAGER …                          

                                                                             

 PurgeOldExtracts Rules                                                      

 Fileset                              MinHours MinFiles UseCP                

 /GoldenGate/dirdat/SA*                    168        1   Y                  

 OK                                                                          

 Extract Trails                                                               

 Filename                        Oldest_Chkpt_Seqno  IsTable  IsVamTwoPhaseCom

 mit                                                                         

 /goldengate/dirdat/SA       16                

 

1.3        Solution

> cd  /GoldenGate/dirdat                                                   

> ls -lrt                                                              

   total 3080192                                                        

   -rw-r—–    1 datahub  0         199998879 16 sep 02:15 TR0000009

   -rw-r—–    1 datahub  0         199999194 17 sep 16:06 TR0000010

   -rw-r—–    1 datahub  0         199999330 19 sep 10:48 TR0000011

   -rw-r—–    1 datahub  0         199999576 20 sep 16:50 TR0000012

   -rw-r—–    1 datahub  0         199999145 24 sep 00:06 TR0000013

   -rw-r—–    1 datahub  0         199999748 26 sep 10:40 TR0000014

   -rw-r—–    1 datahub  0         199998574 27 sep 15:03 TR0000015

   -rw-r—–    1 datahub  0         157772290 30 sep 14:14 TR0000016

   $                                                                    

> view params mgr                                                                                                                                

  Port 7809                                                              

  AUTOSTART ER PMP01                                                 

  AUTORESTART ER PMP01, RETRIES 20, WAITMINUTES 2, RESETMINUTES 60   

  AUTOSTART ER EXT01                                                  

  AUTORESTART ER EXT01, RETRIES 20, WAITMINUTES 2, RESETMINUTES 60   

  PURGEOLDEXTRACTS /goldengate/dirdat/SA*, USECHECKPOINTS, MINKEEPDAYS 7

   GGSCI (IBMISERVER01) 3>  stop *                                               

                                                        

   Sending STOP request to EXTRACT EXT01 …         

   Request processed.                                   

                                                        

   Sending STOP request to EXTRACT PMP01 …         

   Request processed.                                   

                            

  GGSCI (IBMISERVER01) 4>                          

> stop mgr                                             

  Manager process is required by other GGS processes.  

  Are you sure you want to stop it (y/n)?              

> y                                                    

                                                       

  Sending STOP request to MANAGER …                  

  Request processed.                                   

  Manager stopped.      

 

 > exit                                                                      

   $                                                                          

 > ggsci                                                                     

                                                                             

   Oracle GoldenGate Command Interpreter for DB2 for i                       

   Version 12.3.0.1.2 OGGCORE_12.3.0.1.0_PLATFORMS_171208.0005               

   IBM i, ppc, 64bit (optimized), IBM DB2 for i on Dec  8 2017 02:42:38      

   Operating system character set identified as US-ASCII.                    

                                                                              

   Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved                                                                           

   GGSCI (IBMISERVER01) 1>                                 

                                      

   GGSCI (IBMISERVER01) 2>        

 > start mgr                         

  Manager started.                                                     

  GGSCI (IBMISERVER01) 3>                                          

> info all                                                                                                                                    

  Program     Status      Group       Lag at Chkpt  Time Since Chkpt                                                                         

  MANAGER     RUNNING                                                  

  EXTRACT     RUNNING     EXT01    00:00:00      00:01:15           

  EXTRACT     RUNNING     PMP01    00:00:00      00:01:15           

 > cd    /GoldenGate/dirdat                                                        

   $                                                                         

 > ls -lrt                                                                    

   total 1508352                                                             

   -rw-r—–    1 datahub  0         199999145 24 sep 00:06 TR0000013     

   -rw-r—–    1 datahub  0         199999748 26 sep 10:40 TR0000014      

   -rw-r—–    1 datahub  0         199998574 27 sep 15:03 TR0000015     

   -rw-r—–    1 datahub  0         157910776 30 sep 14:17 TR0000016     

   -rw-r—–    1 datahub  0            442999 30 sep 14:18 TR0000017     

 

Leave a Reply

Your email address will not be published. Required fields are marked *