Logdump Guidelines for use

Logdump Guidelines for use

Write time Thursday, April 16, 2015

Author: snail

qq:295013648

Use the following command in Ggsci to view the currently processed queue file and the RBA number, for example:

Example 9-47:

Ggsci (BR-JL-ACCS-DB1) 3> info repyxa

Replicat Repyxa last Started 2011-01-08 19:48 Status RUNNING

Checkpointlag 00:00:00 (Updated 136:41:42ago)

Logread Checkpoint File./dirdat/p1000556first Record RBA 59193235

In the Goldengate installation directory, execute the logdump command to open the queue file you want to view:

Example 9-48:

LOGDUMP1 >open./dirdat/p1000556

Currentlogtrail is./dirdat/p1000556

LOGDUMP2 >GHDR on

Logdump3 >detail on

Logdump4 >detail Data

LOGDUMP5 >usertoken on

Logdump6 >pos 59193235 above INFO command to see RBA number

LOGDUMP7 >n

Continue to enter N to display the currently processed table and related operations.

Logdump Guidelines for use