Question & Answer
Question
How is the JDBC probe configured for accessing events from a database?
Answer
The Support's Guide to the JDBC Probe explains how the JDBC Probe works and provides example configurations that use the MarkerColumn method.
Best practice settings.
Examples provided.
- Connecting to Oracle by using a MarkerColumn
- Connecting to DB2 by using a MarkerColumn
- Connecting to Sybase by using a MarkerColumn
General comment.
Best practice settings.
# Best practice
NetworkTimeout : 15
PollServer : 60
# Buffering - 20 EPS
Buffering : 1
BufferSize : 200
FlushBufferInterval : 9
# Ping the object server periodically
ProbeWatchHeartbeatInterval : 60
# Increase the internal queue to suitable synchronisation size
MaxEventQueueSize : 50000
Java probes can be limited in size by using the -Xmx option, which can be set in the probes environment file.NetworkTimeout : 15
PollServer : 60
# Buffering - 20 EPS
Buffering : 1
BufferSize : 200
FlushBufferInterval : 9
# Ping the object server periodically
ProbeWatchHeartbeatInterval : 60
# Increase the internal queue to suitable synchronisation size
MaxEventQueueSize : 50000
File : $NCHOME/omnibus/probes/java/nco_p_jdbc.env
e.g.
# NCO_JPROBE_JAVA_FLAGS are general options
# NCO_JPROBE_JAVA_XFLAGS are non-portable JVM options
e.g.
# NCO_JPROBE_JAVA_FLAGS are general options
# NCO_JPROBE_JAVA_XFLAGS are non-portable JVM options
###
# Limit the JVM memory
JPROBE_JAVA_FLAGS="-Xmx1000m"
#EOF
The allocated Java memory must not use up all free memory, since probes require nonnative memory to function properly.
JPROBE_JAVA_FLAGS="-Xmx1000m"
#EOF
The allocated Java memory must not use up all free memory, since probes require nonnative memory to function properly.
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSSHTQ","label":"Tivoli Netcool\/OMNIbus"},"ARM Category":[{"code":"a8m500000008a6DAAQ","label":"Probes-\u003E1 Individual Probes-\u003EJDBC nco_p_jdbc"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.1.0"}]
Was this topic helpful?
Document Information
Modified date:
11 September 2023
UID
swg21655794