134 Storage Management with DB2 for OS/390
2. Starting RMF2SC on the PC, using appropriate options to select the
reports to be converted.
3. Using your spreadsheet program to manipulate the spreadsheet data.
Details of how todo this depend on which program you are using, but in all
cases, the cells and ranges that you can reference are as described in the
OS/390 RMF Report Analysis, SC28-1950.
RMF2SC is installed on the host along with the rest of the MVS components of
RMF. The deliverable includes the RMF2SC program, sample RMF report files,
macros, and converted RMF spreadsheets. The code of RMF2SC (in the
self-extractingZIP f ile ERB9R2S.EXE) is distributed as member ERB9R2S of the
SERBPWS distribution library.
RMFPP allows youto convert RMF data to spreadsheet format and provides a
practical approach to using spreadsheet macros for converted reports and
overview records. The RMFPP is an extension of RMF2SC and enhances its
capability and flexibility.RMFPP also extends the capability of the RMF
Postprocessorby converting RMF repor tdat a to spreadsheet format. In addition,
the function provides a set of sample spreadsheet macros, which you can use to
process the converted RMF reports, and as a base for your own spreadsheet
macros. The spreadsheet macros contained in the RMFPP are samples to
demonstrate how you can use spreadsheets to process RMF data. Device trend
and cache statistics macros are a good base for I/O monitoring from RMF.
Monitor the RMF home page on the Internet to find information about RMFPP.Go
to the Toolspage of this site:
http://www.s390.ibm.com/rmf
RMFPP currently supports Lotus 1-2-3 Version5 (International English),
Microsoft Excel Version5 and Version7, and Microsoft Excel 97.
11.2.2.5 Global View of a DB2 I/O by DB2 PM and RMF
Each time an application reads or writes data, DB2 requires or updates pages in
buffer pools.DB2, synchronously or asynchronously,issues I/O requests,whic h
can trigger synchronous or asynchronous staging and destaging operations
between cache and physical disks. Figure 53 on page 135 displays the
relationships between DB2 PM and RMF views of an I/O request from or to disk.