Complete this task if you want to use DB2® for i as the database store for your UDDI
registry data.
Before you begin
The default names of the UDDI registry schema in the SQL
scripts listed in the following topic are IBMUDI30 and IBMUDS30. These
names are the recommended values and are assumed throughout the UDDI
information. To use different names, modify the SQL files listed,
then substitute the new names when IBMUDI30 and IBMUDS30 are used
in the information center.
About this task
You complete this task only once
for each UDDI registry, as part of setting up and deploying a UDDI
registry.
Procedure
- Use IBM® Navigator
for i to run SQL scripts.
- Open IBM Navigator
for i.
- Expand .
- Select iSeriesName.
- Right-click Run SQL Scripts....
A Run SQL Scripts window opens.
- Open the IBM i DB2 SQL files.
- Map a network drive to the root directory of your IBM i server integrated file system.
- In Windows® Explorer,
expand the WAS_HOME/UDDIReg/databaseScripts directory.
- Open the following SQL files with a text editor (for
example, Windows 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
- Copy the text to the Run SQL Scripts window.
- In the text editor of the file uddi30crt_10_prereq_db2_iSeries.sql,
click .
- Click .
- In the Run SQL Scripts window,
click .
- Click .
- After the script completes running, select all the SQL
text and delete it from the Run SQL Scripts window.
- Repeat the previous steps for all the SQL scripts listed
in step 2.
- Optional: If you want to use the database as
a default UDDI node, complete the following steps:
- Open uddi30crt_70_insert_default_database_indicator.sql as
described in step 2.
- Copy and run uddi30crt_70_insert_default_database_indicator.sql as
described in step 3.
What to do next
Continue to set up and deploy your UDDI registry node.