Restrict control file
-
-
RESTRICT FROM 0800 TO 1800
-
Applies restrictions during the online window.
-
MAX_IDLETIME 60
-
Forces users that are in LUW and not performing SQL statements for more than
60 seconds.
-
MAX_LUW_RESPONSE 30
-
INCLUDE VMUSER CICS*
-
Forces CICS users engaging in LUWs with a duration of more than 30 seconds.
-
MAX_LOCKHOLD 30
-
Forces users that hold a lock for more than 30 seconds, while other
users wait on the locked object.
-
MAX_CHKP_DELAY 10 FORCE_RO
-
Forces read-only users when they delay the start of a system checkpoint for
more than 10 seconds.
If no INCLUDE is specified for a restriction, the default applies, which
will restrict all users, except SQLDBA.