Using the USS command prompt, run the copy of the createddl.sh
script by entering the following command: createddl.sh database_name tablespace_name hlq
The
parameters are as follows:
- database_name
- The name that is used when defining the required DB2 tables and other components. The default
is UDDI30.
- tablespace_name
- The tablespace in which the database tables are defined. The
default is UDDI30TS.
- hlq
- The high-level qualifier under which the SQL and Job Control Language
(JCL) partitioned data sets (PDS) are created. The default is IBMUSER.
The script generates the hlq.UDDI.SQL
and hlq.UDDI.JCL partitioned data sets, which contain
members that are required for subsequent steps. If the script runs
successfully using the default parameters, the result is the following
output:
database.tablespace = UDDI30.UDDI30TS
HLQ = IBMUSER
( 14) /WebSphere/V7R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_10_prereq_db2.sql
( 436) /WebSphere/V7R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_20_tables_generic.sql
( 136) /WebSphere/V7R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_25_tables_db2udb.sql
( 452) /WebSphere/V7R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_30_constraints_generic.sql
( 14) /WebSphere/V7R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_35_constraints_db2udb.sql
( 559) /WebSphere/V7R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_40_views_generic.sql
( 94) /WebSphere/V7R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_45_views_db2udb.sql
( 329) /WebSphere/V7R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_50_triggers_db2udb.sql
( 16) /WebSphere/V7R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_60_insert_initial_static_
data.sql
( 39) /WebSphere/V7R0M0/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)
database.tablespace = UDDI30.UDDI30TS
HLQ = IBMUSER
( 14) /WebSphere/V8R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_10_prereq_db2.sql
( 436) /WebSphere/V8R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_20_tables_generic.sql
( 136) /WebSphere/V8R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_25_tables_db2udb.sql
( 452) /WebSphere/V8R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_30_constraints_generic.sql
( 14) /WebSphere/V8R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_35_constraints_db2udb.sql
( 559) /WebSphere/V8R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_40_views_generic.sql
( 94) /WebSphere/V8R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_45_views_db2udb.sql
( 329) /WebSphere/V8R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_50_triggers_db2udb.sql
( 16) /WebSphere/V8R0M0/AppServer/UDDIReg/databaseScripts/uddi30crt_60_insert_initial_static_
data.sql
( 39) /WebSphere/V8R0M0/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)