79 reputation
1312
bio website
location
age
visits member for 1 year, 9 months
seen Oct 17 at 13:49

Oct
29
awarded  Famous Question
Oct
22
awarded  Popular Question
Oct
4
awarded  Notable Question
Sep
12
awarded  Popular Question
Jul
2
awarded  Curious
Feb
26
comment DB2 - How to estimate proper BUFFERPOOL size?
I marked this an answered I am only interested in your opinion if it should be ok if I extend this to 1.5 GB?
Feb
26
accepted DB2 - How to estimate proper BUFFERPOOL size?
Feb
26
comment db2 - after the reboot - database is restarting itself after some time (urgent help needed)
thank you it seems because of the cluster setup for the db it wasn't extended and on the other server
Feb
25
comment How to track IOPS statistics?
@Ian I am not so sure it is Delta p_reads/s column. Storage managers reported us that a few days ago average IOPS is over 5000 (previously it was 300 they said). Now database works just fine, but for your column I see figures between 1500 and 8000 but hitratio is over 90% so buffer pool is doing good job. I am not so convinced that this is statistics I need.. Maybe I am wrong... I just want to track those numbers which storage managers reported us because I do not want to this problem re-occur
Feb
25
comment DB2 - How to estimate proper BUFFERPOOL size?
robertsdb2blog.blogspot.com/2010/09/… I found here that " IF YOU HAVE BIG MEMORY, YOU SHOULD HAVE BIG DB2 BUFFER POOLS." I run Configuration Advisor and it gives me the value 32678 so it is 1 GB. My though is maybe I should increase it more (to 1.5 GB) What can be negative effect except I will have less memory on the server but currently I have 2,3 GB which are not used so I do not believe I will have some memory heap dump or similar.
Feb
25
revised db2 - after the reboot - database is restarting itself after some time (urgent help needed)
added 256 characters in body
Feb
25
asked db2 - after the reboot - database is restarting itself after some time (urgent help needed)
Feb
22
asked How to track IOPS statistics?
Feb
22
revised DB2 - How to estimate proper BUFFERPOOL size?
edited title
Feb
22
asked DB2 - How to estimate proper BUFFERPOOL size?
Feb
21
comment db2 performance issue - large number of IOPS how to determine problem?
can I somehow using db2top find query which were problematics today before 10 hours? is it possible now?
Feb
21
comment db2 performance issue - large number of IOPS how to determine problem?
index was not dropped...CPU today also today was at high value... from this time persepctive (problem happened at 12 P.M.) what is the easiest way to find long running query which maybe caused the problem? I do not know for that feature..what will be the easiest way to find that problematic query... thank you in advance for helping
Feb
21
comment db2 performance issue - large number of IOPS how to determine problem?
thank you very much for reply this is prod db so it is really important. db is 30GB. It has 8GB RAM is it too small? 24 processors 1.5 GB. is it ok what do you think? select bpname, npages*pagesize as size_bytes from syscat.bufferpools returns 536 MB.. should it be increased? numbe rof pages or pagesize?
Feb
21
awarded  Custodian
Feb
21
reviewed Approve suggested edit on db2 performance issue - large number of IOPS how to determine problem?