Listing available pools

To list the set of available pools, enter:

rp_pool_help

Sample results are:

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

To list details about a specific pool, add the name of the pool about which you are inquiring. For example:

rp_pool_help "POOL_A"

Sample results are:

pool_name  mode     status   block  next_server 
---------- -------- -------- ------ ------------
POOL_A     CHAINED  UP       0      SYB_SERV1

server_name 
----------- 
SYB_SERV1
SYB_SERV3

attribute  value
---------- ------------------
appname    sql
hostname   test.sybase.com

See rp_pool_help for more information.