OLE DB Provider for Teradata String Attributes - OLE DB Provider for Teradata

OLE DB Provider for Teradata User Guide

Product
OLE DB Provider for Teradata
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2498
Product Category
Teradata Tools and Utilities

OLE DB Provider for Teradata String Attributes

The following string attributes support load balancing:

 

Table 21: String Attributes 

String Attribute.

Description

NumberOfCOPs

Valid values: any numeric value, 0 to n.

Default value: none

Specifies how many COPs are defined for the data source name being connected. If this attribute is not given, OLE DB Provider for Teradata only attempts to connect to the server or the server's first COP.

If multiple IP addresses (including both IPv6 and IPv4 addresses) exist for the server or its first COP, OLE DB Provider for Teradata uses all of those addresses in attempting to connect to the data source.

If a value of zero is given for this attribute, OLE DB Provider for Teradata only attempts to connect to the given data source name.

If multiple IP addresses (including both IPv6 and IPv4) are known for the name, all are used in the attempt to connect to the server.

If a value greater than zero is given, OLE DB Provider for Teradata assumes there are that many COPs defined for the server.

On the first connection to the server, a random COP is chosen. For successive connection attempts, the next COP numbers in sequence is used, with the numbers wrapping around to one as needed.

COPDownRetry

Valid values: any numeric value, greater than zero.

Default value: 15

Specifies how many minutes OLE DB Provider for Teradata should wait before trying to connect to a server that is down.

This attribute is only used when NumberOfCOPs > 0 and the data source is a server name, not an IP address or the name of a specific COP.