Judy,
Here are some notes I made on the governor:
1. Put governor cfg file in ${DBDIR}/sqllib.
2. Here is an example of the governor cfg file:
============================================================
{Wake up every 60 seconds, the database name is proddb
do accounting every 60 minutes. }
interval 60;
dbname proddb;
account 60;
desc "Limit all processes to 60 cpu minutes (5400
seconds) "
setlimit cpu 5400 action force;
desc "Load jobs have no limit "
applname db2bp_s
setlimit cpu -1;
desc "Op id's - unlimited cpu "
authid oper01, oper02, dbadm
setlimit cpu -1;
desc "Limit all processes to 120 min (7200 seconds)
idle time"
setlimit idle 7200 action force;
desc "Op id's - unlimited idle "
authid oper01, oper02, dbadm
setlimit idle -1;
============================================================
3. To start the governor, log on as the instance owner
and cd to ${DBDIR}/sqllib: db2gov start db_name
db_governor.cfg db2_governor.log
4. To stop the governor, log on as then instance owner
and cd to ${DBDIR}/sqllib: db2gov stop db_name
5. To display governor log info, cd to ${DBDIR}/sqllib
:
db2govlg db2_governor.log rectype FORCE
6. Don't forget to clean up the old log files. Stop
the governor, clean up the logs and restart the
governor.
Hope that helps!
Mike
--- [EMAIL PROTECTED] wrote:
>
>
> Hello all,
>
> Can anyone tell me where to read/learn more about
> the DB2 governor? We are
> running UDB EE v6.1 on AIX 4.3.3, if that has
> bearing on the answer. I just
> finished reading the chapter in the Administrative
> Guide: Performance manual,
> but I was hoping to find more information somewhere.
>
> Many thanks,
> Judy
>
>
>
> =====
> To unsubscribe, send 'unsubscribe' to
> [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
