Check the Statistical Reports

REST API Admin Client

Copy and use the following cURL script to check the statistical data for the DDL and DML operations.

Note: The given sample script uses names and values of database server, parameter values, Extract, Replicat, and other processes. You must change these values according to your environment for this script to work.

# --
# -- Create USERIDALIAS to connection from GoldenGate to the Databases
# --
# ----------------------------------------------------------------------------------------------------

echo " "
echo "------------------------------------------------------------------------------------------"
echo "--"
echo "-- Extract EXN "
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "

echo "Extract EXTN status:"
curl -s -k -X GET https://north:9001/services/v2/extracts/EXTN                                            \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "Extract EXTN lag:"
curl -s -k -X POST https://north:9001/services/v2/extracts/EXTN/command                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command": "GETLAG", "isReported": true}' | jq '.response.reply'                                \
      | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Extract EXTN statistics:"
curl -s -k -X POST https://north:9001/services/v2/extracts/EXTN/command                                   \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command":"STATS", "arguments":"TOTAL"}'                                                        \
      | jq '.response.reply' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT


echo " "
echo "------------------------------------------------------------------------------------------"
echo "--"
echo "-- DistPath DPNS"
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "


echo "DistPath DPNS status:"
curl -s -k -X GET https://north:9002/services/v2/sources/DPNS                                             \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

curl -s -k -X GET https://north:9002/services/v2/sources/DPNS/stats                                       \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
      | jq '.response' | json_reformat | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT


echo " "
echo "------------------------------------------------------------------------------------------"
echo "--"
echo "-- Replicat REPN "
echo "--"
echo "------------------------------------------------------------------------------------------"
echo " "

echo "Replicat REPN status:"
curl -s -k -X GET https://south:9101/services/v2/replicats/REPN                                           \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='  | jq '.response.status'

echo "Replicat REPN lag:"
curl -s -k -X POST https://south:9101/services/v2/replicats/REPN/command                                  \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command": "GETLAG", "isReported": true}' | jq '.response.reply'                                \
      |  sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

echo "Replicat REPN statistics:"
curl -s -k -X POST https://south:9101/services/v2/replicats/REPN/command                                  \
     -H "Content-Type: application/json"                                                                  \
     -H "Accept: application/json"                                                                        \
     -H 'Authorization: Basic Z2dtYTpHR21hXzIzYWk='                                                       \
     -d '{"command":"STATS", "arguments":"TOTAL"}'                                                        \
      | jq '.response.reply' | sed 's/\n/\n/g' |  sed 's/\t/\t/g'| grep -v OKNODOT

exit

Copy and use the following OBEY script by adjusting the values for each of the options with the options in your enviornment, to check the statistical data for the DDL and DML operations.

# --
# -- Connect the GoldenGate Deployment depl_north
# --
CONNECT https://north:9001 DEPLOYMENT depl_north AS ggma PASSWORD GGma_26ai !

INFO  EXTRACT extn
SEND  EXTRACT extn, GETLAG
STATS EXTRACT extn, TOTAL, TOTALSONLY *.*

INFO DISTPATH  DPNS
STATS DISTPATH DPNS

# --
# -- Connect the GoldenGate Deployment depl_south
# --

CONNECT https://south:9101 DEPLOYMENT depl_south AS ggma PASSWORD GGma_26ai !

INFO  REPLICAT repn
SEND  REPLICAT repn, GETLAG
STATS REPLICAT repn, TOTAL, TOTALSONLY *.*

DISCONNECT

After you create the preceding .oby file, create a shell script to run in Admin Client that would run the .oby commands:

echo "obey check_replication_reporting.oby" | adminclient