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. |