DB2 insert performance - How to measure
- by svrist
[From stackoverflow]
Im trying to find a way to speedup my inserts to a DB2 9.7.1 (ubuntu linux)
Im watching vmstat and trying to gather some statistics via the db2 get snapshot commands but im not able to figure out which numbers im looking for to be able to see where the trouble is.
I've read lits of stuff like…