IBM Support

Support's Guide to the JDBC Probe

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.

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.
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
###
# 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.

Support's guide to the JDBC probe:

[{"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"}]

Document Information

Modified date:
11 September 2023

UID

swg21655794

Page Feedback