• Active logs and BSDS.

8.5.2 Methodology

8.5.2.1 Conversion Window

Decide when each type of data is available for conversion. During a normal processing cycle, some data sets will be deleted and reallocated, providing the opportunity for SMS management. Online data must be converted when those services are unavailable (down time). This is the most difficult to schedule, and requires precise planning.

8.5.2.2 Data Movement

Each disk device is either SMS managed or not. A data set is considered SMS managed when:

•It has a valid Storage Class.

•It resides on a volume in an SMS Storage Group, or has been migrated by DFSMShsm.

Data sets can be:

•Converted with movement

•Converted in place

Converted with Movement

This is achieved by using a space management function such as DFSMSdss COPY, DFSMSdss DUMP/RESTORE or DFSMShsm. This method is applicable if the data is application owned. However, consideration must be given to the number of spare disk devices required, while this method is in progress. Also, consider using this approach if the disk devices being used are positioned with storage controls of varying performance (caching). An advantage with this method is allowing data to be allocated using volume thresholds set for each Storage Group, thus allowing space management to operate.

For tablespaces, the DB2 utility REORG can be used to automatically convert with data movement if the tablespace is DB2 defined. If it user defined, then a IDCAMS DELETE/DEFINE CLUSTER must be executed between the REORG phases.

Converted in Place

This is achieved by using DFSMSdss CONVERTV function. This approach requires exclusive use of the data sets residing on the disk device. If data sets are already positioned in pools of volumes, this may be an appropriate method to use (tablespaces are likely to be grouped this way). Be warned, if the volume and data sets do not meet all SMS requirements, DFSMSdss will set the volume's physical status to initial. This status will allow data sets be accessed, but not extended. New allocations on the volume are prevented. If all requirements are met, DFSMSdss will set the volume status to CONVERTED.

8.5.2.3 Tailor Online Conversion

Many installations have data sets that are open and active most of the time. Staging a conversion into smaller manageable portions of data provides safer implementation results.

Converting DB2 to Systems Managed Storage 79

Page 100 Page 102
Page 101
Image 101
IBM 5695-DF1, 5655-DB2 manual Methodology, Converted with Movement, Converted in Place
Page 100 Page 102

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