Release Notes

20.6 enable_MQFunctions

enable_MQFunctions

Enables DB2 MQSeries functions for the specified database and validates that the DB2 MQSeries functions can be executed properly. The command will fail if MQSeries and MQSeries AMI have not been installed and configured.

Authorization

One of the following:

• 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, exists

Command Syntax

>>-enable_MQFunctions---n--database---u--userid---p--password--->
 
>--+-------+--+------------+-----------------------------------><
   '-force-'  '-noValidate-'
 
 

Command Parameters

-n database

Specifies the name of the database to be enabled.

-u userid

Specifies the user ID to connect to the database.

-p password

Specifies the password for the user ID.

-force

Specifies that warnings encountered during a re-installation should be ignored.

-noValidate

Specifies that validation of the DB2 MQSeries functions will not be performed.

Examples

In the following example, DB2MQ functions are being created. The user connects to the database SAMPLE. The default schema DB2MQ is being used.

   enable_MQFunctions -n sample -u user1 -p password1

Usage Notes

The DB2 MQ functions run under the schema DB2MQ which is automatically created by this command.

Before Executing this command:

• Ensure that MQ and AMI are installed, and that the version of MQSeries is 5.1 or higher.
• Ensure that the environment variable $AMT_DATA_PATH is defined.
• Change the directory to the cfg subdirectory of the DB2PATH

On UNIX:

• Use db2set to add AMT_DATA_PATH to the DB2ENVLIST.
• Ensure that the user account associated with UDF execution is a member of the mqm group.
• Ensure that the user who will be calling this command is a member if the mqm group.

Note:

AIX 4.2 is not supported by MQSeries 5.2.