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 

VSAM Status code 90

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


Joined: 07 Apr 2005
Posts: 13
Topics: 5

PostPosted: Tue Sep 06, 2005 12:54 pm    Post subject: VSAM Status code 90 Reply with quote

Hi,
I am trying to read a VSAM file, and I am getting a File Status 90 in my COBOL program. I thought it is some logical error, but when i restarted the job I got a file status of 90 in another key (not the same key as before). It successfully passed the read for the key for which it abended before. Could anyone help?

Thanks,
Smith
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Tue Sep 06, 2005 1:31 pm    Post subject: Reply with quote

Smith,

Are you running your programs as a multithreaded application ? If you open a QSAM/VSAM file in a multithreaded application, you must close it from the same thread of execution from which the file was opened. Attempting to close the file from a different thread results in a close failure with file-status condition 90.

If that is the case then check this link which explains in detail about closing and opening files in such environements.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IGY3PG10/4.4?DT=20020923143836

Also is there a REWRITE involved?

Hope this helps...

Cheers

kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Smith
Beginner


Joined: 07 Apr 2005
Posts: 13
Topics: 5

PostPosted: Tue Sep 06, 2005 1:54 pm    Post subject: Reply with quote

Kolusu,
Thanks for your prompt reply. For your questions:

1) We are not running programs as multithreaded application
2) Yes we are Rewriting the record in certain conditions

Also we are using BLSR option in our JCL to increase the performance.

Thanks,
Smith
Back to top
View user's profile Send private message
Smith
Beginner


Joined: 07 Apr 2005
Posts: 13
Topics: 5

PostPosted: Tue Sep 06, 2005 1:57 pm    Post subject: Reply with quote

Kolusu,
Forgot to add that, the SYSOUT says it is abending on READ giving file status 90. We are reading the file using an alternate index (actually Start ..Read Next command) and it is here where it abends with 90 status code

Thanks,
Smith
Back to top
View user's profile Send private message
vkphani
Intermediate


Joined: 05 Sep 2003
Posts: 483
Topics: 48

PostPosted: Wed Sep 28, 2005 12:50 am    Post subject: Reply with quote

Is it possible to get the File status code 90 even if VSAM file is not used in the program.
Back to top
View user's profile Send private message Send e-mail
Phantom
Data Mgmt Moderator
Data Mgmt Moderator


Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet

PostPosted: Wed Sep 28, 2005 1:21 am    Post subject: Reply with quote

vkphani,

Quote:

Is it possible to get the File status code 90 even if VSAM file is not used in the program.


Nope !. The file status gets updated only when you make any I/O operations over the file (Open / Read / Close / rewrite / write). When you don't use the VSAM file in the program, the only operation that takes place is the JCL DD allocation. Depending on whether the VSAM is held up by other jobs, your job might end up in Contention but not in File Status 90.

Thanks,
Phantom
Back to top
View user's profile Send private message
vkphani
Intermediate


Joined: 05 Sep 2003
Posts: 483
Topics: 48

PostPosted: Wed Sep 28, 2005 1:27 am    Post subject: Reply with quote

Thanks for the info Phantom.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management 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