Displays information about pools.
You can also use OpenSwitch Manager to view information
about pools.
rp_pool_help [pool_name]
Name of the pool about which information is to be displayed. Without this parameter, rp_pool_help issues a report about all available pools.
Displays information about all pools.
1> rp_pool_help 2> go
Returns:
pool_name mode status block next_server ---------- -------- -------- ------ ------------- POOL_A CHAINED UP 0 SYB_SERV1 POOL_B BALANCED UP 0 SYB_SERV2 POOL_C BALANCED LOCKED 0 SYB_SERV3
Displays information about POOL_A.
1> rp_pool_help "POOL_A" 2> go
Returns:
pool_name mode status block next_server ---------- -------- -------- ------ ------------- POOL_A CHAINED UP 0 SYB_SERV1 (1 row affected) server_name ----------- SYB_SERV1 SYB_SERV3 (2 rows affected) attribute value ---------- ------------------- appname isql hostname test.sybase.com
The block column indicates the number of spids that are current blocked on a LOCKED pool.
The next_server column indicates the name of the next server to be assigned to an incoming connection or a connection in the process of switching.
The specified pool does not exist in the OpenSwitch:
rp_pool_help: Invalid pool name 'pool_name'.
Run rp_pool_help without pool_name to determine the set of available pools.
rp_pool_addattrib, rp_pool_addserver, rp_pool_create
