How to enable "begin_copy_nowait" and "online_switch_no_wait"?
1. 'BEGIN_COPY_NOWAIT' -> default is no.
If user chooses to change it to yes, begin copy will use a no waiting style of exclusive lock on the original table. This type of lock will not wait to obtain the exclusive and will fail if the lock is not obtained.
When this lock attempt fails, it will retry based on parameters 'BEGIN_COPY_TIMEOUT' and 'BEGIN_COPY_SLEEP'.
To set BEGIN_COPY_NOWAIT visible, connect the database, and run the following:
update <qsa_schema_owner>.quest_exec_parameter set VIEWABLE='Y', MODIFIABLE='Y'
where name in ('BEGIN_COPY_NOWAIT' , 'BEGIN_COPY_TIMEOUT', 'BEGIN_COPY_SLEEP') ;
commit ;
2. 'ONLINE_SWITCH_LOCK_NOWAIT' -> default is no.
If online switch will use a no waiting style of exclusive lock on the original table. This type of lock will not wait to obtain the exclusive, and will fail if the lock is not obtained.
When this lock attempt fails, it will retry based on parameters 'ONLINE_SWITCH_LOCK_TIMEOUT' and 'ONLINE_SWITCH_LOCK_SLEEP'.
To set 'ONLINE_SWTICH_LOCK_NOWAIT' visible, connect to the database, and run the following:
update <qsa_schema_owner>.quest_exec_parameter set VIEWABLE='Y', MODIFIABLE='Y'
where name in ('ONLINE_SWITCH_LOCK_NOWAIT', 'ONLINE_SWITCH_LOCK_TIMEOUT', 'ONLINE_SWITCH_LOCK_SLEEP') ;
commit ;
3. Once the above updates are done, user can change the parameter above parameters thru File | Admin | Configure Quest Server Agent.
These parameters are available on version 6.7 and up.
