MVSFORUMS.com

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

I am facing the performance problem In DB2 , actually prev we wew using DB2 version 5 now we have upgrded the verison to Db2 version 7
Now some of the queiries taking long time to run after the upgradtion
pls gimme some idea what the piont we need to check for the performance related things

Thanks
Cool

bauer · Posted: Tue Nov 21, 2006 6:30 am Post subject:

coolguy,

- check statistic data in db2 catalog. Are statistic data up to date ?
- Rebind / Bind activitys ?
- Do an explain
- Are the data befor upgrading really the same ? Other table cardinality ?

bauer

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

I did all the things and Runstats also , i am pretty sure the data's are same,
While using explain it is going for the tablespace scan ,

how to change the things can u help me

Thanks
Cool

bauer · Posted: Tue Nov 21, 2006 7:39 am Post subject:

coolguy,

well, why table space scan, this is very poor (for large tables).

I would recommend to create an index if the table space scan is the bottle neck.

bauer

rubenprakash · Posted: Tue Nov 21, 2006 11:47 am Post subject:

bauer · Posted: Wed Nov 22, 2006 1:37 am Post subject:

coolguy,

other remark: What about reorg ? Are we talking about clusterd index?