IBM 5655-DB2 Server User Manual


 
v
6.1.2 SMSDataClass........................................47
6.1.3 SMSStorageClass......................................48
6.1.4 SMS Management Class. .................................49
6.1.5 SMS Storage Groups . . . .................................50
6.1.6 DB2 STOGROUPs and SMS Storage Groups . .................52
6.1.7 Assigning SMS Classes to DB2 Table Spaces and Index Spaces . . .53
6.1.8 Table Space and Index Space Names for SMS .................56
6.1.9 Managing Partitioned Table Spaces with SMS .................56
6.2 User Databases ............................................57
6.2.1 Online Production Databases . . ............................58
6.2.1.1StorageClasses........................................58
6.2.1.2 Management Classes. . ..................................58
6.2.2 Batch Production Databases . . . ............................58
6.2.2.1StorageClasses........................................58
6.2.2.2 Management Classes. . ..................................58
6.2.3 Data Warehouse Databases . . . ............................58
6.2.3.1StorageClasses........................................59
6.2.3.2 Management Classes. . ..................................59
6.2.4 Development and Test Databases...........................59
6.2.4.1StorageClasses........................................59
6.2.4.2 Management Classes. . ..................................59
6.2.5 Summary..............................................59
6.3 DB2 System Databases ......................................60
6.3.1 Catalog and Directory Databases ...........................60
6.3.1.1StorageClasses........................................61
6.3.1.2 Management Classes. . ..................................61
6.3.2 Work Database . . .......................................61
6.3.2.1StorageClasses........................................61
6.3.2.2 Management Classes. . ..................................61
6.3.3 Summary..............................................61
Chapter 7. Managing DB2 Recovery Data Sets with SMS..............63
7.1 SMSExamplesforDB2RecoveryDataSets ......................63
7.1.1 SMSDataClass........................................63
7.1.2 SMSStorageClass......................................63
7.1.3 SMS Management Class. .................................64
7.1.4 SMS Storage Groups . . . .................................65
7.1.5 AssigningSMSClassestoDB2RecoveryDataSets.............66
7.2 BSDS....................................................67
7.2.1 StorageClass..........................................67
7.2.2 Management Class ......................................67
7.2.3 StorageGroup .........................................68
7.2.4 ACSExample..........................................68
7.3 Active Logs ................................................68
7.3.1 StorageClass..........................................69
7.3.2 Management Class ......................................69
7.3.3 StorageGroup .........................................69
7.3.4 ACSExample..........................................69
7.4 Archive Logs . . . ............................................69
7.4.1 StorageClass..........................................71
7.4.2 Management Class ......................................71
7.4.3 StorageGroup .........................................71
7.4.4 ACSExample..........................................71
7.5 ImageCopies..............................................71