#1: VSAM Status code 90 Author: Smith, Posted: Tue Sep 06, 2005 12:54 pm 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?
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.
#3: Author: Smith, Posted: Tue Sep 06, 2005 1:54 pm 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
#4: Author: Smith, Posted: Tue Sep 06, 2005 1:57 pm 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
#5: Author: vkphani, Posted: Wed Sep 28, 2005 12:50 am Is it possible to get the File status code 90 even if VSAM file is not used in the program.
#6: Author: Phantom, Location: The Blue PlanetPosted: Wed Sep 28, 2005 1:21 am 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
#7: Author: vkphani, Posted: Wed Sep 28, 2005 1:27 am Thanks for the info Phantom.