79 reputation
210
bio website
location
age
visits member for 1 year, 6 months
seen Jun 19 at 20:38

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 DB2 - 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 DB2 - 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?
Feb
21
asked db2 performance issue - large number of IOPS how to determine problem?
Feb
20
comment Why db2data folder changes its size (increasing and decreasing )?
I listed it with db2 get snapshot table spaces and found which are temporary
Feb
20
accepted Why db2data folder changes its size (increasing and decreasing )?
Feb
20
comment Why db2data folder changes its size (increasing and decreasing )?
Hello thank you for information. Is this regular behavior that only one table space has 25 GB while others are small?: [ctginst1@tt-db-02 MAXDB71]$ du -skh * 225M T0000000 12K T0000001 289M T0000002 33M T0000003 25G T0000004 18M T0000005 12K T0000006