View previous topic :: View next topic
|
Author |
Message |
Jatin saraf
New User
Joined: 30 Mar 2007 Posts: 22 Location: United States of america
|
|
|
|
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 |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. |
|
Back to top |
|
|
Jatin saraf
New User
Joined: 30 Mar 2007 Posts: 22 Location: United States of america
|
|
|
|
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=*
//* |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. |
|
Back to top |
|
|
Jatin saraf
New User
Joined: 30 Mar 2007 Posts: 22 Location: United States of america
|
|
|
|
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 |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. |
|
Back to top |
|
|
|