- Configuration Type
- Database manager
- Applies to
-
- Database Server with local and remote clients
- Client
- Database Server with local clients
- Partitioned Database Server with local and remote clients
- Satellite Database Server with local clients
- Parameter Type
- Configurable
- Default [Range]
- 128 [ 16 - 60 000 ]
- Unit of Measure
- Pages (4KB)
- When Allocated
-
- The DRDA Application Server (AS) allocates a DRDA heap each time a DRDA
Application Requester (AR) connects to a DB2 database
- DB2 Connect allocates a DRDA heap each time it connects to a DRDA
AS.
- When Freed
- When a DRDA AR disconnects from the database
This parameter indicates the number of pages to allocate for the memory
used by DB2 Connect and the DRDA Application Server Support Feature.
The following items affect the amount of memory allocated out of this
heap:
- The number of cursors opened by an application
- The number of input host variables
- The number of items in the select list
- The size of input and output data
- The length of SQL statements being bound or prepared.
Recommendation: Use the default value unless you receive
an error code indicating that you do not have enough DRDA heap.