MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to find the user who is editing a VSAM File?

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
anita_m
Beginner


Joined: 20 Sep 2006
Posts: 41
Topics: 12
Location: Venus

PostPosted: Wed Apr 18, 2007 3:58 pm    Post subject: How to find the user who is editing a VSAM File? Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Wed Apr 18, 2007 5:13 pm    Post subject: Reply with quote

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
View user's profile Send private message
anita_m
Beginner


Joined: 20 Sep 2006
Posts: 41
Topics: 12
Location: Venus

PostPosted: Wed Apr 18, 2007 5:44 pm    Post subject: Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Wed Apr 18, 2007 8:06 pm    Post subject: Reply with quote

Sorry, try PF1 twice...
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
semigeezer
Supermod


Joined: 03 Jan 2003
Posts: 1014
Topics: 13
Location: Atlantis

PostPosted: Thu Apr 19, 2007 10:24 am    Post subject: Reply with quote

or TSO ISRDDN C
Back to top
View user's profile Send private message Visit poster's website
anita_m
Beginner


Joined: 20 Sep 2006
Posts: 41
Topics: 12
Location: Venus

PostPosted: Thu Apr 19, 2007 11:53 am    Post subject: Reply with quote

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
View user's profile Send private message
expat
Intermediate


Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales

PostPosted: Fri Apr 20, 2007 1:55 am    Post subject: Reply with quote

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
View user's profile Send private message
anita_m
Beginner


Joined: 20 Sep 2006
Posts: 41
Topics: 12
Location: Venus

PostPosted: Thu Apr 26, 2007 2:43 pm    Post subject: Reply with quote

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
View user's profile Send private message
ramlak
Beginner


Joined: 17 Apr 2007
Posts: 27
Topics: 6

PostPosted: Wed May 02, 2007 9:10 am    Post subject: Reply with quote

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
View user's profile Send private message
semigeezer
Supermod


Joined: 03 Jan 2003
Posts: 1014
Topics: 13
Location: Atlantis

PostPosted: Wed May 02, 2007 4:48 pm    Post subject: Reply with quote

ISRDDN E (not C). Look for the SYSVSAM enques
Back to top
View user's profile Send private message Visit poster's website
anita_m
Beginner


Joined: 20 Sep 2006
Posts: 41
Topics: 12
Location: Venus

PostPosted: Wed May 09, 2007 4:26 pm    Post subject: Reply with quote

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
View user's profile Send private message
NicolasF
Beginner


Joined: 14 Mar 2007
Posts: 10
Topics: 3
Location: Argentina

PostPosted: Sat May 12, 2007 6:37 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group