Generic JDBC Connector Driver Node | QueryGrid - Generic JDBC Connector Driver Node Guidelines - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
Product Category
Analytical Ecosystem
Important:
  • The Generic JDBC connector is a target connector only and cannot be used as an initiating connector.
  • All Generic JDBC target connector nodes must be driver nodes for communication and data transfer to and from the target system.
  • Install the Generic JDBC target connector on a host that is able to reach the target database and not on target database nodes.
The following are the minimum requirements for a Generic JDBC target connector node to install the QueryGrid 3.x software:
  • 2 CPUs
  • 4GB RAM
  • 50GB disk space
  • For supported operating system versions, refer to the QueryGrid Compatibility Matrix.
  • Memory requirements as defined in the fabric/connector setup
  • Latest version of JAVA 8 or 11

When using the Generic JDBC connector, the system running the QueryGrid driver process handles a greater workload as compared to other connectors. The CPU and memory configuration of the driver node has a significant impact on query performance. Multiple driver nodes can be used for load balancing.

Memory

The default JVM driver has a default 500MB maximum heap size. Teradata recommends increasing this value to 10GB when using the Generic JDBC connector due to the increased workload experiences by the driver node. You can change the value by setting the QueryGrid system property driverMaxHeapSizeMB to 10000 (10GB) and restarting the tdqg-node service. Heap usage increases with the number of concurrent queries.