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

Why we cant use the flat files(sequential file) in CICS


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

Active User


Joined: 14 Jul 2005
Posts: 105

PostPosted: Tue Jun 10, 2008 2:53 pm
Reply with quote

I have not done any CICS programing just was curious why we cnt use the flat files(sequential file) in CICS programing,thanks
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Jun 10, 2008 8:14 pm
Reply with quote

Hello raghavmcs and welcome to the forums,

Typically because cics is a multi-user environment and qsam files are for a single user. QSAM files should be associated with batch processes, not online/cics processes.
Back to top
View user's profile Send private message
bhushan.shete

New User


Joined: 14 Nov 2006
Posts: 17

PostPosted: Tue Nov 11, 2008 2:46 pm
Reply with quote

Hi Dick,

I agree with your answer but i have learnt that QSAM files are used by CICS
in case of extrapartition TDQ's.CICS uses PS datasets in the form of Extrapartition Transient Data Queue(TDQ).

also, QSAM file can be used by multi-user with disp=shr.

please correct me if i am wrong.
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Tue Nov 11, 2008 3:06 pm
Reply with quote

Hi,

Quote:
I agree with your answer but i have learnt that QSAM files are used by CICS


This is new to me. I have worked on a CICS project and all it used was VSAM files.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Tue Nov 11, 2008 5:46 pm
Reply with quote

A TDQ can be a sequential file. It's not common but it does work.

Quote:
also, QSAM file can be used by multi-user with disp=shr.
In a limited sense of everybody reading the file, yes QSAM files can be multi-user. However, if you're wanting multiple jobs to write to the QSAM file you've got issues.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Nov 11, 2008 6:16 pm
Reply with quote

keep in mind that CICS is a online system.

do something, get out.

qsam implies continually doing something, that's BATCH.
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Tue Nov 11, 2008 6:16 pm
Reply with quote

Robert,

Does that mean that files other than VSAM files can also be used in an online application? Please throw some light on this.

I don't have much online experience and the ONLY online project that i had worked on used only VSAM files.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Tue Nov 11, 2008 6:41 pm
Reply with quote

Aaru: Yes, sequential files can be used (in some cases). Transient Data Queue names can point to DD names that are included in the CICS startup JCL; the selected file is either an input-only or output-only file. You would use either READQ TD or WRITEQ TD to access the data in the file. It would not be a good idea to attempt to access this file from outside the CICS region while the region is active -- one of the reasons I said the usefulness is limited. Just to give you an idea, the values specified in the online resource definition are:
Code:
 DEF TD
 OVERTYPE TO MODIFY                                        CICS RELEASE = 0620
  CEDA  DEFine TDqueue(      )
   TDqueue      ==>
   Group        ==>
   DEscription  ==>
   TYPE         ==>                    Extra | INTra | INDirect
  EXTRA PARTITION PARAMETERS
   DAtabuffers  ==>                    1-255
   DDname       ==>
   DSname       ==>
   Sysoutclass  ==>
   Erroroption  ==>                    Ignore | Skip
   Opentime     ==>                    Initial | Deferred
   REWind       ==>                    Leave | Reread
   TYPEFile     ==>                    Input | Output | Rdback
   RECORDSize   ==>                    0-32767
   BLOCKSize    ==>                    0-32767
   RECORDFormat ==>                    Fixed | Variable
   BLOCKFormat  ==>                    Blocked | Unblocked
   Printcontrol ==>                    A | M
   DIsposition  ==>                    Shr | Old | Mod
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Tue Nov 11, 2008 6:51 pm
Reply with quote

Thanks a ton Robert for the information.

Ok I agree that sequential files can be used in few cases, but the input and output files can only be VSAM rite? Am I correct?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Tue Nov 11, 2008 7:12 pm
Reply with quote

Again, input and output files typically are VSAM but extrapartition TD queues (sequential files) can be input or output as well. You wouldn't want to drive your system with them, but you can use them for input or output if warranted.
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Tue Nov 11, 2008 9:35 pm
Reply with quote

Thanks Robert. This is exactly what I wanted.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Tue Nov 11, 2008 9:45 pm
Reply with quote

very awkward to manage with full data integrity,
IIRC extra partition transient data queues are not recoverable ,
in case of improper shutdowns data loss is almost certain

the same result can be obtained with proper output data integrity by using user journals

but check the manuals about the format of the cics journals
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Tue Nov 11, 2008 9:52 pm
Reply with quote

enrico, I believe you're right that they're not recoverable -- not to mention you cannot read and write to them (only read from one or write to one -- one-way operations only). But they can serve some purposes.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Tue Nov 11, 2008 10:05 pm
Reply with quote

continuation of previous posts ( clarification )

fortunately cics uptime is not an issue any longer,
but in case of emergency restarts extrapartition transient data queues
with mission critical data have always been a pain
for input there is no reposition, so operation support must clean up the dataset fed as input
or the program[s] using it must be told what to skip,
unless a plt program takes care of the positioning

for output data, apart from data loss, before a cics restart, the old data must be saved
and for later batch processing all the fragments must be consolidated and validated before use

I found that more than often the issues with extrapartion TD queue slowed down restarts in an unacceptable ways

many customer were relieved when user journals were introduced for output
Back to top
View user's profile Send private message
babuprasad

New User


Joined: 01 Jul 2008
Posts: 7
Location: bangalore

PostPosted: Thu Nov 13, 2008 2:01 pm
Reply with quote

Any idea wat is the RDBACK used in the TYPE for???
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Nov 13, 2008 2:05 pm
Reply with quote

a simple googling with "CICS RDBACK" will provide a link to the manual
with the info You ask for
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 Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
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
Search our Forums:

Back to Top