The session specifications in the following table apply to a single session:
|
Parameter |
Value |
|||
|
Maximum number of sessions per PE. |
120 |
|||
|
Maximum number of sessions per gateway vproc. See Utilities for details. |
Tunable: 1 - 2,147,483,647. 1,200 maximum certified. The default is 600. |
|||
|
Maximum number of active request result spools per session. |
16 |
|||
|
Maximum number of parallel steps per request. Parallel steps can be used to process a request submitted within a transaction (which can be either explicit or implicit). |
20
|
|||
|
Maximum number of materialized global temporary tables that can be materialized simultaneously per session. |
2,000 |
|||
|
Maximum number of volatile tables that can be instantiated simultaneously per session. |
1,000 |
|||
|
Maximum number of SQL procedure diagnostic areas that can be active per session. |
1 |
|||