EXTRA BLOCKS SRV field (EXTRASRV subsystem parameter)
The EXTRASRV subsystem parameter limits the number of extra DRDA query blocks that Db2 is to return to a DRDA client. This parameter not limit the size of the SQL query answer set. It simply controls the total amount of data that can be transmitted on a network exchange.
Deprecated subsystem parameter: Non-default settings for EXTRASRV are deprecated. Db2 12 supports these settings, but their use is discouraged, and support is removed in Db2 13 or later. For best results, use the default value 100.
| Acceptable values: | 0–100 |
|---|---|
| Default: | 100 |
| Update: | option 46 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP EXTRASRV |