GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Data Pump Checkpoint information not updating

I am using GoldenGate for DB2 z/OS v19.1 running on RHEL.

We have a data pump that is in RUNNING status but the checkpoint information is not updating.

GGSCI (xxxxxxx) 1> info s2t2grp4
EXTRACT  S2T2GRP4 Last Started 2023-02-02 16:32  Status RUNNING
Description     'data Pump from Local Trail '
Checkpoint Lag    00:00:00 (updated 15:35:58 ago)
Process ID      3476
Log Read Checkpoint File /apps/ogg/dirdat/ph000000014
           2023-02-02 14:00:07.360067 RBA 1515

however, if we check the report file or do a STATS request, it is processing records.:

GGSCI (xxxxxx) 2> stats s2t2grp4 daily
Sending STATS request to EXTRACT S2T2GRP4 ...
Start of Statistics at 2023-02-03 08:13:03.
Extracting from AOSCOP1.SOURCE_TABLE to AOSCOP1.TARGET_TABLE:
*** Daily statistics since 2023-02-03 00:00:00 ***
  Total inserts                 0.00
  Total updates                2603.00
  Total deletes                 0.00
  Total upserts                 0.00
  Total discards                 0.00
  Total operations              2603.00
End of Statistics.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center