Enabling the DB2 Web Services Consumer UDFs and DB2 XML Extender

This topic describes some prerequisite tasks that complete before you use the Web Service User-Defined Function wizard to create DB2 user-defined functions (UDFs) that can access the operations of Web services.

Prerequisite:

DB2 Universal Database for Linux, UNIX, and Windows Version 8.1.2 or higher

The DB2 Web Services Consumer UDF package and DB2 XML Extender are included with DB2 Universal Database for Linux, UNIX, and Windows Version 8.1.2 or higher. Follow the instructions provided with these packages to install them on your system.

To enable the DB2 Web Services Consumer UDFs and DB2 XML Extender:

  1. Enable the Web services consumer UDFs by typing the following command:db2enable_soap_udf -n dbName [-u uID -p password] [-force]

    The parameters are:

    • dbName is the name of the database

    • uID is a user ID

    • password is the password associated with the user ID

  2. Bind the XML Extender by typing this series of commands:

    1. db2 connect to dbName

    2. db2 bind sqllib\bnd\@dxxbind.lst

    3. db2 terminate

      The parameters are:

      • dbName is the name of the database

      • sqllib is the directory where you installed DB2 Universal Database

  3. Enable the XML Extender by typing this command: dxxadm enable_db db_name -l login -p password

    The parameters are:

    • dbName is the name of the database

    • login is an optional user ID. If specified, this user ID is used to connect to the database. If not specified, the current user ID is used.

    • password is the password for the user ID you specified.

    For more information, see the DB2 XML Extender Administration and Programming Guide.

You have now enabled the DB2 Web Services Consumer UDFs and DB2 XML Extender, and you are ready to run the Web service UDF wizard.

 

Related tasks

Creating a DB2 user-defined function to access Web services