If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Significance of accurate TRANSFERRATE and OVERHEAD in Tablespace Definition

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-11-04, 10:26
rubystep rubystep is offline
Registered User
 
Join Date: Sep 2003
Posts: 85
Significance of accurate TRANSFERRATE and OVERHEAD in Tablespace Definition

For the DB2 Engine/Optimizer to determine the best path, how important is it to the code to have accurate tablespace transferrate and overhead numbers?

The reason that I ask is that we have 3 environments: an SP2 with 11 servers (and 20 database partitions) and 2 p630 each with 5 servers (and 8 database partitions). I am also well aware that the SP2 has more internal disks and that we're underwhelmed in the p630 environments from the disk farms.

The SP2 seems to beat the p630 environments hands-down when a query is heavily IO bound.
I jsut notiiced that the tablespace definitions on the p630's have the same transferrate and overhead values as the SP2 (which probably is incorrect for the p630's).

So, aside from the fact that the SP2 has more disks, how significant is it that we probably have wrong values for the 2 paramters mentioned?

We definitely have larger memory on the p630's than the SP2 servers.
Reply With Quote
  #2 (permalink)  
Old 08-12-04, 06:48
vidyaraok vidyaraok is offline
Registered User
 
Join Date: Aug 2004
Posts: 15
when indexs and tables are placed on different tablespaces(physically diff. drives) , optimzer uses device characersics to calcuate the cost of table scan and index scan.whichever faster will be chosen.
db2 automatically doesnt detetct these characteristics, some default values are assigned for all containers.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On