Skip to Content

IMMEDWRI—Immediate write indicator

Use the Immediate Write panel or the IMMEDWRI command to control when Db2 writes updated pages that are dependent on the group buffer pools. This element is only applicable when the Db2 is a data sharing Db2.

Immediate Write panel

DDTJ DHB4 Immediate Write
Command ===> _________________________________________________________________

  Command: CURRENT
Description . . . . . . . . : IMMEDIATE WRITE INDICATOR

Type the new Immediate Write Indicator that you wish to change to. Then press Enter.

Immediate Write
Immediate Write Indicator . YES (YES, NO, PH1)

Command syntax and parameters

image2018-12-21_15-11-19.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).

NO
YES
PH1

Controls when the Db2 writes updated GBP-dependent pages (only applicable to data sharing).

  • NO means pages are written at phase 2 of commit (normal activity).
  • PH1 means pages are written at phase 1.
  • YES means pages are written immediately.

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

Immediate Write

DSNTIP8

None

DSN6GRP

IMMEDWRI

 

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

OPERTUNE for DB2 12.1