Your dba prob fibbing. Most rdbms have throttle facility - I know Oracle does. Have a look at the docs for db2.

Having had a long experience with dba s I know what they are like! They are the God user so they think they should act like God!

8 queries that take over 3 minutes each to run?

There's some great technology that DB2 has that other databases do not, for example their query plan tool is the best I've seen. Your DBA should be your goto on query planning and optimization, but you should have very very few queries that clock in over a minute. It's just a matter of proper indexing and usage of IBM's materialized query tables to facilitate better performance.

The IBM p-series is a solid platform with AIX, but I've seen some fairly old hardware running in production before. You may want to ask your DBA or systems engineers about the hardware itself before tuning your queries.

Feel free to contact me via personal message if you'd like to know more about query optimization or DB2 in general.

Thanks for the input so far. The database server is getting upgraded in the near future. So hopefully that will help. We not in a position to use the Resource Governor Silver Bullet. I will look into any throttle options for DB2.

Hey Jon,

I had our DBA look into this and he found a DB2GOV command that he thinks will do what you need. I don't know too much about it, or even if it's a separate utility or what. You can probably get more information from IBM's website.