Reference Manual

Back Next

TCPIP_SHOW_POOLING Statement

The TCPIP_SHOW_POOLING statement specifies whether to write diagnostic information about connection pooling to the PowerExchange log file.

If this option is enabled in the client-side DBMOVER file, PowerExchange issues message PWX-33805.

All

TCPIP_SHOW_POOLING={N|Y}

N
.
PowerExchange does not issue message PWX-33805.

Y.
PowerExchange issues message PWX-33805.

Default is N.

Message PWX-33805 provides the following information:

Size. Size of connection pool.

Hits. Number of times that PowerExchange found a connection in the PowerExchange connection pool that it could reuse.

Partial hits. Number of times that PowerExchange found a connection in the PowerExchange connection pool that it could modify and reuse.

Misses. Number of times that PowerExchange could not find a connection in the PowerExchange connection pool that it could reuse.

Expired. Number of connections that were discarded from the PowerExchange connection pool because the maximum idle time was exceeded.

Discarded pool full. Number of connections that were discarded from the PowerExchange connection pool because the pool was full.

Discarded error. Number of connections that were discarded from the PowerExchange connection pool due to an error condition.