rp_pool_addattrib

Description

Adds connection attribute/value pair to a pool.

Syntax

rp_pool_addattrib pool_name, attrib, value

Parameters

Examples

Example 1

Routes any connection created by a user name beginning with “Sybase” or “sybase” to POOL_A.

1> rp_pool_addattrib "POOL_A", "username", "[sS]ybase%"
2> go

Example 2

Routes any connection created with an application name of “isql” to POOL_A.

1> rp_pool_addattrib "POOL_A", "appname", "isql"
2> go

Example 3

Routes any incoming connection from this particular host to POOL_A.

1> rp_pool_addattrib "POOL_A", "hostname",
  "name of host"
2> go

Usage

• An attribute/value pair is used to route connections to a pool. At the time a connection is established to OpenSwitch, the attribute of the connection identified by attrib is compared to the regular expression value. If a match is found, the connection is routed to pool_name.

• Adding or removing attribute/value pairs from a pool has no effect on existing connections; however, the changes apply to existing connections during a failover.

• Both the application name and host name attributes of a client connection must be explicitly set by the client application and cannot actually reflect the real application name and host name that the user is using.

• Changes applied to a pool are not reflected in the configuration file. You must manually change the configuration file.

• Use rp_pool_help to display the current set of attributes.