Simulate potential policy changes and understand the costs of those changes.

Produce presentation quality charts.

For more information on the DFSMS/MVS Optimizer Feature, see the following publications:

DFSMS Optimizer V1R2 User's Guide and Reference, SC26-7047-04

DFSMS Optimizer: The New HSM Monitor/Tuner, SG24-5248

4.3.6SMF Records 42(6)

DFSMS statistics and configuration records are recorded in SMF record type 42.

The type 42, subtype 6, SMF record provides information about data set level performance. DFSMS must be active, but the data set does not need to be SMS managed. Two events cause this record to be generated: data set close time and each type 30 interval record being written.

You can use DFSMSopt or any SMF specialized package to format and display this useful record. For instance, you can start by looking at the list of the first 20 data sets in terms of activity rate at the specified interval and verify that the most accessed DB2 data sets are performing as expected both in terms of I/O and usage of DB2 buffer pools.

Also, accesses to critical data sets can be tracked periodically by data set name. Their performance can be mapped against the DB2 PM accounting to determine detailed characteristics of the I/O executed, and to verify cache utilization.

4.4 Benefits

A summary of the benefits of SMS follows:

Simplified data allocation

SMS enables users to simplify their data allocations. Without using SMS, a user would have to specify the unit and volume on which the system should allocate the data set. In addition, space requirements would need to be calculated and coded for the data set. With SMS, users can let the system select the unit, volume and space allocation. The user therefore, does not need to know anything about the physical characteristics of the devices in the installation.

Improved allocation control

Free space requirements can be set using SMS across a set of disk volumes. Sufficient levels of free space can be guaranteed to avoid space abends. The system automatically places data on a volume containing adequate freespace.

Improved performance

SMS can assist in improving disk I/O performance, and at the same time reduce the need for manual tuning by defining performance goals for each class of data. Cache statistics, recorded in system management facilities (SMF) in conjunction with the Optimizer feature, can be used to assist in evaluating performance. Sequential data set performance can be improved by using extended sequential data sets. The DFSMS environment makes the most effective use of the caching abilities of disk technology.

32Storage Management with DB2 for OS/390

Page 54
Image 54
IBM 5655-DB2, 5695-DF1 manual Benefits, SMF Records

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.