IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

Production Abend in DB2

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
View previous topic :: View next topic  
Author Message
kumar1234



Joined: 06 Nov 2007
Posts: 62
Location: bangalore

Posted: Mon Aug 18, 2008 7:42 pm    Post subject: Production Abend in DB2  

Hi All,

I got an abend as SQLCODE -904 unavailable resource and Resource a table name xxx.

The table name mentioned is not used any where in the prog and this table is also not available. My friend suggested me to contact DBA and tell them to add spaces and then restart from the abend step.

Can anyone let me know will this be fine ?

Thanks.
Back to top  
dick scherrer



Joined: 23 Nov 2006
Posts: 8733
Location: 221 B Baker St

Posted: Mon Aug 18, 2008 9:00 pm    Post subject:  

Hello,

I suggest you talk with your dba. . .

"Things not used" should not cause a -904. Something appears to want to use it. . .

Your dba should be able to resolve this - then you can proceed.
Back to top  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM