12.2.2 IXFP View

IXFP builds RVA statistics reports at the level of the storage server: it has a hardware standpoint, and so consolidates activities from sharing LPARs. This standpoint also gives to IXFP a good knowledge of data handed into each channel program. Information on functional volumes mapping to physical disk space is also available. For the case study, where only one unique query activity occurred in both the RVA Storage Groups, IXFP information complements the RMF view.

12.2.2.1 Device Performance Overall Summary

The Figure 72 on page 152 shows an extract of these reports, for both RVAs. Three items of information confirm that the storage servers are not at their utilization limit:

I/O activity and bandwidth. For each RVA, there are roughly 45 I/Os per second. This generates a throughput from 5 MB to 5.5 MB per second on each RVA.

Service time. For each RVA, the service time is roughly 30 milliseconds, of which 25% is disconnect time. Connect times are high, because of the 110-120 KB average size of data transferred per I/O.

Net capacity load. The NCL is 56.4% for subsystem 20395 and 29.7% for subsystem 22897.

 

XSA/REPORTER

 

 

 

DEVICE PERFORMANCE OVERALL SUMMARY

 

 

 

SUBSYSTEM 20395

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SUBSYSTEM

% DEV

I/O

KBYTES

 

ACCESS

-I/O SERVICE TIME (MS)- % DEV

% DEV

% DEV

 

 

 

SUMMARY

AVAIL

PER SEC

PER SEC

DENSITY

TOTAL

DISC

 

CONNECT

 

UTIL

DISC

CONN

 

 

 

 

-----

-------

-------

-------

-----

------

-------

-----

-----

-----

 

 

 

PROD PARTITION

100.0

45.7

5481.4

0.1

30.5

7.3

23.3

 

0.5

0.1

0.4

 

 

 

OVERALL TOTALS

100.0

45.7

5481.4

0.1

30.5

7.3

23.3

 

0.5

0.1

0.4

 

 

 

SUBSYSTEM 20395

 

DISK ARRAY SUMMARY

 

 

 

 

 

 

 

 

 

 

 

AVG % DRIVE

COEFF OF

NET CAPACITY LOAD %

FREE SPACE COLLECTION LOAD

COLL FREE SPC (%)

UNCOLL FREE SPC (%)

MODULE UTIL

VARIATION

TEST

PROD

OVERALL

TEST

PROD

OVERALL

 

TEST

PROD

OVERALL

TEST

PROD

OVERALL

----------------------

-----

-----

-------

-----

-----

-------

 

-----

-----

-------

-----

-----

-------

10.6

78

0.0

56.4

 

56.4

0.0

0.0

 

0.0

 

0.0

42.4

42.4

0.0

1.2

1.2

SUBSYSTEM 22897

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SUBSYSTEM

% DEV

I/O

KBYTES

 

ACCESS

-I/O SERVICE TIME (MS)- % DEV

% DEV

% DEV

 

 

 

SUMMARY

AVAIL

PER SEC

PER SEC

DENSITY

TOTAL

DISC

 

CONNECT

 

UTIL

DISC

CONN

 

 

 

 

-----

-------

-------

-------

-----

------

-------

-----

-----

-----

 

 

 

PROD PARTITION

100.0

44.5

5036.8

0.1

29.7

7.8

22.0

 

0.5

0.1

0.4

 

 

 

OVERALL TOTALS

100.0

44.5

5036.8

0.1

29.7

7.8

22.0

 

0.5

0.1

0.4

 

 

 

SUBSYSTEM 22897

 

 

DISK ARRAY SUMMARY

 

 

 

 

 

 

 

 

 

 

AVG % DRIVE

COEFF OF

NET CAPACITY LOAD % FREE SPACE COLLECTION LOAD

 

COLL FREE SPC (%)

UNCOLL FREE SPC (%)

MODULE UTIL

VARIATION

TEST

PROD

OVERALL

TEST

PROD

OVERALL

 

TEST

PROD

OVERALL

TEST

PROD

OVERALL

----------------------

-----

-----

-------

-----

-----

-------

 

-----

-----

-------

-----

-----

-------

13.2

86

0.0

25.2

 

25.2

0.0

0.0

 

0.0

 

0.0

73.9

73.9

0.0

0.9

0.9

Figure 72. Case Study IXFP Device Performance Case Summary Extract

152Storage Management with DB2 for OS/390

Page 174
Image 174
IBM 5655-DB2, 5695-DF1 manual Ixfp View, Device Performance Overall Summary

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.