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