WebSphere Application Server Version 6.1 Feature Pack for Web Services
             Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

             Personalize the table of contents and search results

Creating a DB2 distributed database for the UDDI registry

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

Before you begin

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 recommended value is UDDI30, and this name is assumed throughout the UDDI information. If you use another name, substitute that name when UDDI30 is used in the information center.
<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 name 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.

If you want to create a remote database, refer first to the database product documentation about the relevant capabilities of the product.

About this task

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

Procedure

  1. Change directory to app_server_root/UDDIReg/databaseScripts.
  2. Start the DB2 Command Line Processor by entering db2 at the command prompt.

    [Windows] For Windows platforms, enter db2cmd and then enter db2 in the new DB2 window.

  3. Run the following command to set up the DB2 environment variables:
    set DB2CODEPAGE=1208
  4. Create the DB2 database by entering the following command:
    create database <DataBaseName> using codeset UTF-8 territory en
    where <DataBaseName> is the name of the database to create.
  5. Configure the DB2 database by entering 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. Create additional database structures by entering the following commands:
    1. connect to <DataBaseName> user <DB2UserID> using <DB2Password>
    2. create bufferpool <BufferPoolName> size 250 pagesize 32K
    3. connect reset
    4. terminate
    5. force application all
    6. terminate
    7. stop
    8. start
  7. Create further database structures by entering 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. Exit the DB2 Command Line Processor and enter the following commands exactly as shown, noting that one step uses -vf rather than -tvf (on Windows platforms, run the commands from the db2cmd window). These commands define the database structures that are needed to store the UDDI data:
    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
  9. [Optional] Enter the following command if you want the database to be used as a default UDDI node:
    db2 -tvf uddi30crt_70_insert_default_database_indicator.sql

What to do next

Continue with setting up and deploying your UDDI registry node.




In this information ...


IBM Redbooks, demos, education, and more


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

This feature requires Internet access.

IBM Suggests
Task topic    

Terms of Use | Feedback

Last updated: Nov 25, 2008 2:35:59 AM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.wsfep.multiplatform.doc/info/ae/ae/twsu_create_db2.html