Creating a DB2 database for iSeries

Perform this task if you want to use DB2 as the database store for your UDDI Registry data. This is done only once for each UDDI Registry, as part of Setting up and deploying a UDDI Registry.

Note: These instructions apply to DB2 UDB for iSeries only.

Before you begin

IBMUDI30 and IBMUDS30 are the default names of the UDDI Registry schema in SQL scripts. The recommended value is IBMUDI30 and IBMUDS30. This name is assumed throughout the UDDI documentation. If you use some other name, then you should substitute that name whenever you see 'IBMUDI30' or 'IBMUDS30' in other sections of the documentation.

Note: Schema names that are substituted to non-default values will need to be modified in the SQL files listed below.

To create the DB2 database follow the steps shown below:

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 iSeries DB2 SQL files.

   1. Map a network drive to the root directory of your iSeries server's integrated file system.

   2. In Windows^(R) Explorer, expand to 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 above steps for all the SQL scripts listed in step 2.

   Note: iSeries Navigator for OS/400 V5R2 will encounter an error on the last line of the SQL script when running uddi30crt_25_tables_db2udb_iSeries.sql script. This error can be ignored. OS/400 V5R2 does support running UDDI in clustered high availability environment. For more information, see the WebSphere Application Server for iSeries tech notes.

4. This step should only be run if you want your database to be used as a default UDDI node.

   1. Open uddi30crt_70_insert_default_database_indicator.sql as described in Step 2 above.

   2. Copy and Run uddi30crt_70_insert_default_database_indicator.sql as described in Step 3 above.

What to do next

Continue with setting up and deploying your UDDI Registry node.

Related tasks
Creating a DB2 database
Creating a Cloudscape database
Creating an Oracle database