©Copyright IBM Corp. 1999 47
Chapter 6. Managing DB2 Databases with SMS
This chapter describes DB2 databases from the point of viewof their attributes
for SMS management, and provides examples forthese databases. Due to their
stricter availabilityrequirements, the DB2 system databases are analyzed
separately.
Thischapter includes examples of SMS Data, Storage, and Management Classes
for DB2 tablespaces. These examples are applied to DB2 system tablespaces
and to DB2 applicationtable spaces grouping them in four different user
environments.

6.1 SMS Examples for DB2 Databases

The followingexamples are provided to show how SMS can be used to manage
DB2 table spaces. These examples do not show all possibilities SMS offers to an
installation.E ach installationcan review these examples and create those
classes that best suitits environment. The examples shown here are extracted
and adapted from DFSMS/MVS Implementing System-Managed Storage,
SC26-3123.
Naming Convention:
The followingnaming structure is used for the example SMS constructs. Each
name has atwo-character SMS construct identifier, two characters ’DB’ to identify
them as SMS constructs used for DB2, followedby a variable length (aaaa) text.
This naming conventionis:
DCDBaaaa SMS Data Classes forD B2
SCDBaaaa SMS Storage Classes for DB2
MCDBaaaa SMSManagement Classes for DB2
SGDBaaaa SMS Storage Groups for DB2

6.1.1 Using ISMF to Display SMS Constructs

A DB2 administratorcan use ISMF to access and examine the different SMS
constructs in the installation. A storage administratorus es ISMF to create and to
manage the SMS constructs. Figure 14 on page 48 shows how to display the
activeData Class DCDB2.
The options availableon the DATACLASS APPLICATION SELECTION panel are
dependent on the authorization of the user. Only a user authorized to manage
SMS constructs is allowed todef ineor alter them. Other users may only have
options 1 (List) and 2 (Display)available.

6.1.2 SMSData Class

All DB2 table spaces, either forsystem or for user data, have exactly the same
attributes.One Data Class can be defined for all these data sets. The Data Class
allows an overrideof space parameters (primary and secondar y allocation
quantity) because thosewill be different for each table space. Figure 15on page
48 showss omeinformation from the Data Class DCDB2, a Data Class example
for DB2 tables pacesand index spaces.