Error code 65 while opening the URT for a datacom

Jatin saraf · Posted: Sat Sep 15, 2007 12:14 am

Hi,

I am getting an error code of 65 while opening the URT for a datacom table. Does anybody know the resolution for this?I tried running the report for this URT and have made sure that all the tables for this URT are loaded.

Thanks,
Jatin

dick scherrer · Posted: Sat Sep 15, 2007 1:01 am

Hello,

What were you running at the time of the abend?

What is the internal return code? There are multiple possibilities for a 65.

If you post your jcl and any diagnostic output from the JES sysouts, that may also help.

Jatin saraf · Posted: Sat Sep 15, 2007 1:07 am

I was running a program that accesses datacom tables. The spool message was:-
DB00501E - OPEN ERROR - RETURN CODE 65 (065) CXX=TESTCXX (SUP585 ) SUBID=0 SVC=255

SUP is one of the tables being used in the program and 585 is its DBID.
As of now I could solve the problem by using a different DBID and the program has ran fine. But still not able to understand the reason for this return code. Please help.
The JCL is:-
//HNTU099A JOB (9072,0000),CREDIT.CARD,MSGCLASS=R,CLASS=T,
// USER=HNTU099,NOTIFY=HNTU099,
// TIME=1439,
// PASSWORD=
//*INCLUDE MEMBER=TEJOBLIB
//*
//JOBLIB DD DSN=USER.PROGLIB,DISP=SHR
// DD DSN=VCDC.SUBRLIB,DISP=SHR
// DD DSN=VCDC.PROGLIB,DISP=SHR
// INCLUDE MEMBER=DBT01LIB
// DD DSN=VCDC.ADR.REORG.LOADLIB,DISP=SHR
// DD DSN=VCDC.DB2T.SDSNEXIT,DISP=SHR
// DD DSN=VCDC.DB2T.SDSNLOAD,DISP=SHR
//TTIN075 EXEC PGM=JSIN075T,REGION=52M
//URT DD DSN=USER.PROGLIB(JSIN075U),DISP=SHR
//IFILE01 DD DSN=DEV.TTIN.P.TRN08801, STR REQUEST FILE
// DISP=SHR
//OFILE01 DD DSN=DEV.TTIN.P.TRN07501(+1), SUPPLY DWNLD
// DISP=(,CATLG,DELETE), (250,000 RECS)
// UNIT=DISK,
// DCB=Z.FB0100,
// SPACE=(100,(500,50),RLSE),AVGREC=K
//SYSOUT DD SYSOUT=*
//*

dick scherrer · Posted: Sat Sep 15, 2007 1:16 am

Hello,

Are you permitted to run a CXX report for dbid 585? Having one handy might help.

Are your areas dynamically allocated or are there DD statements in the Multi-User JCL?

The internal return code of 65 says there is a DD statement missing or the dataset name that the CXX knows about does not exist - which is probably why when you use a different dbid your job runs successfully.

You might want to talk with your DBAs and confirm that dbid 585 is not "down" for some reason.

Jatin saraf · Posted: Sat Sep 15, 2007 1:46 am

Yeah, I did run the CXX report and confirmed that all the tables with the DBID 585 are loaded. And all areas are dynamically allocated, so no question of any DD statement missing.
As you suggest, I will go ahead and talk to the DBAs here. Thanks

dick scherrer · Posted: Sat Sep 15, 2007 2:23 am

Hello,

Even though the CXX says the area is loaded, someone may have deleted the physical area. Datacom would not know that something external had deleted the dataset.

The same internal retyrn code is reaised for both the missing dd and the non-existent dataset.

Let me know if you find more info and have any questions.