CICS datatables vs DB2
Select messages from
# through # FAQ
[/[Print]\]

MVSFORUMS.com -> CICS and Middleware

#1: CICS datatables vs DB2 Author: manu PostPosted: Sun Jan 21, 2018 1:43 pm
    —
Hi,

Reference tables for an application is stored in VSAM as CDT tables in CICS. There is a plan to move this data into DB2 tables.Any inputs on the performance implications due to this? I just wanted to get a highlevel PROS and CONS of doing this.I appreciate your inputs on this.Thanks.

#2:  Author: kolusuLocation: San Jose PostPosted: Mon Jan 22, 2018 12:11 pm
    —
manu,

CDT tables are nothing but VSAM files. So you are converting a VSAM file to a DB2 Table.

So you need to take a 2 step process and first migrate the data to DB2 table and then rewrite the application to read/write the data from DB2 table.

IBM has a product named "CICS VSAM Transparency for z/OS Version" which you can give it a try.



MVSFORUMS.com -> CICS and Middleware


output generated using printer-friendly topic mod. All times are GMT - 5 Hours

Page 1 of 1

Powered by phpBB © 2001, 2005 phpBB Group