Pages

Thursday, May 28, 2026

Golden Gate - old files are not purged

Issue
Old transaction files are not purged from server.
/software/ogg/191/dirdat/01/in
/software/ogg/191/dirdat/01/out

Evidences
When checking mgr.prm:

dirprm/mgr.prm
PORT 7809
SYSLOG NONE

AUTOSTART EXTRACT *
AUTOSTART REPLICAT *
AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 60
AUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 60

DOWNREPORTMINUTES 5
LAGCRITICALMINUTES 5

purgeoldextracts /software/ogg/191/dirdat/01/in/*, USECHECKPOINTS, MINKEEPHOURS 2
purgeoldextracts /software/ogg/191/dirdat/01/out/*, USECHECKPOINTS, MINKEEPHOURS 4

But when checking in MGR.rpt, there is no evidence of these parameters

Parameters...
PORT 7809
***********************************************************************
**                     Run Time Messages                            **
*********************************************************************

Seems the parameters file was not loaded correctly.

Reason
Unknown

How to fix

%> ggsci
GGSCI (ITMIL7DB00001) 1>  REFRESH MANAGER

Sending REFRESH request to MANAGER ...
Mgr Params Updated

less MGR.rpt

PORT 7809
SYSLOG NONE

AUTOSTART EXTRACT *
AUTOSTART REPLICAT *
AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 60
AUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 60

DOWNREPORTMINUTES 5
LAGCRITICALMINUTES 5

purgeoldextracts /software/ogg/191/dirdat/*/in/*, USECHECKPOINTS, MINKEEPHOURS 2
purgeoldextracts /software/ogg/191/dirdat/*/out/*, USECHECKPOINTS, MINKEEPHOURS  4


Now, old files are getting purged
2026-05-28 14:47:16  INFO    OGG-00957  Purged old extract file '/software/ogg/191/dirdat/01/in/es000000022', applying UseCheckPoints purge rule: Oldest Chkpt Seqno 30 > 22.

2026-05-28 14:47:16  INFO    OGG-00957  Purged old extract file '/software/ogg/191/dirdat/01/in/es000000023', applying UseCheckPoints purge rule: Oldest Chkpt Seqno 30 > 23.

2026-05-28 14:47:16  INFO    OGG-00957  Purged old extract file '/software/ogg/191/dirdat/01/in/es000000024', applying UseCheckPoints purge rule: Oldest Chkpt Seqno 30 > 24.

2026-05-28 14:47:16  INFO    OGG-00957  Purged old extract file '/software/ogg/191/dirdat/01/in/es000000025', applying UseCheckPoints purge rule: Oldest Chkpt Seqno 30 > 25.

2026-05-28 14:47:17  INFO    OGG-00957  Purged old extract file '/software/ogg/191/dirdat/01/in/es000000026', applying UseCheckPoints purge rule: Oldest Chkpt Seqno 30 > 26.

No comments:

Post a Comment