DB2 PM I/O SUMMARY

 

 

 

 

Elapsed (sec):

 

2260

 

 

 

 

 

 

BUFFER POOL Tot4K

requests

 

 

wait / request

 

 

 

 

 

 

per sec

ms per read

 

 

getpages

 

6135875

2714.52

 

 

 

 

synchronous prefetch

164649

 

72.84

 

 

 

 

dynamic

prefetch

26065

 

11.53

 

 

 

 

total prefetch

 

190714

 

84.37

 

9.4

 

 

synchronous reads

19559

 

8.65

 

2.9

 

 

Total read I/O

 

210273

 

93.03

 

8.8

 

 

ACCOUNTING CLASS 3

 

 

 

 

 

 

 

 

 

elapsed sec

 

 

 

 

 

 

Synchronous I/O

 

56.77

 

 

 

 

 

 

Other Read I/O

 

1799.16

 

 

 

 

 

Figure 75. DB2PM I/O Summary

 

 

 

 

 

 

 

 

 

 

 

DEVICE ACTIVITY

 

 

 

 

 

CU-ID

rate

resp_t iosq

pend

disc

conn

path

queing

 

 

ssch/sec

ms

ms

ms

ms

ms

%

ms

RVA_1

 

 

 

 

 

 

 

 

 

1st LCU

2B00

15.778

31.8

0.0

0.2

7.1

24.5

38.7

7.3

2nd LCU

2B40

8.752

33.6

2.0

0.2

6.7

24.7

21.6

8.9

3rd LCU

2B80

14.145

27.2

1.0

0.2

5.4

20.6

29.1

6.6

4th LCU

2BC0

7.923

31.9

0.0

0.2

7.0

24.7

19.6

7.2

tot

 

46.598

30.8

0.7

0.2

6.5

23.4

109.0

7.4

RVA_2

 

 

 

 

 

 

 

 

 

1st LCU

2C00

3.721

33.7

0.0

0.2

9.3

24.2

9.0

9.5

2nd LCU

2C40

14.431

26.3

2.0

0.2

6.3

17.8

25.7

8.5

3rd LCU

2C80

14.540

34.4

0.0

0.2

9.1

25.1

36.5

9.3

4th LCU

22C0

11.668

30.1

0.0

0.2

7.6

22.3

26.0

7.8

tot

 

44.360

30.6

0.7

0.2

7.8

21.9

97.2

8.7

System

71C0

6.963

3.1

0.0

0.4

0.1

2.6

1.8

0.5

Device Activity with Storage Group Report

 

 

 

 

 

 

SG

91.0

31.0

1.0

0.2

7.1

22.7

206.5

8.3

Figure 76. Device Activity Summary

Case Study 155

Page 177
Image 177
IBM 5695-DF1, 5655-DB2 manual DB2 PM I/O 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.