View previous topic :: View next topic |
Author |
Message |
anita_m Beginner
Joined: 20 Sep 2006 Posts: 41 Topics: 12 Location: Venus
|
Posted: Wed Apr 18, 2007 3:58 pm Post subject: How to find the user who is editing a VSAM File? |
|
|
When a VSAM file is opened in edit mode, is there a way I can know who is using it? If yes could you please specify, how. |
|
Back to top |
|
|
dbzTHEdinosauer Supermod
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
|
Posted: Wed Apr 18, 2007 5:13 pm Post subject: |
|
|
Often the interactive utility that you use which tells you that someone else has an 'exclusive lock' on a file will provide some guidance if you immediately key PF1 after the display.
whatever utility you are using to 'edit the VSAM file' has a manual, which may also provide some info. _________________ Dick Brenholtz
American living in Varel, Germany |
|
Back to top |
|
|
anita_m Beginner
Joined: 20 Sep 2006 Posts: 41 Topics: 12 Location: Venus
|
Posted: Wed Apr 18, 2007 5:44 pm Post subject: |
|
|
We are using Fileaid. On hitting PF1 it only gives the following message.
" file is allocated to another job or user" I need the RACF ID |
|
Back to top |
|
|
dbzTHEdinosauer Supermod
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
|
Posted: Wed Apr 18, 2007 8:06 pm Post subject: |
|
|
Sorry, try PF1 twice... _________________ Dick Brenholtz
American living in Varel, Germany |
|
Back to top |
|
|
semigeezer Supermod
Joined: 03 Jan 2003 Posts: 1014 Topics: 13 Location: Atlantis
|
Posted: Thu Apr 19, 2007 10:24 am Post subject: |
|
|
or TSO ISRDDN C |
|
Back to top |
|
|
anita_m Beginner
Joined: 20 Sep 2006 Posts: 41 Topics: 12 Location: Venus
|
Posted: Thu Apr 19, 2007 11:53 am Post subject: |
|
|
PF1 twice gets me to a 'FILE-EDIT' screen.
TSO ISRDDN C did get me to a 'System ENQ Contention' but I am not able to figure out how to go about it further.
My job is waiting for a vsam file. This file is closed in CICS. |
|
Back to top |
|
|
expat Intermediate
Joined: 01 Mar 2007 Posts: 475 Topics: 9 Location: Welsh Wales
|
Posted: Fri Apr 20, 2007 1:55 am Post subject: |
|
|
It's a long long time since I've played with CICS and VSAM, but if the file is CLOSED in CICS, can it not still be allocated to CICS - i.e. do you need to do a FREE in CICS to release the file. _________________ If it's true that we are here to help others,
then what exactly are the others here for ? |
|
Back to top |
|
|
anita_m Beginner
Joined: 20 Sep 2006 Posts: 41 Topics: 12 Location: Venus
|
Posted: Thu Apr 26, 2007 2:43 pm Post subject: |
|
|
The file is closed in CICS meaning it has been released by CICS. But still the file gives 'dataset in use' msg. Hence I guess someone has opened it in edit mode. |
|
Back to top |
|
|
ramlak Beginner
Joined: 17 Apr 2007 Posts: 27 Topics: 6
|
Posted: Wed May 02, 2007 9:10 am Post subject: |
|
|
anita_m wrote: | The file is closed in CICS meaning it has been released by CICS. |
As expat said i remeber doing "De-Allocate" process using a DADBI to update a file in batch. closing doesnt makes it free.
Thanks |
|
Back to top |
|
|
semigeezer Supermod
Joined: 03 Jan 2003 Posts: 1014 Topics: 13 Location: Atlantis
|
Posted: Wed May 02, 2007 4:48 pm Post subject: |
|
|
ISRDDN E (not C). Look for the SYSVSAM enques |
|
Back to top |
|
|
anita_m Beginner
Joined: 20 Sep 2006 Posts: 41 Topics: 12 Location: Venus
|
Posted: Wed May 09, 2007 4:26 pm Post subject: |
|
|
When I use the file in edit, my id gets diplayed under job name, but this doesnt happen when someone else opens it in edit.
Code: | . . . . . . . . . . . . . . . . . . . . . . . . . . .
System ENQ Status
Command ===> Scroll ===> PAGE
Scroll LEFT or RIGHT to see type or system name.
Major name prefix . . . SYSVSAM (SYSDSN, SPFEDIT, etc)
Minor name prefix . . . AAA.BBBBB.VSAM.FILE (dsn etc)
Address id prefix . . . (Job name, User id, etc)
System prefix . . . . . (System name)
Major Minor Job Name
|
|
|
Back to top |
|
|
NicolasF Beginner
Joined: 14 Mar 2007 Posts: 10 Topics: 3 Location: Argentina
|
Posted: Sat May 12, 2007 6:37 pm Post subject: |
|
|
If you are unable to run a job or use a data set from TSO because the data set is in use by another program, you can issue the following commands from the MVS console to determine which program (or user) has the data set allocated:
D GRS,RES=(SYSDSN,datasetname*) or,
D GRS,RES=(*,datasetname*) for example,
D GRS,RES=(SYSDSN,OGDEN.LIB.CNTL*)
You can use a full data set name, or only part of a data set name plus an asterisk. You can also use a full data set name plus the asterisk, although it may have no meaning in this case.
Do not try D GRS,RES=(*,*) unless you are on a small system with few users. This will generate a large amount of output on the operator console and there is no way to cancel the command |
|
Back to top |
|
|
|
|