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. |
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 for which a session can create an instance simultaneously. |
1,000 |
Maximum number of SQL procedure diagnostic areas that can be active per session. |
1 |