-904 on package when not binding - reply

[login to unmask email]

-904 on package when not binding - reply
You might wan't to check to see if other packages were getting
bound into the same collection (MQ). Chances are your package
was not in the EDM pool, and another package was being bound
into the collection you are using.

-Rob
---------------------- Forwarded by Rob Crane/Pti on 10/07/99 04:55 PM
---------------------------


"Philip, Sibimon" <[login to unmask email]> on 10/07/99 04:46:08 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc:
Subject: -904 on package when not binding




Note: Some recipients have been dropped due to syntax errors.
Please refer to the "$AdditionalHeaders" item for the complete headers.



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]

Sibimon Philip

Re: -904 on package when not binding - reply
(in response to rob.crane@PLATINUM.COM)
We were getting the -904 at 13.36 today, the only program we bound was at
14.46. I also checked the DB2 log and it does not show me anything unusual.
Can we execute a program without having the package or plan in the EDM pool?
This program runs 24 hours.

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

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, October 07, 1999 4:55 PM
To: [login to unmask email]
Subject: -904 on package when not binding - reply


You might wan't to check to see if other packages were getting
bound into the same collection (MQ). Chances are your package
was not in the EDM pool, and another package was being bound
into the collection you are using.

-Rob
---------------------- Forwarded by Rob Crane/Pti on 10/07/99 04:55 PM
---------------------------


"Philip, Sibimon" <[login to unmask email]> on 10/07/99 04:46:08 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc:
Subject: -904 on package when not binding




Note: Some recipients have been dropped due to syntax errors.
Please refer to the "$AdditionalHeaders" item for the complete headers.



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]

James Campbell

Re: -904 on package when not binding
(in response to Sibimon Philip)
Sibimon

Check your DB2's MSTR JES Message log. There should be a DSNT376I
message which tells you who else has a lock on the package.

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Tooronga
+61 3 9261 1802
[login to unmask email]
-----Original Message-----
From: Philip, Sibimon [mailto:[login to unmask email]
Sent: Friday, October 08, 1999 7:46 AM
To: [login to unmask email]
Subject: -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]

[login to unmask email]

Re: -904 on package when not binding - reply
(in response to James Campbell)
The SKPT(skeleton package tables) and PT(package tables (copies of SKPT))
reside
in the EDM pool. Using packages typically helps EDM Pool storage management
by
decreasing the size of the objects in the EDM pool. (Smaller package DBRMs vs
one large
plan DBRM). Try and monitor the I/0 activity in the directory (DSNDB01)
increased
I/) to the directory could imply to small of EDM pool. Based on your -904,
I doubt
this is an EDM pool problem.


To try and isolate what is occurring at your shop here are a few ideas.

1) Sounds like this is a CICS and possibly a MQ transaction. Make sure if
this package is
only used in CICS to only ENABLE(CICS).

2) You could move the packages needed by this application to a new collection
which might
help you isolate the real problem, or track it better if you don't own
any automated
tracking software.

3) Double check the MSTR for messages.

4) Are remote packages being used, or DDF.

5) Make sure the proper SQLCA is being filled in. I have seen times when
program
storage overlay has caused problems in masking the true error.
Make sure it is really getting the -904.

-Rob
---------------------- Forwarded by Rob Crane/Pti on 10/08/99 10:11 AM
---------------------------


"Philip, Sibimon" <[login to unmask email]> on 10/07/99 05:13:19 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc:
Subject: Re: -904 on package when not binding - reply




Note: Some recipients have been dropped due to syntax errors.
Please refer to the "$AdditionalHeaders" item for the complete headers.



We were getting the -904 at 13.36 today, the only program we bound was at
14.46. I also checked the DB2 log and it does not show me anything unusual.
Can we execute a program without having the package or plan in the EDM pool?
This program runs 24 hours.

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

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, October 07, 1999 4:55 PM
To: [login to unmask email]
Subject: -904 on package when not binding - reply


You might wan't to check to see if other packages were getting
bound into the same collection (MQ). Chances are your package
was not in the EDM pool, and another package was being bound
into the collection you are using.

-Rob
---------------------- Forwarded by Rob Crane/Pti on 10/07/99 04:55 PM
---------------------------


"Philip, Sibimon" <[login to unmask email]> on 10/07/99 04:46:08 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc:
Subject: -904 on package when not binding




Note: Some recipients have been dropped due to syntax errors.
Please refer to the "$AdditionalHeaders" item for the complete headers.



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]