Prev: DBMS survey
Next: Need OLAP-type Ordering
From: AntiVirus DBA on 9 Dec 2009 17:35
On Nov 20, 5:52 pm, "The Boss" <use...(a)No.Spam.Please.invalid> wrote:
> AntiVirus DBA wrote:
> > I'm having a problem getting snapshots on my DB2 v8 FP 17a instance on
....
>
> I suspect DB2 isn't able to perform  the full snapshot due to lack of
> resources.
> Did you try switching on various subsets of the monitors and see what
> happens?

I'm thinking the same thing, but attempts to reproduce in an alternate
environment are unsuccessful. Switches to various subsets seem
successful. But I want it all!

> Also carefully check the diagnostics and notification logs.
>
> In any case I would open a PMR, "no error output" doesn't imply "no
> support".
> IBM will probably ask you to run the db2support command, which gathers all
> sorts of info not only on DB2 level but also on the OS.

That's good to know. Our diaglog has been archived but I will look
there the next time this happens. We did go through a project to
increase the number of spindles the data resides on because of I/O
wait. The system load has been greatly reduced and we haven't seen
the error again since then.
First  |  Prev  | 
Pages: 1 2
Prev: DBMS survey
Next: Need OLAP-type Ordering