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 ]