MONITORING GOLDENGATE

MONITORING GOLDENGATE

Information on all GoldenGate processes running on a system

GGSCI (wasdba) 21> info all

Find the run status of a particular process

GGSCI (wasdba) 23> status manager

GGSCI (wasdba) 24> status extract ext1

Detailed information of a particular process

GGSCI (wasdba) 6> info extract ext1, detail

Monitoring an Extract recovery 

GGSCI (wasdba) 35> send extract ext1 status

Monitoring processing volume - Statistics of the operations processed 

GGSCI (wasdba) 33> stats extract ext1

View processing rate - can use 'hr','min' or 'sec' as a parameter

GGSCI (wasdba) 37> stats extract ext2 reportrate hr

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

GGSCI (wasdba) 13>  send extract ext2, getlag

GGSCI (wasdba) 15> lag extract ext*

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

ggserr.log, exception table. view reports.

 GGSCI command VIEW GGSEVT as well.

View the process report

GGSCI (wasdba) 2> view report ext1

GGSCI (wasdba) 2> view report rep1

GGSCI (wasdba) 2> view report mgr

Information on Child processes started by the Manager

GGSCI (wasdba) 8> send manager childstatus