- 论坛徽章:
- 0
|
db2.cfg设置如下:
------------------------------------------------------------
dbname detail; account 60; interval 300;
desc "CPU restrictions apply 24 hours a day to most everyone.
Limit cpu usage to 30 minutes,rows selected to 1 mil.,
rows read to 40 mil. and idle time to 4 hrs. "
setlimit cpu 1800 rowssel 1000000 rowsread 40000000 idle 14400 action force;
desc "Allow no UOW to run for more than an hour"
setlimit uowtime 3600;
desc "During the backup interval, don't let anyone run for
more than 7 minutes cpu or be idle more than an hour"
time 20:45 02:00 setlimit cpu 420 idle 3600 action force;
desc "DB2ADM is unrestricted"
authid db2adm setlimit cpu -1 locks -1 rowssel -1 rowsread -1 idle -1;
--------------------------------------------------------------
可是在使用db2adm(db2管理员)运行load时,被force,原因是rowsread>40000000, 请问db2gov.cfg中是否有前后权限高低之分?我明明已经设置了db2adm rowsread -1没有限制,为什么还被force?请教高手,最好有文档证明之!谢谢 |
|