|In Chapter 3, Using Query Administrator to Administer DB2 Query Patroller, |there are some new and changed descriptions for the data source parameters.
|Static Cost is the DB2 estimated cost of the query in timerons. This cost |is stored in the job entry for each job. You can see it as the Estimated Cost |when using Query Monitor to look at the job details of a job.
|Zero Cost Query is the query with a static cost, or estimated cost, of |zero. No query actually has an estimated cost of zero (even the very simplest |ones have a cost of around 5). Rather, this occurs if a job is submitted with |the do not do cost analysis option. You can only choose this option if you |have set up the user profile to allow it. In most cases, you will not have |your user profiles set up in this way. You should keep this option for superusers |like other administrators, selected special users, or yourself. These users can |then run whatever queries they want. The system treats queries from these |users as zero cost so that the queries are treated as high priority.
|Cost Time Zero, Cost Time Slope, Cost Time Interval, and Cost Time Min |are no longer used.
|The Cost Factor is the multiplier to convert the Static Cost in timerons |is not the cost in the accounting table. The cost in the accounting table |is equal to the Static Cost multiplied by the Cost Factor.