GoldenGate 12.2 New Feature – INFO and GETPARAMINFO

New in Oracle GoldenGate 12.2 is the feature to detailed help about the usage of a particular parameter (INFO) as well as information about the active parameters associated with a running Extract, Replicat as well as Manager process (GETPARAMINFO)

INFO
 
In this example we see all the information about the use of the parameter PORT

GGSCI (qa008 as oggsuser@BSSTG1) 12> info param port

param name : port
description : TCP IP port number for the Manager process
argument : integer
default : 7809
range : 1 – 65535
options :
component(s): MGR
mode(s) : none
platform(s) : all platforms
versions :
database(s) : all supported databases (on the supported platforms).
status : current
mandatory : false
dynamic : false
relations : none

 
GETPARAMINFO
 
In this example we see both the default values used by a running extract as well as the actual parameters which the process is using.

GGSCI (qa008 as oggsuser@BSSTG1) 19> send extract etest getparaminfo

Sending GETPARAMINFO request to EXTRACT ETEST …

GLOBALS

enablemonitoring :

/orasw/app/ogg12.2/dirprm/etest.prm

extract : etest
useridalias : oggsuser_bsstg
logallsupcols :
updaterecordformat : COMPACT
tranlogoptions :
integratedparams : (max_sga_size 2048, parallelism 2)
excludeuser : OGGSUSER
exttrail : ./dirdat/bsstg/test/lt
discardfile : ./dirrpt/etest.dsc
append :
megabytes : 1000
warnlongtrans : 2 hour(s)
checkinterval : 30 minute(s)
reportcount :
every : 15 minute(s)
rate :
statoptions :
resetreportstats :
report :
AT : 23:59
reportrollover :
AT : 00:01
ON : MONDAY
getupdatebefores :
table : TEST.*

Default Values

deletelogrecs :
fetchoptions :
userowid :
usekey :
missingrow : ALLOW
usesnapshot :
uselatestversion :
maxfetchstatements : 100
usediagnostics :
detaileddiagnostics :
diagnosticsonall :
nosuppressduplicates :
flushsecs : 1
passthrumessages :
ptkcapturecachemgr :
ptkcaptureift :
ptkcapturenetwork :
ptkcapturequeuestats :
ptkspstats :
tcpsourcetimer :
tranlogoptions :
bufsize : 1024000
asynctransprocessing : 300
checkpointretentiontime : 7.000000
failovertargetdestid : 0
getctasdml :
minefromsnapshotstby :
usenativeobjsupport :
retrydelay : 60
allocfiles : 500
allowduptargetmap :
binarychars :
checkpointsecs : 10 second(s)
cmdtrace : OFF
dynamicresolution :
eofdelay : 1
eofdelaycsecs : 100
functionstacksize : 200
numfiles : 1000
ptkcapturetablestats :
ptkmaxtables : 100
ptktablepollfrequency : 1
statoptions :
reportfetch :
varwidthnchar :
enableheartbeat :
ptkcaptureprocstats :
ptkmonitorfrequency : 1
use_traildefs :
.

 
GGSCI (qa008 as oggsuser@BSSTG1) 21> send etest getparaminfo tranlogoptions

Sending getparaminfo request to EXTRACT ETEST …

/orasw/app/ogg12.2/dirprm/etest.prm

tranlogoptions :
integratedparams : (max_sga_size 2048, parallelism 2)
excludeuser : OGGSUSER

Default Values

tranlogoptions :
bufsize : 1024000
asynctransprocessing : 300
checkpointretentiontime : 7.000000
failovertargetdestid : 0
getctasdml :
minefromsnapshotstby :
usenativeobjsupport :