Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Defining a VSAM File as CICS Table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
sainathm

New User


Joined: 09 Feb 2009
Posts: 7
Location: bangalore

PostPosted: Mon Mar 03, 2014 12:03 pm    Post subject: Defining a VSAM File as CICS Table
Reply with quote

We have many CICS regions like TDS1A001, TDS2A003, etc (All these are AOR) TDS1A003 (FOR).

I have a VSAM KSDS file which I want to convert it into CICS table.

1. will data be consistent in all the other regions, if the file or the path is updated from FOR?
2. will the data reflect immediately?
3. How can we restore the data if the data gets corrupted, because of some abends or any issues?

Please guide me.

Thanks
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1827
Location: NY,USA

PostPosted: Mon Mar 03, 2014 1:41 pm    Post subject:
Reply with quote

Please refer to below link and that should answer all of your questions...

http://publib.boulder.ibm.com/infocenter/cicsts/v3r2/index.jsp?topic=%2Fcom.ibm.cics.ts.doc%2Fdfhf1%2Ftopics%2Fdfhf1c0021.html

also just wanted to confirm, are you looking for CMT and UMT as well?
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2504
Location: Atlanta, Georgia, USA

PostPosted: Mon Mar 03, 2014 6:07 pm    Post subject: Reply to: Defining a VSAM File as CICS Table
Reply with quote

In as much as a CMT can be updated, it can defeat the purpose of having a CMT as it should be kept as "Read Only" as the entire file is loaded into extended virtual storage at CICS startup. If you have a VSAM KSDS that requires updating, then use LSRPOOL's together with optimal Data and Index CISZ's.

This is just my opinion and not a mandate, but you should consult with your CICS Sysprog beforehand.

Also, your System Programmer will be pleased if you always use the KEYLENGTH keyword in a given FILE API.

If a file is defined as a REMOTE KSDS to the LOCAL region, the KEYLENGTH is not Function Shipped. If the Keylength is not supplied in the FCT (The Remote Region), then an INVREQ condition is raised.

However, when you explicitly used the KEYLENGTH in the API, the Sysprog doesn't have to go looking for the KEYLENGTH.

Although an undocumented method to define the Keylength value in the FCT is to use a value of 255 (the max VSAM keylength). The actual keylength will then be resolved.

Keep in mind that since CICS/TS 3.2 (with a PTF) and all subsequent version/releases, local VSAM access is Threadsafe, but not remote.

HTH....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Is CICS BMS logic on z/OS different ... Andi1982 CICS 2 Fri Dec 01, 2017 1:56 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us