Page 1 of 1

how to resolve -904

Posted: Thu Nov 29, 2007 5:14 pm
by naveenes
hi,

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

Thanks and Regards,
Naveen E S

Posted: Tue Dec 04, 2007 9:20 am
by mkk157
-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.

Topic deleted by Admin

Posted: Thu Jan 21, 2016 11:19 am
by academyindia4
<< Content deleted By Admin >>