GET SNAPSHOT blows up monitor switches/returns incomplete data

AntiVirus DBA

unread,

Nov 20, 2009, 6:06:21 PM11/20/09

to amy_...@mcafee.com

I'm having a problem getting snapshots on my DB2 v8 FP 17a instance on
AIX. Here's my procedure:

1) Set all the montior switches for my user session
2) Run db2 "get snapshot for all on MYDB"

One of two things will happen next:
1) My db connection will be forced off and the snapshot will not be
returned
2) One of the monitor switches will get turned off ( i.e. the
bufferpool switch) and no data returned for that group.

Has anyone else encountered this or have any idea what might be
causing it? Not sure I can submit this to DB2 support since there is
no error output. I've already scoured this newsgroup for hours
looking for something similar with no luck.

Thanks in advance for your replies.
AntiVirus DBA

The Boss

unread,

Nov 20, 2009, 6:52:38 PM11/20/09

to

A virus perhaps? ;-)
(sorry, couldn't resist)

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?
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.

HTH.

--
Jeroen

Ian

unread,

Nov 20, 2009, 6:52:57 PM11/20/09

to

I'm sure you know that V8 is out of support since early this year.

Do you get anything in db2diag.log? What if you set DIAGLEVEL = 4?

Ashok

unread,

Nov 21, 2009, 5:38:50 AM11/21/09

to

try increasing the monito heap size ..

AntiVirus DBA

unread,

Dec 9, 2009, 3:42:25 PM12/9/09

to

On Nov 20, 5:52 pm, Ian <ianb...@mobileaudio.com> wrote:

>
> I'm sure you know that V8 is out of support since early this year.
>

Yep, we're in the process of moving off. Trying to get snapshot
statistics in order to plan for the new v9 environment.

--AV DBA

AntiVirus DBA

unread,

Dec 9, 2009, 5:35:21 PM12/9/09

to

On Nov 20, 5:52 pm, "The Boss" <use...@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.