GET SNAPSHOT blows up monitor switches/returns incomplete data
in [DB2]
|
Prev: DBMS survey
Next: Need OLAP-type Ordering
From: AntiVirus DBA on 20 Nov 2009 18:06 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
From: The Boss on 20 Nov 2009 18:52 AntiVirus DBA wrote: > 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 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
From: Ian on 20 Nov 2009 18:52 AntiVirus DBA wrote: > 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. 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?
From: Ashok on 21 Nov 2009 05:38 try increasing the monito heap size .. On Nov 21, 4:52 am, Ian <ianb...(a)mobileaudio.com> wrote: > AntiVirus DBA wrote: > > 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. > > 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?
From: AntiVirus DBA on 9 Dec 2009 15:42
On Nov 20, 5:52 pm, Ian <ianb...(a)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 |