VARY DS CONTROL INTERVAL field (DSVCI subsystem parameter)
The DSVCI subsystem parameter controls whether Db2-managed data sets that are created by CREATE TABLESPACE or CREATE INDEX statements are to have variable VSAM control intervals.
Deprecated subsystem parameter: Non-default settings for DSVCI 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 YES.
| Acceptable values: | YES, NO |
|---|---|
| Default: | YES |
| Update: | option 14 on panel DSNTIPB |
| DSNZPxxx: | DSN6SYSP DSVCI |
- YES
- Db2 creates Db2-managed data sets for table spaces and index spaces. The Db2-managed data sets have a VSAM control interval that corresponds to the buffer pool that is used for the table space or index space.
- NO
- Db2-managed data sets are created with a fixed control interval of 4 KB, regardless of the buffer pool size.
This parameter is online-updatable. If you change this value from NO to YES, any pre-existing or migrated data sets remain in 4 KB control intervals until they are 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 they are 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.