Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
can you find out, which packages your program has?
if yes, make an EXPLAIN on those packages to find out,
if the db access path has best performance.
check also, whenever to make RUNSTATS on your
db2 objects, the packages take their best way on
accessing the data upon that statistical data.
if you are not able to do this, (because it is to technical
for you to interpret any EXPLAIN output), contact
your db2 dba, he is able to do this. (for he is dba...).