Filter
Top Products
viii Storage Management with DB2 for OS/390
Chapter 12. Case Study....................................... 141
12.1 DB2CaseStudyAnalysis .................................. 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 Data Sets ..............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 the Database . . .....................................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