An "awexe" command can be used to deactivate or activate a Queue. More information about awexe commands can be found in the documentation section titled: awexe - Accessing Applications Manager Capabilities
PLEASE NOTE that the following values is required to be known.
1. QUEUE NAME
2. QUEUE's THREAD SCHEDULE NAME
3. QUEUE PRIORITY
4. USER
5. USER's Password
ADDITIONALLY, the command is making an update to the Queue so providing the incorrect Queue Priority, for example will change Priority value for the given Queue which may be unwanted.
The following awexe parameters are required to run the command:
aw_queue tranmode=UF
so_queue="QUEUE NAME"
name="QUEUE's THREAD SCHEDULE NAME"
so_queue_status=N or Y (deactivate or activate)
so_queue_pri="QUEUE PRIORITY" (accepted values is 1-99)
so_user_name="USER"
password="USER's password"
Release : 9.4.x
Below is an example command to deactivate BATCH queue, which uses Thread Schedule MONITOR, and has a Priority of 50, using the default user SQLOPER and default password:
[ams@myhost ~]$ awexe aw_queue tranmode=UF so_queue="BATCH" name="MONITOR" so_queue_status=N so_queue_pri=50 so_user_name=SQLOPER password="defaultpassword"
0Success
Below is an example of activating the same Queue:
[ams@myhost ~]$ awexe aw_queue tranmode=UF so_queue="BATCH" name="MONITOR" so_queue_status=Y so_queue_pri=50 so_user_name=SQLOPER password="defaultpassword"
0Success