473,327 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

collect bufferpool data

i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?
Nov 12 '05 #1
12 3225
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?


Did you turn on the snapshot monitor for bufferpools?
Nov 12 '05 #2
"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?


Did you turn on the snapshot monitor for bufferpools?
Nov 12 '05 #3
On command line:
db2 update monitor switches bufferpool on
db2 get snapshot on.....

I would suggest you spend some time reading the DB2 Admin Guide -
Performance.
A lot of the questions you have been asking lately are quite extensively
discussed in there and you would save yourself time as well as gain a
better understanding of what your database is telling you.

HTH' Pierre.

xixi wrote:
i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #4
On command line:
db2 update monitor switches bufferpool on
db2 get snapshot on.....

I would suggest you spend some time reading the DB2 Admin Guide -
Performance.
A lot of the questions you have been asking lately are quite extensively
discussed in there and you would save yourself time as well as gain a
better understanding of what your database is telling you.

HTH' Pierre.

xixi wrote:
i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data?


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #5
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:40**************@attglobal.net...
On command line:
db2 update monitor switches bufferpool on
db2 get snapshot on.....

I would suggest you spend some time reading the DB2 Admin Guide -
Performance.
A lot of the questions you have been asking lately are quite extensively
discussed in there and you would save yourself time as well as gain a
better understanding of what your database is telling you.

HTH' Pierre.

As long as you answer the questions for him, why should he RTFM?
Nov 12 '05 #6
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:40**************@attglobal.net...
On command line:
db2 update monitor switches bufferpool on
db2 get snapshot on.....

I would suggest you spend some time reading the DB2 Admin Guide -
Performance.
A lot of the questions you have been asking lately are quite extensively
discussed in there and you would save yourself time as well as gain a
better understanding of what your database is telling you.

HTH' Pierre.

As long as you answer the questions for him, why should he RTFM?
Nov 12 '05 #7
I've always thought that this is a place to get help.

One help hint is to steer people to do some reading but not necessarily
leave them in the dark as well.

We all need help here!!!!
Pierre.

Mark A wrote:
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:40**************@attglobal.net...
On command line:
db2 update monitor switches bufferpool on
db2 get snapshot on.....

I would suggest you spend some time reading the DB2 Admin Guide -
Performance.
A lot of the questions you have been asking lately are quite extensively
discussed in there and you would save yourself time as well as gain a
better understanding of what your database is telling you.

HTH' Pierre.


As long as you answer the questions for him, why should he RTFM?


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #8
I've always thought that this is a place to get help.

One help hint is to steer people to do some reading but not necessarily
leave them in the dark as well.

We all need help here!!!!
Pierre.

Mark A wrote:
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:40**************@attglobal.net...
On command line:
db2 update monitor switches bufferpool on
db2 get snapshot on.....

I would suggest you spend some time reading the DB2 Admin Guide -
Performance.
A lot of the questions you have been asking lately are quite extensively
discussed in there and you would save yourself time as well as gain a
better understanding of what your database is telling you.

HTH' Pierre.


As long as you answer the questions for him, why should he RTFM?


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #9
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:40**************@attglobal.net...
I've always thought that this is a place to get help.

One help hint is to steer people to do some reading but not necessarily
leave them in the dark as well.

We all need help here!!!!
Pierre.

I previously told him in this thread to turn on the buffer pool monitor
switch, without giving the actual syntax, hoping that he would look it up in
the manual. For most posters, this is not an issue, but sometimes it gets
out of hand.
Nov 12 '05 #10
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:40**************@attglobal.net...
I've always thought that this is a place to get help.

One help hint is to steer people to do some reading but not necessarily
leave them in the dark as well.

We all need help here!!!!
Pierre.

I previously told him in this thread to turn on the buffer pool monitor
switch, without giving the actual syntax, hoping that he would look it up in
the manual. For most posters, this is not an issue, but sometimes it gets
out of hand.
Nov 12 '05 #11
Mark, I'm starting to agree with you after the volume of questions where
the answers were in the manuals.
Regards, Pierre.

Mark A wrote:
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:40**************@attglobal.net...
I've always thought that this is a place to get help.

One help hint is to steer people to do some reading but not necessarily
leave them in the dark as well.

We all need help here!!!!
Pierre.


I previously told him in this thread to turn on the buffer pool monitor
switch, without giving the actual syntax, hoping that he would look it up in
the manual. For most posters, this is not an issue, but sometimes it gets
out of hand.


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #12
Mark, I'm starting to agree with you after the volume of questions where
the answers were in the manuals.
Regards, Pierre.

Mark A wrote:
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:40**************@attglobal.net...
I've always thought that this is a place to get help.

One help hint is to steer people to do some reading but not necessarily
leave them in the dark as well.

We all need help here!!!!
Pierre.


I previously told him in this thread to turn on the buffer pool monitor
switch, without giving the actual syntax, hoping that he would look it up in
the manual. For most posters, this is not an issue, but sometimes it gets
out of hand.


--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #13

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jagdip Singh | last post by:
Hi all, Is there any recommended bufferpool size while designing database I mean some equation which governs bufferpool size regards, Jagdip
5
by: Paul Shaw | last post by:
Can anyone explain why an insert might cause multiple logical bufferpool data reads? Here's a situation that has me scratching my head. Table A's data resides in tablespace B Table A's...
4
by: Yoyoma | last post by:
Hello, I have a client running db2 udb 7.2 workgroup , FP10a on a Windows 200 server with 4GB of memory. The database is 25GB big, but from that maybe 50% is current data. My issue is that we...
0
by: xixi | last post by:
i am trying to get snapshot for buffpool, but all i get is "not collected", is there anyway i can collect the data?
5
by: Hemant Shah | last post by:
Folks, I am not sure what I am doing wrong, but We have an transaction that does some serious calculation on small chink of data over and over again. It selects few rows from the table...
3
by: Damir Wilder | last post by:
Hello, can someone tell me what exactly the value "Direct reads" means (i.e. how is it calculated), when analysing the bufferpool snapshot? What I do know is that it shows the number of reads that...
5
by: db2admin | last post by:
hello, admin guide says that pool_data_p_reads - pool_async_data_reads will give me number of physical reads that were performed synchronously (that is, physical data page reads that were...
3
by: dunleav1 | last post by:
In 9.1 and 9.5 (Linux 64 bit) when a buffer pool is set to self- tuning, how are blocks configured in respect to blocked vs non-blocked when self-tuning is set to on? (ie) I have one bufferpool...
0
by: dot.yet | last post by:
Hi Everyone, environment: DB2 9.5 WSE with FP 2a Solaris 10 u5 - 64-bit SMP - 2 Quad CPUS - total 8 cores 16 GB RAM SAMPLE database Solaris Containers
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.