Chapter 8. Converting DB2 to Systems Managed Storage

This chapter describes the techniques for converting DB2 data to SMS. However, each customer has unique data sets and facilities to support their online environment. These differences have an impact on recommended storage management procedures. Database data has different space, performance, and availability requirements; therefore, dividing database data into categories will help identify the required SMS services and implement a staged conversion to SMS.

8.1 Overview

In order for the DB2/SMS relationship to be successful, the data base administrator (DBA) must clearly specify the characteristics and requirements of the DB2 data sets. The storage administrator must also ensure they are satisfied in the physical implementation.

All types of DB2 data are important for successful operation of a DB2 environment. Great care must be taken in preparing DB2 for its conversion to SMS management.

Under most circumstances, an installation will have already implemented SMS to some degree prior to considering the management of DB2; likely candidates are batch and TSO data sets. Therefore, it is assumed that sufficient skills exist within the storage administrator’s area to provide the levels of support needed.

If possible, it is recommended to first convert a DB2 test system to DFSMS, in order to gain experience with the various aspects of the DB2/SMS relationship. The DB2 administrator and storage administrator should work closely together to test the environment. Once satisfied with this scenario, a migration plan should be developed to convert DB2 data.

The technique and implementation sequence for converting a DB2 system to SMS varies according to each installation. However, the following topics provide

aguideline:

Advantages of SMS managing DB2 data

SMS management goals

Positioning for implementation

Conversion processes

DFSMS FIT

NaviQuest

8.2Advantages of SMS Managing DB2 Data

ACS routines can be designed so that SMS restricts the allocation of data sets in DB2 Storage Groups to production databases and selected system data sets. Only authorized users, such as the DB2 administrator or storage administrator can allocate data in these Storage Groups. They also will have the authority to allocate data sets with critical performance and availability requirements to specific volumes. Dual copy provides high availability for selected data sets that

© Copyright IBM Corp. 1999

75

Page 97
Image 97
IBM 5695-DF1, 5655-DB2 Converting DB2 to Systems Managed Storage, Overview, Advantages of SMS Managing DB2 Data, Dfsms FIT

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.