sp_iqmpxincconnpoolinfo procedure

Function

If run on the coordinator node, displays INC connection pool status for every node. If executed on a secondary node, displays INC connection pool status for just the current node.

Syntax

sp_iqmpxincconnpoolinfo

Usage

If the procedure is run on the coordinator and a secondary node is not responding or timed out, the result set omits the row for that node, because this data cannot be accessed unless that node is running.

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission in order to run the stored procedure.

Description

The sp_iqmpxincconnpoolinfo procedure returns the following:

Table A-3: sp_iqiqmpxincconnpoolinfo columns

Column name

Data type

Description

server_id

unsigned int

Identifier for the server

server_name

char(128)

Name of the server

current_pool_size

unsigned int

Current size of connection pool

idle_connection_count

unsigned int

Number of idle connections in the pool

connections_in_use

unsigned int

Number of connections in use

Example

This example shows sample output of sp_iqmpxincconnectionpoolinfo:

server_id,server_name,current_pool_size,
idle_connection_count,connections_in_use

2,'r2_dbsrv90210',0,0,0

3,'w3_dbsrv90210',0,0,0