how to resolve -904

In this Mainframe Forum - You can post your queries on JCL,VSAM,COBOL,DB2,IMS Abend codes , solutions etc..

Moderator: Moderator Group

Post Reply
naveenes
Member
Posts: 3
Joined: Fri Nov 16, 2007 11:05 am

how to resolve -904

Post by naveenes » Thu Nov 29, 2007 5:14 pm

hi,

Can any one let me know how to resolve -904 error.

Thanks and Regards,
Naveen E S

mkk157
Member
Posts: 37
Joined: Wed Feb 07, 2007 2:00 pm
Location: Hyderabad

Post by mkk157 » Tue Dec 04, 2007 9:20 am

-904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE.

The SQL statement could not be executed because 'resource name' of type 'resource-type' was not available at the time for the reason indicated by 'reason-code'.

Can you post all the reason-codes and reason-type. So that it is easy to point-out the problem.

Generally, this error code will occur, when a table which is used in your query is locked by some other team member, U can run this successfully once lock was released on the table.

To know the userid of the person who has locked this particular table, contact ur DBA. He will run few DB2 commands and then he will let u know the userid and make the table ready for ur use.
Kumar
If u can dream it, U can do it.

academyindia4

Topic deleted by Admin

Post by academyindia4 » Thu Jan 21, 2016 11:19 am

<< Content deleted By Admin >>

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others