Removes a connection attribute/value from a pool.
rp_pool_remattrib pool_name, attrib, value
Identifies the name of the pool from which the attribute/value pair is to be removed.
The name of the attribute to be removed from the pool. Table 7-9 describes the values for attrib.
Attribute |
Description |
---|---|
username |
Value must match the user name of an incoming client connection. |
appname |
Value must match the application name identified by the incoming client connection. |
hostname |
Value must match the host machine name identified by the incoming client connection. |
A standard SQL wildcard expression used to match attrib.
Removes attribute appname, with a value of “isql%” from POOL_A.
1> rp_pool_remattrib "POOL_A", "appname", "isql%" 2> go
Removes the attribute hostname with the a value of “[Cc]rater” from POOL_A.
1> rp_pool_remattrib "POOL_A", "hostname", "[Cc]rater" 2> go
Removes the attribute username with a value of “Moon” from POOL_A.
1> rp_pool_remattrib "POOL_A", "username", "Moon" 2> go
The value parameter must exactly match the actual attribute’s value, either as specified in the configuration file, or by using rp_pool_remattrib to successfully remove the attribute.
Adding or removing attribute=value pairs from a pool has no effect on existing connections except during a failover.
Any changes you make to a pool using rp_pool_remattrib are not reflected in the configuration file; you must make those changes manually.
You can use rp_pool_help to display the current attributes.
The named pool does not exist within OpenSwitch:
rp_pool_remattrib: There is no such pool 'pool_name'.
The named attribute is not one of user name, host name, or application name:
rp_pool_remattrib: Invalid attribute name 'attrib'.
Registered procedure execution succeeded:
rp_pool_addattrib: Attribute successfully removed from pool 'pool_name'
rp_pool_addattrib, rp_pool_create, rp_pool_help