IBM 5655-DB2 Server User Manual


 
Managing DB2 Recovery Data Sets with SMS 65
Table 20. Management Classes for Recovery Data Sets
7.1.4 SMS Storage Groups
SMS Storage Classes and Management Classes are combined to generate
Storage Groups. This function is performed by the ACS routines. Table 21 on
page 66 shows the relationship between SMS Storage Classes and the SMS
Management Classes with the SMS Storage Groups for DB2 recovery data sets.
Only those Storage Groups needed to satisfy DB2 recovery data set
requirements are defined.
Table 22 on page 66 shows the attributes of the example Storage Groups for DB2
table and index spaces. The five example SMS Storage Groups are:
SGDBIC Storage Group intended for standard image copies.
SGDBICH Storage Group intended for high availability image copies.
SGDBARCH Storage Group intended for primary and secondary archive logs
and for secondary image copies. These data sets will be migrated
by DFSMShsm.
Attribute MCDBICD MCDBICW MCDBICM MCDBLV2 MCDBACTL
Expire after days non-usage
NOLIMIT NOLIMIT NOLIMIT NOLIMIT NOLIMIT
Expire after date/days
425365365NOLIMIT
Retention Limit
NOLIMIT NOLIMIT NOLIMIT NOLIMIT NOLIMIT
Primary days non-usage
770
Level 1 days date/days
770
Command or auto migrate
Both Both Both Both None
# GDG elements on primary
Rolled-off GDS action
Backup frequency
17901
Number of backup versions
(data set exists)
1121
Number of backup versions
(data set deleted)
2221
Retain days only backup
version (data set deleted)
28 28 370 1
Retain days extra backup
versions
28 28 370
Admin or user command
backup
Both Both Both Both
Auto backup
Yes Ye s Yes N o N o