Below is the linux top output when running at full speed.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 2360 db2inst1 20 0 3463m 1.3g 1.1g S 7.4 35.3 4:45.93 db2sysc
I'm perfectly happy with the performance. I'm concerning what will happen when data grows?
I do not need much data, but now it is 1mill, I need to store max 30mill rows.
It will take me 14days to reach with the current simulation.
Will memory usage grow with growing tables, or is it just the indexes?
or is this autotuned DB2 internally? I have max 10connections active and I only see a
small fraction increase in cpu load, I've never been above 30%.
When memory usage(RES) reaches 2GB, will connection fails, or just slow down
using the disks more?, will insert fail, or may I get corrupt data?
Morten Bjoernsvik, Developer Evry CardServices AS, Oslo, Norway