GoldenGate Monitoring Commands

Share via:

Post Views: 0

Dear Readers,

In this article we will see GoldenGate Monitoring Commands.

The following steps will briefly discuss the different commands we can use to monitor the GoldenGate environment and get statistics and reports on various
extract and replicat operations which are in progress.

1.Information on all GoldenGate processes running on a system

GGSCI (gg.orcl.com) 1> info all

2. Find the run status of a particular process

GGSCI (gg.orcl.com) 2> status mgr

Manager is running (IP port golden.7809).

3. Detailed information of a particular process

GGSCI (gg.orcl.com) 3> info extract EXTINT

4. Monitoring an Extract recovery

GGSCI (gg.orcl.com) 4> send extract extint,status

5.Monitoring processing volume – Statistics of the operations processed

GGSCI (gg.orcl.com) 5> stats extract extint

6.View processing rate – can use ‘hr’,’min’ or ‘sec’ as a parameter

GGSCI (gg.orcl.com) 8> stats extract extint reportrate hr

Command to check minute parameter

GGSCI (gg.orcl.com) 9> stats extract extint reportrate min

7. View latency between the records processed by Goldengate and the timestamp in the data source

GGSCI (gg.orcl.com) 10> send extract extint, getlag

8. Viewing the GoldenGate error log as well as history of commands executed and other events

We can use the editor depending on operating system – vi on Unix for example to view the ggserr.log file which is located at the top level GoldenGate software installation directory.

We can also use the GGSCI command VIEW GGSEVT as well.

9. View the process report Every Manager, Extract and Replicat process will generate a report file at the end of each run and this report can be viewed to diagnose any problems or errors as well as view the parameters used, the environment variables is use, memory consumption etc
For example:

GGSCI (gg.orcl.com) 12> view report extint

GGSCI (gg.orcl.com) 12> view report replicat

GGSCI (gg.orcl.com) 12> view report mgr

10.information on Child processes started by the Manager