WebSphere Enterprise Service Bus, Version 6.2.0 Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows


Common database installation parameters

Use the Common database installation parameters to set up the Common database .

Common database Installation Parameters

Users fill in the installation parameters in the installer and these installation parameters are transferred from Profile Management Tool to Common database scripts.

Table 1. Common database installation parameters
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.  
The values of the variable dbType are set by the installer.
Table 2. dbType values
  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)
DB2 UDB for iSeries (Native)

DB2UDBISERIES_NATIVE
F

DB2 UDB for iSeries (Toolbox)
DB2 for i5/OS (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
Oracle 10g
Oracle 11g

Oracle9i
Oracle10g

Note: Use Oracle10g for Oracle 10g and Oracle 11g
The Common database requires different parameters depending on the database you choose.
Table 3. Common database required parameter for different database types
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
Notes:
  1. The parameter dbName is defaulted to "*LOCAL" for DB2 UDB for iSeries (Native).
  2. The parameter dbName is defaulted to "*SYSBAS" for DB2 UDB for iSeries (Toolbox).
  3. The parameter dbLocation is only required when dbType is Informix Dynamic Server and dbCreateNew is true.
  4. The parameter dbCommonForME is true for z/OS by default. On distributed and i5/OS it is false by default.

reference Reference topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.doc/doc/rpln_common_db_install_parameters.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).