SMSDCIX—SMS dataclass for indexes

Use the Modify SMS Dataclass Name For Indexes panel or the SMSDCIX command to specify the SMS data class keyword for all table space data indexes.

Modify SMS Dataclass Name For Indexes panel

DDTX DBI1 Modify SMS Dataclass Name For Indexes
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : SMS DATACLASS FOR INDEXES

Type the new SMS Dataclass Name for Indexes that you wish to change to. Then press Enter.

SMS Dataclass Name For Indexes
SMS Dataclass Name . . . . . (Enter "-NONE-" to remove the
 SMS Dataclass Name)

Note

If SMS is not active and a value is specified for SMSDCIX, all corresponding index data sets might not be created, and you might encounter one or more of the following messages:

  • DSNP009I
  • IDC3183I
  • DSNP010I
  • DSNP002I
  • DSNP016I

If SMS is active, you are responsible for ensuring that these specified SMS data class names are set up correctly.

Command syntax and parameters

image2018-12-25_10-11-38.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

Specify the name of the SMS data class for indexes (1–8 alphanumeric characters).

-NONE-

The SMS data class name is removed.

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

SMS Dataclass Name

None

SPRMDCIX

DSN6SPRM

SMSDCIX

 

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