Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 1626
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: 2502
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 CICS to Webservices safexc CICS 1 Sun Jan 22, 2017 5:49 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 3 Thu Jan 19, 2017 1:31 am
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us