Skip to Content

EXTRASRV—Max extra DRDA query blocks - server

Use the Modify Max Extra DRDA Query Blocks - Server panel or the EXTRASRV command to set the maximum number of extra DRDA query blocks Db2 can return to the remote requester. The new value takes effect immediately. You can use this element to limit the number of blocks according to network capacity.

Modify Max Extra DRDA Query Blocks - Server panel

DDTG DBI1 Modify Max Extra DRDA Query Blocks - Server
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : EXTRA DRDA QUERY BLOCKS

Type the new maximum extra DRDA query blocks value you wish to change to. Then press Enter.

Max Extra DRDA Query Blocks
Extra SRV Query Blocks . . . 0 (0-100 or delta)

Command syntax and parameters

image2018-12-21_13-45-12.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).

value

Maximum number of extra DRDA query blocks Db2 can return from to remote requester. Specify one of the following values:

  • A numerical value in the range 0–100
  • A delta value
    Delta values are expressed numerically (+nn or -nn) or as a percentage (+nn% or -nn%). The resulting value must fall in the range 0–100.

NORESET

The changes you request remain in effect until the Db2 subsystem is cycled.

Db2 parameter values

Field

Installation panel

CLIST parameter

ZPARM macro

ZPARM parameter

Extra SRV Query Blocks

DSNTIP5

EXTRASRV

DSN6SYSP

EXTRASRV

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

OPERTUNE for DB2 12.1