IBM BPM, V8.0.1, All platforms > Install IBM BPM > IBM BPM Advanced for z/OS: Process Server > Configure IBM BPM Advanced for z/OS: Process Server > Create and augmenting profiles > Set up the configuration file system and creating a profile > Generate a design file and database scripts for the database objects

Database design tool examples

You can use the database design tool to generate a design file for different types of databases, including DB2, Oracle, and SQL Server.

DB2 for z/OS

If you select bpm.advanced.nd.topology or bpm.advanced.standalone, after you configure the master component, you must manually configure the BPM_PerformanceDW and BPM_ProcessServer components. Also edit the configuration values of the remaining components to ensure that the configuration is appropriate for each of the databases you want to create.

[info] Please pick one of the following [database component(s)] :

(1)[WBI_CommonDB]       WBI_CommonDB : [master] [status = complete]
(2)[BPC]        WBI_BPC :  [status = complete]
(3)[BPM_PerformanceDW]  BPM_PerformanceDW :  [status = not complete]
(4)[BPM_ProcessServer]  BPM_ProcessServer :  [status = not complete]
(5)[BSpace]     WBI_BSPACE :  [status = complete]
(6)[SibME]      WBI_BPC_ME :  [status = complete]
(7)[SibME]      WBI_CEI_ME :  [status = complete]
(8)[SibME]      WBI_SCA_APP_ME :  [status = complete]
(9)[SibME]      WBI_SCA_SYS_ME :  [status = complete]
(10)[SibMe]     BPM_PerformanceDW_ME :  [status = complete]
(11)[SibMe]     BPM_ProcessServer_ME :  [status = complete]
(12)[save and exit]

Please enter the number for the database component :12

[status] bpm.advanced.nd.topology is not complete with 6 remaining item(s):
[ 1 ] BPM_ProcessServer.BPM_ProcessServer : databaseObjects : required property 'schemaName' for SCHEMA is empty.
[ 2 ] BPM_ProcessServer.BPM_ProcessServer : databaseObjects : required property 'catalog' for VCAT is empty.
[ 3 ] BPM_ProcessServer.BPM_ProcessServer : databaseObjects : required property 'adminUserName' for SECURITY_ADMIN_USER is empty.
[ 4 ] BPM_ProcessServer.BPM_ProcessServer : databaseObjects : required property 'adminPassword' for SECURITY_ADMIN_PASSWORD is empty.
[ 5 ] BPM_PerformanceDW.BPM_PerformanceDW : databaseObjects : required property 'schemaName' for SCHEMA is empty.
[ 6 ] BPM_PerformanceDW.BPM_PerformanceDW : databaseObjects : required property 'catalog' for VCAT is empty.

Oracle

If you select bpm.advanced.standalone or bpm.advanced.nd.topology, after you configure the master component, you must manually configure the BPM_PerformanceDW, BPM_ProcessServer, and the corresponding SibMe components for the required database authentication.

[info] Please pick one of the following [database component(s)] :

(1)[WBI_CommonDB]       WBI_CommonDB : [master] [status = complete]
(2)[BPC]        WBI_BPC :  [status = complete]
(3)[BPM_PerformanceDW]  BPM_PerformanceDW :  [status = not complete]
(4)[BPM_ProcessServer]  BPM_ProcessServer :  [status = not complete]
(5)[BSpace]     WBI_BSPACE :  [status = complete]
(6)[SibMe]      WBI_BPC_ME :  [status = complete]
(7)[SibMe]      WBI_CEI_ME :  [status = complete]
(8)[SibMe]      WBI_SCA_APP_ME :  [status = complete]
(9)[SibMe]      WBI_SCA_SYS_ME :  [status = complete]
(10)[SibMe]     BPM_PerformanceDW_ME : [parent = BPM_PerformanceDW] [status = not complete]
(11)[SibMe]     BPM_ProcessServer_ME : [parent = BPM_ProcessServer] [status = not complete]
(12)[save and exit]

Please enter the number for the database component :12

[status] bpm.advanced.standalone is not complete with 6 remaining item(s):
[ 1 ] BPM_ProcessServer.BPM_ProcessServer : databaseObjects : required property 'databaseUser' for DB_USER is empty.
[ 2 ] BPM_ProcessServer.BPM_ProcessServer : databaseObjects : required property 'adminUserName' for SECURITY_ADMIN_USER is empty.
[ 3 ] BPM_ProcessServer.BPM_ProcessServer : databaseObjects : required property 'adminPassword' for SECURITY_ADMIN_PASSWORD is empty.
[ 4 ] BPM_PerformanceDW.BPM_PerformanceDW : databaseObjects : required property 'databaseUser' for DB_USER is empty.
[ 5 ] SibMe.BPM_PerformanceDW_ME : databaseObjects : required property 'database
User' for user is empty.
[ 6 ] SibMe.BPM_ProcessServer_ME : databaseObjects : required property 'database
User' for user is empty.

SQL Server

If you select bpm.advanced.nd.topology or bpm.advanced.standalone, after you configure the master component, you must manually configure the BPM_ProcessServer component.

[info] Please pick one of the following [database component(s)] :

(1)[WBI_CommonDB]       WBI_CommonDB : [master] [status = complete]
(2)[BPC]        WBI_BPC :  [status = complete]
(3)[BPM_PerformanceDW]  BPM_PerformanceDW :  [status = complete]
(4)[BPM_ProcessServer]  BPM_ProcessServer :  [status = not complete]
(5)[BSpace]     WBI_BSPACE :  [status = complete]
(6)[SibME]      WBI_BPC_ME :  [status = complete]
(7)[SibME]      WBI_CEI_ME :  [status = complete]
(8)[SibME]      WBI_SCA_APP_ME :  [status = complete]
(9)[SibME]      WBI_SCA_SYS_ME :  [status = complete]
(10)[SibMe]     BPM_PerformanceDW_ME :  [status = complete]
(11)[SibMe]     BPM_ProcessServer_ME :  [status = complete]
(12)[save and exit]

Please enter the number for the database component :12

[status] bpm.advanced.nd.topology is not complete with 2 remaining item(s):
[ 1 ] BPM_ProcessServer.BPM_ProcessServer : databaseObjects : required property 'adminUserName' for SECURITY_ADMIN_USER is empty.
[ 2 ] BPM_ProcessServer.BPM_ProcessServer : databaseObjects : required property 'adminPassword' for SECURITY_ADMIN_PASSWORD is empty.

Generate a design file and database scripts for the database objects