Unavailable Resource

Mike O'Brien

Unavailable Resource
Anyone run into a problem where you get a unavailable
resource accessing a stopped object in SPUFI, but the
associated DSNT501I message does not appear on the
console log. The object is in a Peoplesoft application.
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com



Mike O'Brien

Re: Unavailable Resource
(in response to James Campbell)
James, thanks for the info. That seems to answer the
question.
--- Campbell James <[login to unmask email]>
wrote:
> Mike,
>
> My experience is that I don't get a DSNT501I message
> for a stopped
> database/tablespace. Presumably because DB2 thinks
> that there is enough
> information in the SQLCA is recitify the problem.
> (Unfortunately, some
> applications just report the -904 and don't report
> the message tokens.)
>
> It's only when there isn't enough information in the
> SQLCA to fix a -904
> etc that I expect a console message.
>
> You may notice that the message&codes only has
> "and/or message DSNT500I
> or message DSNT501I is issued" - which includes
> _not_ producing the
> messages!
>
> /* standard disclaimer */
> James Campbell
> DBA
> Hansen Corporation, Doncaster
> +61 3 9840 3864
> [login to unmask email]
> -----Original Message-----
> From: Mike O'Brien
> [mailto:[login to unmask email]
> Sent: Saturday, January 08, 2000 1:08 AM
> To: [login to unmask email]
> Subject: Unavailable Resource
>
>
> Anyone run into a problem where you get a
> unavailable
> resource accessing a stopped object in SPUFI, but
> the
> associated DSNT501I message does not appear on the
> console log. The object is in a Peoplesoft
> application.
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
>
>
> To change your subscription options or to cancel
> your subscription visit
> the DB2-L webpage at http://www.ryci.com/db2-l. The
> owners of the list
> can
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can
>

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com



James Campbell

Re: Unavailable Resource
(in response to Mike O'Brien)
Mike,

My experience is that I don't get a DSNT501I message for a stopped
database/tablespace. Presumably because DB2 thinks that there is enough
information in the SQLCA is recitify the problem. (Unfortunately, some
applications just report the -904 and don't report the message tokens.)

It's only when there isn't enough information in the SQLCA to fix a -904
etc that I expect a console message.

You may notice that the message&codes only has "and/or message DSNT500I
or message DSNT501I is issued" - which includes _not_ producing the
messages!

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9840 3864
[login to unmask email]
-----Original Message-----
From: Mike O'Brien [mailto:[login to unmask email]
Sent: Saturday, January 08, 2000 1:08 AM
To: [login to unmask email]
Subject: Unavailable Resource


Anyone run into a problem where you get a unavailable
resource accessing a stopped object in SPUFI, but the
associated DSNT501I message does not appear on the
console log. The object is in a Peoplesoft application.
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com



the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can