Network Deployment (Distributed operating systems), v8.0 > Administer applications and their environment > Administer web services - UDDI registry > Administer the UDDI registry > Reinstalling the UDDI registry application

Create a DB2 distributed database for the UDDI registry

Complete this task to use DB2 on the Windows, Linux, or UNIX operating systems as the database store for your UDDI registry data.

The following steps use a number of variables. Before you start, decide appropriate values to use for these variables. The variables, and suggested values, are:

DataBaseName

The name of the UDDI registry database. A suggested value is UDDI30. The UDDI information uses the suggested name of UDDI30, so if you use a different name, remember to substitute it when you see UDDI30 in the UDDI information.

DB2UserID

A DB2 user ID with administrative privileges.

DB2Password

The password for the DB2 user ID.

BufferPoolName

The name of a buffer pool for the UDDI registry database to use. A suggested value is uddibp, but you can use any name because the buffer pool is created as part of this task.

TableSpaceName

The name of a table space. A suggested value is uddits, but you can use any name.

TempTableSpaceName

The name of a temporary table space. A suggested value is udditstemp, but you can use any name because the temporary table space is created as part of this task.

To create a remote database, refer first to the database product documentation about the relevant capabilities of the product.
You complete this task only once for each UDDI registry, as part of setting up and deploying a UDDI registry.

Procedure

1. Change the directory to WAS_HOME/UDDIReg/databaseScripts.

2. Start the DB2 Command Line Processor. Enter the following command at the command prompt:(AIX) (Solaris)

   db2
   

   (Windows)

   db2cmd
   

   Then run in the new DB2 window:

   db2
   

3. Set up the DB2 environment variables. Enter the following command:

   set DB2CODEPAGE=1208
   

4. Create the DB2 database. Enter the following command:

   create database DataBaseName using codeset UTF-8 territory en
   

5. Configure the DB2 database. Enter the following commands:

   1. connect to DataBaseName user DB2UserID using DB2Password
      

   2. update db cfg for DataBaseName using applheapsz 2048
      

   3. update db cfg for DataBaseName using logfilsiz 8192
      

   4. connect reset
      

   5. terminate
      

   6. force application all 

   7. terminate
      

   8. stop
      

   9. start
      

6. Restart the DB2 Command Line Processor. For all operating systems except Windows, run at the command prompt:

   db2
   

   (Windows) For the Windows operating system, run at the command prompt:

   db2cmd
   

   Then run in the new DB2 window:

   db2
   

7. Create further database structures. Enter the following commands:

   1. connect to DataBaseName user DB2UserID using DB2Password
      
      

   2. create regular tablespace uddits pagesize 32K managed by system using
      ('TableSpaceName') extentsize 64 prefetchsize 32 bufferpool BufferPoolName
      

   3. create system temporary tablespace TempTableSpacename pagesize 32K managed by
      system using ('TempTableSpacename') extentsize 32 overhead 14.06
      prefetchsize 32 transferrate 0.33 bufferpool BufferPoolName
      
      

8. Define the database structures that are needed to store the UDDI data.

   (AIX) (Solaris) Exit the DB2 Command Line Processor and enter the following commands exactly as shown. Note that one step uses -vf rather than -tvf.

   (Windows) For the Windows operating system, runs exactly as shown from the db2cmd window. Note that one step uses -vf rather than -tvf.

   1. db2 -tvf uddi30crt_10_prereq_db2.sql
      

   2. db2 -tvf uddi30crt_20_tables_generic.sql
      

   3. db2 -tvf uddi30crt_25_tables_db2udb.sql
      

   4. db2 -tvf uddi30crt_30_constraints_generic.sql
      

   5. db2 -tvf uddi30crt_35_constraints_db2udb.sql
      

   6. db2 -tvf uddi30crt_40_views_generic.sql
      

   7. db2 -tvf uddi30crt_45_views_db2udb.sql
      

   8. db2 -vf uddi30crt_50_triggers_db2udb.sql
      

   9. db2 -tvf uddi30crt_60_insert_initial_static_data.sql
      

   Optional. To use the database as a default UDDI node, run:

   db2 -tvf uddi30crt_70_insert_default_database_indicator.sql
   

9. Issue the following commands:

   connect reset
   terminate
   

10. Issue the following commands:

    connect reset
    terminate
    

What to do next

Continue with setting up and deploying your UDDI registry node.
Set up a default UDDI node
Set up a customized UDDI node

+

Search Tips   |   Advanced Search