Getting 93 error RESOURCE NOT AVAILABLE

anandinmainframe · New User Joined: 31 May 2007 Posts: 28 Location: chennai

Hi,
I am trying to retrieve bunch of data and i am getting 93 error ('VSAM - VIRTSTOR. RESOURCE NOT AVAILABLE')whereas the cluster i am using is capable of holding several thousands of records.

dick scherrer · Posted: Mon Jun 23, 2008 11:33 am Post subject:

Hello,

Is this happening online or in batch?

Is this happening on a read or an open?

anandinmainframe · New User Joined: 31 May 2007 Posts: 28 Location: chennai

This is happening in Batch
its happening during open

dick scherrer · Posted: Mon Jun 23, 2008 11:50 am Post subject:

Hello,

Check your SELECT and the DD statements in the jcl and make sure they are correct.

It may help if you post the SELECT and the JCL for the step.

anandinmainframe · New User Joined: 31 May 2007 Posts: 28 Location: chennai

i am selecting the fields through a cursor and it will be like decalre,open,fetch & close.
Select
Eg :
Select field1,field2,field3 from tablename
where condn
end-exec.

JCL is
//XXXXXXFI JOB (P,456R),'ANAND',CLASS=O,MSGCLASS=Y,REGION=30M,
// NOTIFY=&SYSUID,SCHENV=PRC1
//**************************************************************
//JOBLIB DD DSN=DB2P.SDSNLOAD,DISP=SHR
// DD DSN=DB2P.SDSNEXIT,DISP=SHR
// DD DSN=TESTREGION.LINKLIB,DISP=SHR
// DD DSN=PRODN.LINKLIB,DISP=SHR
// DD DSN=SYS5.PROD.LINKLIB,DISP=SHR
// DD DSN=SYS5.PROD.MLBS.LINKLIB,DISP=SHR
// DD DSN=SYSTEMS.LINKLIB,DISP=SHR
//***********************************************************
//I4XQTI01 EXEC PGM=IKJEFT01,DYNAMNBR=50
//***********************************************************
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSABOUT DD SYSOUT=*
//SYSOUX DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//JLKXX DD SYSOUT=*
//OPFILE1 DD DSN=FILE1.DATA(+1),
// DISP=(NEW,CATLG,DELETE),
// RECFM=FB,LRECL=100,
//CL1 DD DSN=XXXXXX.SDT.CL,DISP=SHR (cluster i am talking abt)
//DATEF DD DSN=XXXXXX..DATA,DISP=SHR (date file)
//SYSTSIN DD DSN=XXXXXX.CONTROL(I4XQTI),DISP=SHR(control file)

Craq Giegerich · Posted: Mon Jun 23, 2008 4:58 pm Post subject:

You are using an SQL cursor and SELECT to get data from a VSAM file?

Robert Sample · Posted: Mon Jun 23, 2008 5:06 pm Post subject:

Resource not available probably means your COBOL statement
SELECT WHATEVER ASSIGN TO CL1 doesn't use CL1 for the DD name. It has nothing to do with the SQL SELECT statement.

anandinmainframe · New User Joined: 31 May 2007 Posts: 28 Location: chennai

Hi All,
Thanks for the support the issue has been resolved
thank you all once again for your support

Bill O'Boyle

If the Batch program is opening the target file for other than INPUT and the file is Open/Enabled to CICS, you'll get a status "93".

Bill

dick scherrer · Posted: Mon Jun 23, 2008 11:20 pm Post subject:

Hello,