Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Timerons - are the comparable across servers ?

Status
Not open for further replies.

JFK40

Programmer
Apr 30, 2003
5
IE
Are access plans and "timerons" comparable from one DB2 Server to another or are they dependent on the server they are run on. I am trying to compare access plans for the same piece of sql code run on two different servers each containing a copy of the same database and data. sane environment different physical servers.
 
Timerons are pretty much useless imho. If you want to performance a piece of sql, do this:-

1. Do a "runstats" on all the tables in the sql.

2. Run dynamic explain and look for:-

a) Table scans
b) Nested loop joins to tables with a lot of rows in them
c) Inefficient indexes e.g. where it's only using 1 of the index columns.

3. Once you've appropriately indexed the sql, if it's still a problem then start splitting down the sql and actually running each bit to find which section is causing you problems.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top