same view as cache reports for each LCU: and second, between all LCUs to get the whole storage server view. Some tools, such as IXFP, offer consolidated data. In the case study activities, there is only one active LPAR, so only LCU level consolidation is done.

11.2.2.2 RMF Reporting at Storage Group Level

The RMF DEVICE report, when edited at the Storage Group level, shows the Storage Group’s overall performance from which it is easy to deduce required parallelism. This example focuses only on required fields from DEVICE report at the Storage Group level for a query-intensive activity:

•DEVICE ACTIVITY RATE: 1,042.261

•AVG CONN TIME: 22.3

The required path occupancy (see 11.2.1.2, “Direct Access Device Activity Report” on page 128) for this workload is:

( (1,042.261 x 22.3 ) / 1000 ) x 100 =2,324 %

Therefore, there is a minimal path demand of 24 (23+1). It is wise to allocate such a workload over at least 32 paths, so this Storage Group should be spread over four RVAs with a multiple of eight volumes on each. When there are performance issues, and consolidated channel path performance data shows normal values, as the origin of those is in throughput demand flow (MB/sec), check for high disconnect and/or pending times.

11.2.2.3 Tools Providing More In-Depth Analysis than RMF

When RMF reports show some performance issues that require more in-depth analysis, a generalized trace facility (GTF) of channel command words (CCWs) should be used. PLease refer to OS/390 V2 R6.0 MVS Diagnosis: Tools and Service Aids, SY28-1085, on how to customize the CCW trace. This trace is time-stamped, so storage specialists can control the channel programs issued and analyze their behavior. Some capacity planning information can only be derived at the trace level, in particular bandwidth information, such as number of MB/sec in read and/or in write activities. Such information requires knowledge of the data transmitted by each command. However, for the RVA, an IXFP report edits the global bandwidth, with reads and writes mixed. IXFP calls some internal RVA facilities that dynamically maintain these statistics.

11.2.2.4 Spreadsheet Tools for RMF Analyzis

Two tools, RMF spreadsheet converter (RMF2SC) and RMF spreadsheet reporter (RMFPP), allow automatic data capture from standard RMF Monitor III printouts to most common spreadsheet tools. For RMFPP, the printouts should have been previously saved in EBCDIC format (preferably in fixed mode to allow high quality transmission) in the host before they are downloaded to a PC. These RMF tools are described in Part 6 of the OS/390 V2 R6.0 RMF User's Guide, SC28-1949.

RMF2SC takes output from RMF and converts it to spreadsheet formats. Working with RMF spreadsheets involves three steps:

1.Using RMF to generate the appropriate reports. The result can be in a data set, which you can download to the PC and process as a host data set or on the screen.

I/O Performance and Monitoring Tools

133

Page 154 Page 156
Page 155
Image 155
IBM 5695-DF1, 5655-DB2 manual RMF Reporting at Storage Group Level, Device Activity Rate 1,042.261 AVG Conn Time, 133
Page 154 Page 156

5695-DF1, 5655-DB2 specifications

IBM 5655-DB2 and 5695-DF1 are significant components within the IBM software ecosystem, predominantly focusing on data management and integration solutions. These offerings cater primarily to enterprise environments that require robust database management systems and associated frameworks to maintain and manipulate data efficiently.

IBM 5655-DB2 is a well-known relational database management system (RDBMS) that excels in managing large volumes of structured data. Its architecture is designed to support high availability, scalability, and performance, crucial for businesses operating in today’s data-driven world. Some of its main features include advanced indexing capabilities, support for complex queries, and dynamic workload management. Additionally, it provides strong concurrency controls, which enable multiple users to access and manipulate data simultaneously without compromising data integrity.

One of the key characteristics of DB2 is its support for various data types, including JSON and XML, making it versatile for modern applications that generate data in diverse formats. It also features robust security mechanisms to protect sensitive data, aligning with compliance standards across industries. Integration with analytics tools further allows businesses to derive insights from their data, enhancing decision-making processes.

On the other hand, IBM 5695-DF1, also known as the InfoSphere DataStage, is a powerful data integration tool that facilitates the extraction, transformation, and loading (ETL) of data from various sources to target systems. It empowers organizations to streamline their data flows, ensuring that clean, consistent information is available for analysis and operational use. Key features of 5695-DF1 include a user-friendly graphical interface that enhances developer productivity and a rich set of connectors for numerous data sources, enabling seamless data integration.

DataStage also supports real-time data integration, allowing businesses to keep their data synchronized across multiple platforms. Its parallel processing capabilities dedicatedly optimize performance, enabling organizations to handle vast datasets efficiently. It incorporates data quality tools that help in validating and cleansing data before it is used for decision-making processes.

Both IBM 5655-DB2 and 5695-DF1 are part of a broader strategy to accommodate the evolving landscape of data management. Businesses leverage these technologies to enhance their data architectures, fostering agility and competitive advantage in their respective markets. Their integration capabilities, along with a focus on security and scalability, position them as vital assets in modern enterprise environments. Whether managing critical data within a database or ensuring seamless data flow across systems, these IBM offerings provide a comprehensive approach to handling complex data challenges.
Top Page Image Contents