9.5.4.2 Delivery Properties
The following properties are available to Java Delivery:
- General Properties
- Statistics and Reporting
Disables or enables the checkpoint file handling. This causes the standard Oracle GoldenGate reporting to be incomplete. Oracle GoldenGate for Java adds its own reporting to handle this issue.
Parent topic: Java Delivery Properties
9.5.4.2.1 General Properties
The following properties apply to all writer configurations:
- goldengate.userexit.writers
- goldengate.userexit.chkptprefix
- goldengate.userexit.nochkpt
- goldengate.userexit.usetargetcols
Parent topic: Delivery Properties
9.5.4.2.1.1 goldengate.userexit.writers
Specifies the name of the writer. This is always jvm
and should not be modified.
For example:
goldengate.userexit.writers=jvm
All other properties in the file should be prefixed by the writer name, jvm
.
Parent topic: General Properties
9.5.4.2.1.2 goldengate.userexit.chkptprefix
Specifies a string value for the prefix added to the Java checkpoint file name. For example:
goldengate.userexit.chkptprefix=javaue_
Parent topic: General Properties
9.5.4.2.1.3 goldengate.userexit.nochkpt
Disables or enables the checkpoint file. The default is false
, the checkpoint file is enabled
. Set this property to true
if transactions are supported and enabled on the target.
For example, Java Adapter Properties if JMS is the target and JMS local transactions are enabled
(the default), set goldengate.userexit.nochkpt=true
to disable the user exit checkpoint file. If JMS transactions are disabled by setting localTx=false
on the handler, the checkpoint file should be enabled by setting goldengate.userexit.nochkpt=false.
goldengate.userexit.nochkpt=
true|false
Parent topic: General Properties
9.5.4.2.1.4 goldengate.userexit.usetargetcols
Specifies whether or not mapping to target columns is allowed. The default is false
, no target mapping.
goldengate.userexit.usetargetcols=
true|false
Parent topic: General Properties
9.5.4.2.2 Statistics and Reporting
Disables or enables the checkpoint file handling. This causes the standard Oracle GoldenGate reporting to be incomplete. Oracle GoldenGate for Java adds its own reporting to handle this issue.
Statistics can be reported every t
seconds or every n
records - or if both are specified, whichever criteria is met first.
There are two sets of statistics recorded: those maintained by the Replicat module and those obtained from the Java module. The reports received from the Java side are formatted and returned by the individual handlers.
The statistics include the total number of operations, transactions and corresponding rates.
Parent topic: Delivery Properties
9.5.4.2.2.1 jvm.stats.display
Controls the output of statistics to the Oracle GoldenGate report file and to the user exit log files.
The following example outputs these statistics.
jvm.stats.display=true
Parent topic: Statistics and Reporting
9.5.4.2.2.2 jvm.stats.full
Controls the output of statistics from the Java side, in addition to the statistics from the C side.
Java side statistics are more detailed but also involve some additional overhead, so if statistics are reported often and a less detailed summary is adequate, it is recommended that stats.full
property is set to false
.
The following example will output Java statistics in addition to C.
jvm.stats.full=true
Parent topic: Statistics and Reporting
9.5.4.2.2.3 jvm.stats.time | jvm.stats.numrecs
Specifies a time interval, in seconds or a number of records, after which statistics will be reported. The default is to report statistics every hour or every 10000 records (which ever occurs first).
For example, to report ever 10 minutes or every 1000 records, specify:
jvm.stats.time=600 jvm.stats.numrecs=1000
The Java application statistics are handler-dependent:
-
For the all handlers, there is at least the total elapsed time, processing time, number of operations, transactions;
-
For the JMS handler, there is additionally the total number of bytes received and sent.
-
The report can be customized using a template.
Parent topic: Statistics and Reporting