A number of parameter can be set either at the queue or at the instance (also called global) level. The difference between them is obvious in terms of the setting. The former only works for a specific queue and the latter for all the queues (of that queue type) in the instance. For example, if you have decided to set SP_OPO_DISABLE_OBJECT_NUM in the queue QUE1 to a value of 101, the object id from the source for which you want Post to ignore posting on the target object. You issued the following command to do so:
sp_ctrl>set param SP_OPO_DISABLE_OBJECT_NUM queue QUE1 101
The "list param all post" would show that it took effect as seen from the setting for the second line for queue QUE1:
sp_ctrl>list param all post
Post parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- -------
---------------
.
.
SP_OPO_DISABLE_OBJECT_NUM Restart Process
SP_OPO_DISABLE_OBJECT_NUM 101 Restart Process
Queue QUE1
Default Value:
At a later time you decided to undo the change and issued the command "reset param <name>" but found that the command did not take effect as shown below:
sp_ctrl>reset param SP_OPO_DISABLE_OBJECT_NUM
sp_ctrl>list param all post
SP_OPO_DISABLE_OBJECT_NUM 0 Restart Process
SP_OPO_DISABLE_OBJECT_NUM 101 Restart Process
Queue QUE1
If a parameter is set at a queue level, it can only be reset at the queue level
To reset the parameter at the queue level, one needs to issue the reset param command with the [queue <queuename>] option (that is, at the queue level) and not at the global level. For example:
sp_ctrl>reset param SP_OPO_DISABLE_OBJECT_NUM queue QUE1
Â
In general if the parameter has been set locally (at a process, queue, host, etc), then it can only be reset by issuing the reset command with the appropriate option and not with the reset command without any option (which would only reset the parameter globally). This also means that if a parameter is set globally, then it can only be unset globally.
