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
 

 

How to copy online allocated vsam to qsam

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

New User


Joined: 09 Oct 2007
Posts: 81
Location: India

PostPosted: Tue Sep 16, 2008 8:50 pm    Post subject: How to copy online allocated vsam to qsam
Reply with quote

Hi all,
I had used the below command to copy the VSAM in to QSAM.
"REPRO INDATASET('"VSAM-FILE"') OUTDATASET('"QSAM-FILE"')"

But if the VSAM file is allocated in the online region the above command is getting failed by throwing the message that dataset is in use. icon_sad.gif

But im just trying to only take a copy of it.

Is there any other way to copy VSAM in to QSAM even if it allocated in online regions?
Back to top
View user's profile Send private message

dick scherrer

Site Director


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

PostPosted: Wed Sep 17, 2008 12:06 am    Post subject:
Reply with quote

Hello,

Does your jcl have disp=old? If so, you might try disp=shr.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Sep 17, 2008 3:21 am    Post subject:
Reply with quote

Hi,

I don't work with CICS much, so got a concern here, does this
Quote:
allocated in online regions
really make a difference in working with VSAM ? Please advise.
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Wed Sep 17, 2008 7:12 am    Post subject:
Reply with quote

Hi Anuj,

If "something" has disp=old, it has "locked" the dataset. Nothing special about vsam and cics that i'm aware of.

This is similar to the "dataset in use" that happens fairly often in tso/ispf.
Back to top
View user's profile Send private message
Manigandan Aravindhan

New User


Joined: 09 Oct 2007
Posts: 81
Location: India

PostPosted: Wed Sep 17, 2008 3:05 pm    Post subject: Reply to: How to copy online allocated vsam to qsam
Reply with quote

Hi Dick,
Thanks for your response.. icon_smile.gif

The same VSAM file i can copy through Fileaid tool. But if try to repro it using the REXX it is throwing the message that file in use. Is there any other way to copy the VSAM using REXX?
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Wed Sep 17, 2008 4:02 pm    Post subject:
Reply with quote

Hi,

try using
Code:
  REPRO INFILE(FILEIN) OUTFILE(FILEOUT)


When using INDATASET I'm pretty sure it wants exclusive access to the file.


Don't forget you now need to add the 2 DD names to the JCL

//FILEIN DD DSN=input file
//FILEOUT DD DSN=output file

Gerry
Back to top
View user's profile Send private message
Manigandan Aravindhan

New User


Joined: 09 Oct 2007
Posts: 81
Location: India

PostPosted: Wed Sep 17, 2008 4:10 pm    Post subject: Reply to: How to copy online allocated vsam to qsam
Reply with quote

Thanks Gcicchet,
Is there anyway to do this without JCL....??
Back to top
View user's profile Send private message
Manigandan Aravindhan

New User


Joined: 09 Oct 2007
Posts: 81
Location: India

PostPosted: Wed Sep 17, 2008 4:15 pm    Post subject: Reply to: How to copy online allocated vsam to qsam
Reply with quote

Note: The command "REPRO INDATASET('"VSAM-FILE"') OUTDATASET('"QSAM-FILE"')" i didnt used it in JCl....I used it in REXX without the help of JCL.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Wed Sep 17, 2008 4:51 pm    Post subject:
Reply with quote

gcicchet wrote:
When using INDATASET I'm pretty sure it wants exclusive access to the file.


Gerry, you're right. I just double-checked with the IDCAMS manual.

Quote:

INDATASET(entryname)
specifies the name of the entry to be copied or user catalog to be merged. If INDATASET is specified, the entryname is dynamically allocated with a disposition of OLD.


Manigandan Aravindhan, it appears that you'll have to allocate VSAM-FILE so you can specify a disposition of SHR, and then use INFILE instead of INDATASET.
Back to top
View user's profile Send private message
ajaybshukla

New User


Joined: 09 Sep 2008
Posts: 39
Location: india

PostPosted: Sat Oct 04, 2008 10:35 pm    Post subject: Reply to: How to copy online allocated vsam to qsam
Reply with quote

Hi all,

You people might have heard about SYSB utility which is used to repro a VSAM file when it is being used in CICS region.
I'hv done it somedays back but i dont remember its actual syntax.
in that we need to give region name and some other info.

Please correct me if i'm wrong.

Thanks n Regards,
ajay
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Sun Oct 05, 2008 12:29 am    Post subject:
Reply with quote

Hello,

Do you have a question?

It is not clear if you are looking for something or are just mentioning some site-specific utility?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sun Oct 05, 2008 1:22 am    Post subject:
Reply with quote

Hi Dick,

I was also curious about that (SYSB utility )..it seems to be a third party tool rather..

http://www.hwcs.com/software/specifications/sysb.asp

I didn't dig much though as I dont' work on CICS.
Back to top
View user's profile Send private message
aparicio esteves

New User


Joined: 17 Sep 2008
Posts: 4
Location: Lisbon

PostPosted: Sun Oct 05, 2008 2:47 am    Post subject:
Reply with quote

I think that you must close the vsam file in CICS, because I remember doing this 10 years ago, when we need to access the same vsam file outside CICS region.

The comand to do this is:

Code:

CEMT I FILE (FIAVMNT)



Where FIAVMNT is the name that is associated with the DSName that you want to access

Or if you don't know the external name you could put an * between () and look for the pair of lines that contains the DSName of the file that you want

Then in the statement below you must override Ope with Clo and Ena with Dis and press Enter

Code:

I FILE (FIAVMNT)                                           
STATUS:  RESULTS - OVERTYPE TO MODIFY                     
 Fil(FIAVMNT ) Vsa Ope Ena Rea Upd Add Bro Del     Sha     
        Dsn( XXXX.YYYYST.FIAVMNT                            )
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Sun Oct 05, 2008 4:47 am    Post subject:
Reply with quote

Hello,

Earlier in this topic, Gerry posted a way to do this without closing the file. . .
Back to top
View user's profile Send private message
ajaybshukla

New User


Joined: 09 Sep 2008
Posts: 39
Location: india

PostPosted: Tue Oct 07, 2008 1:01 pm    Post subject: Reply to: How to copy online allocated vsam to qsam
Reply with quote

Hi all,
following is the syntax of SYSB utility

SUBSYS=(SYSB,'CICS=CICSREGION','FCT=FCTENTRYNAME',
HPO,'STATUS=CE','BUFFER=AUTO','SYNC=900')

this i have got, check will it work or not.

Thanks,
Ajay
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 syncsort: copy lines after the keyword shreya19 SYNCSORT 1 Fri Dec 02, 2016 9:47 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am
No new posts CICS VSAM RLS READ akodakka CICS 3 Tue Oct 04, 2016 3:09 pm


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