i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data? 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?
"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?
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.
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.
"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" <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?
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.
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.
"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" <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.
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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
|
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...
|
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...
|
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?
|
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...
|
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...
|
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...
|
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...
|
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
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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....
|
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...
| |