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

Read syntax diagramSkip visual syntax diagramdisable_MQFunctions-ndatabase-uuserid-ppassword -v all0pc1pc

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