Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

GoldenGate 12.2 New Feature – INFO and GETPARAMINFO

  • Posted by Gavin Soorma
  • On February 16, 2016
  • 1 Comments
  • GETPARAMINFO, GoldenGate 12.2, info, new feature, parameter

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 :

 

1 Comments

sudharsanam
  • Nov 29 2016
Thanks avin for sharing new features about 12.2 GG. Can you please describe the Heart beat tables feature in 12.2.

Leave Reply

Your email address will not be published. Required fields are marked *