Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Row lock instead of page lock
In particular, the CleanUpHistory /sos/housekeeping/scheduler_cleanup_history job could have problems if a page lock is set in the database tables SCHEDULER_HISTORY and SCHEDULER_ORDER_HISTORY.
Please call the following SQL statements to change the lock level.
MSSQL Server
Code Block |
---|
ALTER INDEX SCHEDULER_HISTORY_START_TIME ON SCHEDULER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_HISTORY_SPOOLER_ID ON SCHEDULER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_HISTORY_JOB_NAME ON SCHEDULER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_H_CLUSTER_MEMBER ON SCHEDULER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_O_HISTORY_SPOOLER_ID ON SCHEDULER_ORDER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_O_HISTORY_JOB_CHAIN ON SCHEDULER_ORDER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
ALTER INDEX SCHEDULER_O_HISTORY_START_TIME ON SCHEDULER_ORDER_HISTORY SET (ALLOW_PAGE_LOCKS = OFF);
|
Sybase
Code Block |
---|
ALTER TABLE SCHEDULER_HISTORY LOCK DATAROWS;
ALTER TABLE SCHEDULER_ORDER_HISTORY LOCK DATAROWS;
|
MySQL
work in progress
Oracle
work in progress
DB2
...