Perform this task if you want to use DB2 for z/OS as the database store for your UDDI registry data.
Before you begin
In order to connect from a machine running a distributed operating system to a remote DB2 database on the z/OS operating system, you must have DB2 Version 8.2 or later. You must also have a DB2 Connect license (see the DB2 documentation for more information).Why and when to perform this task
You only need to perform this task once for each UDDI registry, as part of setting up and deploying a UDDI registry.
If you are creating a remote database, use the database product documentation to familiarize yourself with the relevant capabilities of the product before proceeding with this task.
Steps for this task
createddl.sh database_name tablespace_name hlqwhere the parameters are as follows:
The script generates the partitioned data sets hlq.UDDI.SQL and hlq.UDDI.JCL, containing members that are required for subsequent steps.
Using the default parameters listed above, a successful execution of the script results in the following output:database.tablespace = UDDI30.UDDI30TS HLQ = IBMUSER ( 14) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_10_prereq_db2.sql ( 436) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_20_tables_generic.sql ( 136) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_25_tables_db2udb.sql ( 452) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_30_constraints_generic.sql ( 14) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_35_constraints_db2udb.sql ( 559) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_40_views_generic.sql ( 94) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_45_views_db2udb.sql ( 329) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_50_triggers_db2udb.sql ( 16) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_60_insert_initial_static_data.sql ( 39) /WebSphere/V6R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_70_insert_default_database_indicator.sql Conversion complete /tmp/udditmp/makedb71.jcl ===> IBMUSER.UDDI.JCL(MAKEDB71) /tmp/udditmp/makedb81.jcl ===> IBMUSER.UDDI.JCL(MAKEDB81) /tmp/udditmp/table.sql ===> IBMUSER.UDDI.SQL(TABLE) /tmp/udditmp/table7.sql ===> IBMUSER.UDDI.SQL(TABLE7) /tmp/udditmp/index.sql ===> IBMUSER.UDDI.SQL(INDEX) /tmp/udditmp/view.sql ===> IBMUSER.UDDI.SQL(VIEW) /tmp/udditmp/trigger.sql ===> IBMUSER.UDDI.SQL(TRIGGER) /tmp/udditmp/alter.sql ===> IBMUSER.UDDI.SQL(ALTER) /tmp/udditmp/initial.sql ===> IBMUSER.UDDI.SQL(INITIAL) /tmp/udditmp/insert.sql ===> IBMUSER.UDDI.SQL(INSERT)
What to do next
Continue with setting up and deploying your UDDI registry node.
Related tasks
Setting up a default UDDI node
Setting up a customized UDDI node
Setting up and deploying a new UDDI registry