Software enables VSAM file to DB2® table data migration.

Press Release Summary:



Without modification to CICS or batch VSAM application programs, CICS® VSAM Transparency for z/OS® v1.2 ensures continued access to data in DB2 with minimal changes to CICS and batch configurations. Dual Mode Facility assists with testing of migrated data and development of user exits, while mapping component supports Auto Mapper feature for PL/I and Assembler copybooks. Performance features enable CICS VT-generated SQL driver modules to be re-entrant.



Original Press Release:



IBM CICS VSAM Transparency for z/OS V1.2 Enables Data Migration from VSAM Files to IBM DB2 Tables



At a glance

CICS VSAM Transparency (CICS VT) for z/OS V1.2 enables the migration of data from VSAM files to DB2 tables. It ensures continued access to the data in DB2, without modification to the CICS or batch VSAM application programs and with only minor changes to CICS and batch configurations.

CICS VT V1.2 extends the capabilities of V1.1 by adding the following features:

Dual Mode Facility - To assist with testing of migrated data and in the development of user exits

Enhancements to the mapping component - To add support to the Auto Mapper feature for PL/I and Assembler copybooks

Performance enhancements - To enable the CICS VT-generated SQL driver modules to be re-entrant

For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).

Overview

If you have CICS® and batch applications with data in VSAM files and would like to move that data to DB2®, but have been deterred by cost, time, and lack of resource, then you will be interested in the new IBM CICS VSAM Transparency (CICS VT) for z/OS® V1.2 program.

CICS VT enables the migration of data from VSAM files to DB2 tables. It ensures continued access to the data in DB2, without modification to the CICS or batch VSAM application programs and with only minor changes to CICS and batch configurations.

CICS VT is a set of conversion tools and a run-time management control component. The conversion tools include all the utilities required for conversion of VSAM key sequenced data sets (KSDS) and relative record data sets (RRDS) files to DB2 tables, the generation of the DB2 SQL drivers, and the one time migration of data into DB2 from VSAM.

The run-time component intercepts the application program's original and unaltered VSAM calls, processes them in the generated DB2 SQL driver, and returns the results to the calling program.

Key prerequisites

z/OS V1.4 (5694-A01), or later

CICS Transaction Server (CICS TS) for OS/390® V1.3 (5655-147)

Or either this one:

CICS TS for z/OS V2.2 or V2.3 (5697-E93)

Or either these:

CICS TS for z/OS V3 (5655-M15)

DB2 for OS/390 and z/OS V7 (5675-DB2)

Or either this one:

DB2 for z/OS V8 (5625-DB2)

Planned availability date

June 17, 2005

All Topics