Goldengate Performance Metric Server OGG 12.3

The Performance Metrics Server (PMSRVR) introduced in OGG 12.3 version and uses the metrics service to collect and store instance deployment performance results

We can use Performance Metrics Server in both CLASSIC and MICROSERVICES Architecture modes

When PMSRVR is started for the first time, the sequence of commands must be:

START PMSRVR

START MANAGER

START *

START JAGENT

Command                                          Description 

INFO PMSRVR                        Returns information about the PMSRVR. 

START PMSRVR                    Starts the PMSRVR. 

STATUS PMSRVR                  Returns the state of the PMSRVR. 

STOP PMSRVR                      Stops the PMSRVR.

START PMSRVR                    Starts the PMSRVR.

GGSCI (prod01.domain.com) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

JAGENT       RUNNING

PMSRVR    STOPPED

EXTRACT    RUNNING     EXTPSTDB    00:00:00      00:00:00

EXTRACT    RUNNING     PMPUPDB    00:00:00      00:00:01

REPLICAT    RUNNING     REPTGDB      00:00:00      00:00:05

GGSCI (prod01.domain.com) 4> start pmsrvr

PMSRVR started

GGSCI (prod01.domain.com) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

JAGENT       RUNNING

PMSRVR    RUNNING

EXTRACT    RUNNING     EXTPSTDB    00:00:00      00:00:00

EXTRACT    RUNNING     PMPUPDB    00:00:00      00:00:00

REPLICAT    RUNNING     REPTGDB      00:00:00      00:00:01

ALL "datastore" commands are deprecated in Oracle GoldenGate 12.3.x and above.

If using GoldenGate 12.3.x and above then DO NOT execute delete datastore, create datastore commands if you do so you will

receive "command not found" type errors.

"start pmsrvr" will create and manage $OGG_HOME/dirbdb

Enable monitoring options are changed

ENABLEMONITORING [ UDP ]

ENABLEMONITORING [ UDP ] [ UDPPORT portnumber ] [ HTTPPORT portnumber ]

default port is 9004