Skip to content

Automatic recovery of GoldenGate Microservices Distribution Paths statistics (secured deployment)

Notifications You must be signed in to change notification settings

StephaneBraun/GoldenGate-Distribution-Path-Analysis-secure-deployment

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

GoldenGate-Distribution-Path-Analysis-secure-deployment

Automatic recovery of GoldenGate Microservices Distribution Paths statistics (secured deployment)

This utility allows you to monitor Oracle GoldenGate Microservices distribution paths in secure deployment mode. The GoldenGate Distribution service presents the data transfer activity contained in the trails in real time, but it does not offer historical metrics. Here, it will be possible to keep for analysis the following information from the distribution paths of all the deployments of a service manager:

  • Date and time of measurement
  • Deployment name
  • Distribution Path Name
  • Status
  • Lag
  • Number of inserts
  • Number of updates
  • Number of deletes
  • Total number of rows
  • sendWaitTime
  • recvWaitTime
  • totalBytesSent
  • totalMsgsSent
  • Trail number in: inputSequence
  • Rba of trail in: inputOffset
  • Trail out number: outputSequence
  • Rba of trail out: outputOffset

This tool connects to a GoldenGate Service Manager and will go through all the deployments to analyze all the distribution paths of all these deployments.

Prerequisites:

JDK 1.8 minimum
Have the oggConnect.properties file in the same directory as the jar file

The oggConnect.properties file contains the following settings:

oggUrl: https connection string to the GoldenGate Service Manager
defaultDir: directory for generating the Distribution Path statistics file

Example :

oggUrl=https://localhost:5000
defaultDir=/u01/goldengate/temp

Two ways to launch the program:

  • With prompt for mandatory paramters :

     java -jar goldenGateDistributionPath.jar
    

    And enter the user and password of the GoldenGate Service Manager, the name of the properties file and the statistics refresh frequency in seconds If the frequency is less than 10 seconds, it will automatically be repositioned to 10 seconds.

  • With the parameters in the command line :

      java -jar goldenGateDistributionPathSecure.jar OGG_user OGG_pwd Properties_file_without_extension_.properties Frequency_in_seconds
    

    Example :

      java -jar goldenGateDistributionPathSecure.jar oggadmin oggadmin oggConnect 30
    

About

Automatic recovery of GoldenGate Microservices Distribution Paths statistics (secured deployment)

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages