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
>>-disable_MQFunctions-- -n--database-- -u--userid-------------->
>-- -p--password--+--------------+-----------------------------><
'- -v -+-all-+-'
+-0pc-+
'-1pc-'
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