Joined: 01 Jul 2003 Posts: 15 Location: Phoenix , AZ
Hi Lord of Wind,
First of all, I want to tell you that -904 can be for many reasons , be it if the resource is in restrictive state , or some problems with underlying physical VSAM LDS. So , please post the complete error message.
But to troubleshoot , with the -904 message, a resource code would be specified , which can be looked upon in Db2 error messages reference manual. Also , you would be specified of the db2 object , which is causing you the problem . So you can analyse more on the object , to find out why is -904 occuring.
More than all these , you can also search at MSTR spool , to see what is restricting you to use the resource , which may be very handy to trouble shoot these kind of situations.