viii Storage Management with DB2 for OS/390
Chapter 12. Case Study.......................................141
12.1DB2CaseStudyAnalysis..................................141
12.1.1 General Analysis . . ...................................141
12.1.1.1ElapsedandCPUTime.................................141
12.1.1.2SQLStatements................................. .....141
12.1.1.3 Time Not Accounted ...................................143
12.1.2 DataAccess........................................144
12.1.3 Suspend Times . . . ...................................145
12.1.3.1 Synchronous I/O . .....................................145
12.1.3.2AsynchronousReadI/O.............. ..................146
12.1.3.3I/ORate.............................................146
12.1.4 Conclusions.........................................147
12.2 StorageServerAnalysis................................... 147
12.2.1 RMFViews .........................................147
12.2.1.1DeviceActivityReportAnalysis...........................149
12.2.1.2 I/O Queuing Activity Report Analysis ......................149
12.2.1.3 Channel Path Activity Report Analysis . . . ..................150
12.2.1.4 Cache Subsystem Activity Reports Analysis.................151
12.2.2 IXFPView..........................................152
12.2.2.1DevicePerformanceOverallSummary.....................152
12.2.2.2 Cache effectiveness Overall Summary . . . ..................153
12.2.2.3SpaceUtilizationSummary..............................153
12.3 CaseStudySummary.....................................154
Part 4. Appendixes ............................................................159
Appendix A. Test Cases for DB2 Table Space DataSets ..............161
A.1 TestEnvironment..............................................161
A.2 Partitioned Table Space, DB2 Defined, Without SMS ..................162
A.2.1 Create EightSTOGROUPs..................................162
A.2.2 Create theDat abase . . .....................................162
A.2.3 CreatetheTableSpace.....................................163
A.2.4 DisplayaVolume..........................................163
A.3 Partitioned Table Space, User Defined, Without SMS..................164
A.3.1 DEFINECLUSTERfor16Partitions...................... .....164
A.3.2 CREATESTOGROUP......................................164
A.3.3 CREATEDATABASE ................................. .....164
A.3.4 CREATETABLESPACE....................................164
A.3.5 DisplayaVolume..........................................165
A.4 DB2TableSpacesUsingSMS,ExistingNames......................165
A.4.1 StorageClasses...........................................166
A.4.2 Management Class . . . ................... ..................167
A.4.3 StorageGroup............................................169
A.4.4 ISMFTestCases..........................................171
A.4.5 UpdatingtheActiveConfiguration.............................172
A.4.6 DB2Definitions ...........................................172
A.4.7 DataSetAllocationResults..................................173
A.5 DB2 Table Spaces Using SMS, Coded Names..... ..................174
A.5.1 StorageClass............................................174
A.5.2 Management Class . . . ................... ..................175
A.5.3 Storage Groups ...........................................175
A.5.4 DB2Definitions ...........................................177
A.5.5 DataSetAllocationResults..................................177