Release Notes
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.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]