disable_MQFunctions - Disable WebSphere MQ functions command
Disables the use of Db2® WebSphere® MQ functions for the specified database.
Authorization
one of the following authorities:
- SYSADM
- DBADM
- IMPLICIT_SCHEMA on the database, if the implicit or explicit schema name of the function does not exist
- CREATEIN privilege on the schema, if the schema name, DB2MQ or DB2MQ1C exists
Command syntax
Command Parameters
- -n database
- Specifies the name of the database.
- -u userid
- Specifies the user ID used to connect to the database.
- -p password
- Specifies the password for the user ID.
- -v
- Optional. This is used for transactional and non-transactional user-defined function support. The values can be either all, 0pc, or 1pc. When you specify 0pc, the disablement deletes from schema db2mq. If you specify 1pc, then the disablement deletes from schema db2mq1c. If you specify all, then the disablement deletes from both schemas (db2mq and db2mq1c). If you do not specify this option, the disablement defaults to the all option.
Example
In the following example, DB2MQ
and DB2MQ1C functions are disabled for the database
SAMPLE
. disable_MQFunctions -n sample -u user1 -p password1