-904 on package when not binding

Sibimon Philip

-904 on package when not binding
I think this may be a simple question for many DB2 gurus in the list. But I
cannot think of any reason

We getting -904 with following message in the production.

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90090, TYPE OF RESOURCE 00000801,
AND RESOURCE NAME MQ.PRGM1.165C0B9D115E6246
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEAAL SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -130 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF7E' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

Here MQ.PRGM1.165C0B9D115E6246 is the package and we are not
binding this but still the transaction is abending with -904. I looked at
the message for 00C90090 and it tells to wait for the bind to complete or
wait for the resource to be freed. Who can lock a programs package other
than when it is binding.

Any help on this would be appreciated.

thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]