Use the Common database installation parameters to set up the Common database .
Users fill in the installation parameters in the installer and these installation parameters are transferred from Profile Management Tool to Common database scripts.
Parameter name | Description | Notes® |
---|---|---|
dbCreateNew | Flag to create or reuse database | Valid values are true or false. |
dbDelayConfig | Flag to postpone table creation after profile is created. | Valid values are true or false. Defaults to false. |
dbType | Database type | See "Supported database types." |
dbDriverType | Database driver type | ORACLE_THIN or ORACLE_OCI |
dbName | Database name | Defaults to WPRCSDB. |
dbLocation | Directory of database server installation | For Informix® only, if dbCreateNew is true. |
dbUserId | User ID for database authenticate | Required except for Common database. |
dbPassword | Password for database authentication | Required except for Common database. |
dbServerPort | Database server port number | Default value per dbType |
dbServerName | Database server name (applicable for Sybase only) | For SYBASE only. Deprecated. |
dbInstance | Database instance name (applicable forInformix Dynamic Server only) | For Informix Dynamic Server only. |
dbSchemaName | Database schema name | For DB2® on z/OS and i5/OS® only. |
dbJDBCClasspath | Location of JDBC driver files | |
dbConnectionLocation | Location of DB2 z/OS® database | For DB2 on z/OS only. |
dbStorageGroup | Storage group name for DB2 z/OS | For DB2 on z/OS only. |
dbCommonForME | Use common DB for messaging engines | Default value true for z/OS. |
dbOutputScriptDir | Location of database scripts | This is optional. User may override the default value. |
dbHostName | The default name depends on the database. | |
file StoreForME | Specifies the file store for messaging engine. |
Database Type | dbType | |
---|---|---|
A | Derby Embedded | DERBY_EMBEDDED |
B | Derby Network Server | DERBY_NETWORK |
C | DB2 Universal | DB2_Universal |
D | DB2 for z/OS v8 or DB2 for z/OS v9 | DB2UDBOS390_V8_1 or DB2UDBOS390_V9_1 |
E | DB2 for i5/OS (Native) |
DB2UDBISERIES_NATIVE |
F | DB2 UDB for iSeries (Toolbox) |
DB2UDBISERIES_TOOLBOX |
H | Informix Dynamic Server | INFORMIX |
I | Microsoft SQL Server (Embedded) | MSSQLSERVER_Embedded |
J | Microsoft SQL Server (DataDirect)Microsoft SQL Server (Microsoft) - Support for the Microsoft SQL Server JDBC Driver, version 1.2 was added in WebSphere Process Server, version 6.2.0.1 | MSSQLSERVER_DataDirect MSSQLSERVER_Microsoft |
K | Oracle 9i |
Oracle9i Note: Use Oracle10g for Oracle 10g and Oracle 11g
|
Parameter name | A | B | C | D | E | F | G | H | I | J | K |
---|---|---|---|---|---|---|---|---|---|---|---|
dbCreateNew | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
dbDelayConfig | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
dbType | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
dbDriverType | Y | Y | |||||||||
dbName | Y | Y | Y | Y | Y1 | Y2 | Y | Y | Y | Y | Y |
dbLocation | Y3 | ||||||||||
dbUserId | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | |
dbPassword | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | |
dbServerPort | Y | Y | Y | Y | Y | Y | Y | ||||
dbHostName | Y | Y | Y | Y | Y | Y | Y | Y | |||
dbServerName | |||||||||||
dbInstance | Y | ||||||||||
dbSchemaName | Y | Y | Y | ||||||||
dbJDBCClasspath | Y | Y | Y | Y | Y | Y | Y | Y | |||
dbConnectionLocation | Y | ||||||||||
dbStorageGroup | Y | ||||||||||
dbCommonForME 4 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |