IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Query on CICS file.


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mots

New User


Joined: 16 May 2007
Posts: 6
Location: Pune

PostPosted: Fri Dec 19, 2008 12:32 pm
Reply with quote

Hello,

I'm executing an Online program whose function is to write the records into an ESDS VSAM file after completion of program execution I’m expecting the records should get written into the VSAM file but when I open the VSAM file using TSO File aid option I’m unable to see the records entry into an VSAM file. I closed the online VSAM file and then only I was able to see the records entry in a file.
Could you please suggest why this is happing? What I need to do to see the records entry without closing the VSAM file.
I have defined the VSAM File with below shown options.

DEFINE CLUSTER -
(NAME (NAVUAT.VBCCF.CFD02D6)
VOLUMES (M2VA02) -
RECORDSIZE (750 750) -
CYLINDERS (10 10) -
SHAREOPTIONS (2 3) -
SPEED -
-
NONINDEXED -
) -
DATA -
(NAME (NAVUAT.VBCCF.CFD02D6.DATA) -
CONTROLINTERVALSIZE(1024) -
)

Thank You,
Mots
Back to top
View user's profile Send private message
Rajesh Midde99

New User


Joined: 04 Dec 2008
Posts: 11
Location: Bangalore,India

PostPosted: Fri Dec 19, 2008 4:34 pm
Reply with quote

Hi

The answer is in your question

Quote:

when I open the VSAM file using TSO File aid option I’m unable to see the records entry into an VSAM file. I closed the online VSAM file and then only I was able to see the records entry in a file.


When you are opening the VSAM file in TSO with out giving CLOSE disable in CICS, It gives you the previous status of records held on that ESDS file.
Which means, it doesn't gets updated. When you close it, by Exclusive CLOSE command, the file gets closed and will able to give you the updations made. I can't give you more info regarding the storages and what happens internally.

Correct me, If I am wrong and Please let me know how the internal process works in this case?

Regards
Rajesh
Back to top
View user's profile Send private message
mots

New User


Joined: 16 May 2007
Posts: 6
Location: Pune

PostPosted: Fri Dec 19, 2008 5:35 pm
Reply with quote

I suppose looking at this process the Records data is get stored in Buffer and after closing the file it get released to file and then only the records are get populated. but i have other file KSDS it shows me the records just after complition of the program execution.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Fri Dec 19, 2008 6:12 pm
Reply with quote

Is the VSAM file in a CICS LSR pool? This can affect when the buffers are flushed to disk. The problem symptoms you're describing are classic buffer issues -- sometimes CICS requires the file to be closed before it will write the buffers to disk, and until the buffers are written to disk no batch program is going to see the latest CICS additions.
Back to top
View user's profile Send private message
Garry Carroll

Senior Member


Joined: 08 May 2006
Posts: 1193
Location: Dublin, Ireland

PostPosted: Fri Dec 19, 2008 6:39 pm
Reply with quote

IFIRC, CICS loads the VSAM catalog info on file open and it is not updated until the VSAM file is closed in CICS. Thus, TSO sees the file as it was when CICS opened it.

Garry.
Back to top
View user's profile Send private message
Earl Haigh

Active User


Joined: 25 Jul 2006
Posts: 475

PostPosted: Fri Dec 19, 2008 8:29 pm
Reply with quote

Quote:
Could you please suggest why this is happing? What I need to do to see the records entry without closing the VSAM file.


ESDS Vsam files need to be closed before trying to view from another
region. You can not view ALL the records without first closing the
ESDS file. thats the way it works icon_cool.gif
Back to top
View user's profile Send private message
mots

New User


Joined: 16 May 2007
Posts: 6
Location: Pune

PostPosted: Mon Dec 22, 2008 11:11 am
Reply with quote

Hi Earl Haigh,

Can you clarify me is it a case only with VSAM ESDS file or all type of VSAM files (i.e.KSDS, RRDS). Since I have a another KSDS file and there I'm able to see the records after completion of PGM execution and without closing the KSDS file.
Back to top
View user's profile Send private message
Earl Haigh

Active User


Joined: 25 Jul 2006
Posts: 475

PostPosted: Mon Dec 22, 2008 10:07 pm
Reply with quote

ESDS only ..
Back to top
View user's profile Send private message
sdsinfo

New User


Joined: 14 Jan 2008
Posts: 10
Location: bangalore

PostPosted: Tue Dec 30, 2008 5:43 pm
Reply with quote

Hi,

this is the case with all the vsam files.

u can not open a file which is already opened.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Tue Dec 30, 2008 9:55 pm
Reply with quote

Quote:
this is the case with all the vsam files.

u can not open a file which is already opened.
Sorry -- WRONG! Check out what SHAREOPTIONS are used for and specifically what (2,3) means. As long as a VSAM file is being used for reading only, and has the SHAREOPTIONS set correctly, any number of processes can open that file simultaneously.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 1
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Using API Gateway from CICS program CICS 0
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top