Information

This site will undergo maintenance on Friday, 26 September at 2:00 AM CDT / 12:30 PM IST and may experience a short period of instability during that time.

DSVCI—Variable VSAM control intervals


Use the Modify Data Set Variable VSAM Control Intervals panel or the DSVCI command to control whether Db2 will use VSAM to manage the data set for a table space.

Modify Data Set Variable VSAM Control Intervals panel

DDTJ DHB4 Modify Data Set Variable VSAM Control Intervals    / /
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : VARIABLE VSAM CNTL INTERVALS

Type the new Variable VSAM Control Interval indicator you wish to change to. Then Press Enter

Enable Variable Control Intervals
Enable Variable CI(s) . . . Y (Y, N)

Command syntax and parameters

image2018-12-20_18-35-20.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).

Y

A data set managed by Db2 is created with a VSAM control interval that corresponds to the size of the buffer pool used for the table space.

N

Data sets managed by Db2 will be created with a fixed control interval of 4 KB, regardless of the buffer pool size.

This parameter can be updated online. If you change this value from NO to YES, any pre-existing or migrated data sets remain in 4-KB control intervals until redefined. If you change this value from YES to NO, any pre-existing or migrated data sets in 8-KB, 16-KB, or 32-KB control intervals remain in those control intervals until redefined. You can explicitly redefine a data set. In addition, data sets are implicitly redefined by utilities such as LOAD REPLACE, REORG TABLESPACE, or RECOVER.

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

Vary DS Control Interval

DSNTIP7

None

DSN6SYSP

DSVCI

 

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

OPERTUNE for DB2 12.1