©Copyright IBM Corp. 1999 xv
Tabl es
1. Summary of Partition and Partitioned Table Space Sizes . . ..............12
2. DB2 Image Copy with and without Concurrent Copy.................... 21
3. Table Space and Index Space Names............................... 23
4. BSDSNames..................................................23
5. ActiveLogDataSetNames.......................................23
6. ArchiveLogandBSDSBackupNames..............................24
7. SampleImageCopyNames......................................24
8. DataClassAttributes............................................ 39
9. StorageClassAttributes................................. ........40
10. Management Class Attributes . . . ..................................42
11.StorageGroupAttributes.........................................45
12.SMSStorageClassesforDB2Databases............................49
13. SMS Management Classes for DB2 D atabases . . ....... ..............50
14. Relating SMS Storage and M anagement Classes to Storage Groups ......51
15. SMS Storage Groups for DB2 Databases . ............. ..............51
16. Table Space and Index Space Names with SMS Codes . . . ..............56
17. Examples of SMS Class Usage for DB 2 User Databases . . ..............60
18. DB2 System Database R equirements ...............................61
19.SMSStorageClassesforRecoveryDataSets........................64
20. Management Classes for Recovery Data Sets . . . .....................65
21. Relating SMS Storage and M anagement Classes to Storage Groups ......66
22.SMSStorageGroupsforDB2RecoveryDataSets.....................66
23.StorageGroupsforDB2RecoveryDataSets.........................73
24. Number of Pages Read Asynchronously in One Prefetch Request . .......106
25. Maximum Pages in One Write O peration. . .......................... 108
26. Trace Requirement for the I/O Activity Repo rts. . . ....... .............124
27.RVASpaceUtilizationComparison................................153
28.TestCase3-StorageGroupVolumes.............................170
29.TestCase4-StorageGroupVolumes.............................175
30.TestCase5-StorageGroupVolumes.............................179
31.TestCase6-StorageGroupVolumes.............................182
32.BSDSandActiveLogs-StorageGroupVolumes....................187
33.ArchiveLogs—StorageGroupVolumes.. .......................... 193
34.ImageCopies—StorageGroupVolumes............................197