Creating a DB2 for iSeries database for the UDDI registry

Perform this task if you want to use DB2 for iSeries as the database store for your UDDI registry data.

Before you begin

IBMUDI30 and IBMUDS30 are the default names of the UDDI registry schema in the SQL scripts described in this topic. These default names are the recommended values and are assumed throughout the UDDI information. To use different names, modify the SQL files listed in this topic, then substitute your own names when IBMUDI30 or IBMUDS30 is used in the information center.

About this task

You perform this task only once for each UDDI registry, as part of setting up and deploying a UDDI registry.

Procedure

  1. Use iSeries Navigator to run SQL scripts.
    1. Open iSeries Navigator.
    2. Expand My Connections > iSeriesName > Databases.
    3. Select iSeriesName.
    4. Right-click Run SQL Scripts....
    A Run SQL Scripts window opens.
  2. Open the i5/OS DB2 SQL files.
    1. Map a network drive to the root directory of your i5/OS server's integrated file system.
    2. In Windows Explorer, expand the WAS_HOME/UDDIReg/databaseScripts directory.
    3. Open the following SQL files with a text editor (such as Notepad):
      • uddi30crt_10_prereq_db2_iSeries.sql
      • uddi30crt_20_tables_generic_iSeries.sql
      • uddi30crt_25_tables_db2udb_iSeries.sql
      • uddi30crt_30_constraints_generic_iSeries.sql
      • uddi30crt_35_constraints_db2udb_iSeries.sql
      • uddi30crt_40_views_generic_iSeries.sql
      • uddi30crt_45_views_db2udb_iSeries.sql
      • uddi30crt_50_triggers_db2udb_iSeries.sql
      • uddi30crt_60_insert_initial_static_data_iSeries.sql
  3. Copy the text to the Run SQL Scripts window.
    1. In the text editor of the file uddi30crt_10_prereq_db2_iSeries.sql, click Edit > Select All .
    2. Click Edit > Copy .
    3. In the Run SQL Scripts window, click Edit > Paste.
    4. Click Run > All .
    5. After the script completes running, select all the SQL text and delete it from the Run SQL Scripts window.
    6. Repeat the previous steps for all the SQL scripts listed in step 2.
    Note: iSeries Navigator for i5/OS V5R2 will encounter an error on the last line of the SQL script when running the uddi30crt_25_tables_db2udb_iSeries.sql script. This error can be ignored. i5/OS V5R2 does support running UDDI in a clustered high availability environment. For more information, see the WebSphere Application Server for i5/OS tech notes.
  4. [Optional] Use the following steps if you want the database to be used as a default UDDI node:
    1. Open uddi30crt_70_insert_default_database_indicator.sql as described in Step 2 earlier.
    2. Copy and run uddi30crt_70_insert_default_database_indicator.sql as described in Step 3 earlier.

What to do next

Continue with setting up and deploying your UDDI registry node.




In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 30, 2013 6:03:36 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-base-iseries&topic=twsu_create_db2_iseries
File name: twsu_create_db2_iseries.html