Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

TCPIP_SHOW_POOLING Statement

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
No
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.