Purpose
Lists information and statistics about one or more established session pools.
Syntax
The DI and DIS abbreviations are deprecated.
where:
- poolid
- Id of pool whose information is to be displayed.
- ALL
- Request that information about all pools be displayed.
Usage Notes
If an error occurs during START POOL processing (because creation of further pool sessions will cause the database or installation-defined maximum session capacity (MAXSESS) to be exceeded), you can use the DISPLAY POOL command to determine how many sessions were successfully added to the pool before the error prevented further processing. Later, if session demand is reduced, you can use the MODIFY SESSIONS command to acquire the desired number of sessions for the pool.
Example: DISPLAY POOL
D POOL ID ACTR04 D POOL ALL
Completion Message
The completion message to the DISPLAY POOL command consists of a header line, followed by one line of statistics per pool, as follows:
TDP0869 ID REQD AVAL ALC BUSY LOGS ERR E/D TDP0870 FTXCLUP 0001 0001 000 0000 0000001 011 (E)
where:
| Column heading . . . | Contains the . . . |
|---|---|
| ID | unique identifiers of the pool whose statistics are displayed. |
| REQD | number of sessions requested for the pool in the START POOL or MODIFY POOL command. |
| AVAL | number of sessions in the pool that are currently not in use and available to satisfy application logon requests. |
| ALC | number of pool sessions that are currently in use by applications. |
| BUSY | number of pool sessions that are in the process of logging on to the database. |
| LOGS | number of application logon requests that have already been satisfied by pool sessions. |
| ERR | number of application logon requests that have been denied owing to a lack of available pool sessions. |
| E/D | indication of whether logons to the pool are enabled (E), or disabled (D). |