i am trying to get snapshot for buffpool, but all i get is "not
collected", is there anyway i can collect the data? 12 3235
"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: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |