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


manageprofiles parameters for Common database configuration (per database product)

You use specific manageprofiles command parameters to configure the Common database. Parameters you specify can differ depending on the database product you are using and on the type of profile you are creating.

The tables in this topic show the manageprofiles parameters available to configure the Common database using any supported database product. Parameters associated with Common database configuration generally have a "-db" prefix (-dbType, -dbDelayConfig, etc.). For a complete list of manageprofiles parameters, including default values, see the topic manageprofiles parameters. Example manageprofiles commands used to create or augment various types of profiles can be viewed in the topics Creating profiles with manageprofiles command with Derby or DB2 databases – examples and Augmenting profiles with manageprofiles command with Derby or DB2 databases – examples.

To view available parameters for database configuration, choose your database product from the following list:

Note that only the -dbType and -dbJDBCClasspath parameters are available for custom profiles. This is because you are simply identifying the type and driver location for the Common database used by the deployment manager to which you will federate the custom profile.

On Derby Embedded

Table 1 shows the manageprofiles parameters available to configure the Common database used by a stand-alone server profile on Derby Embedded.

Table 1. Available manageprofiles parameters for configuration of Common database using Derby Embedded
Parameter
For stand-alone server profiles
-dbCreateNew (must always be true)
-dbName
-dbOutputScriptDir
-dbType
-fileStoreForME (for stand-alone server profiles only)

On Derby Network Server

Table 2 shows the manageprofiles parameters available to configure the Common database used by a stand-alone server, deployment manager, or custom profile on Derby Network Server.

Table 2. Available manageprofiles parameters for configuration of Common database using Derby Network Server
Parameter
For custom profiles
-dbType
-dbJDBCClasspath
 
For stand-alone server or deployment manager profiles
-dbCommonForME (for stand-alone server profiles only)
-dbCreateNew (must always be true)
-dbHostName
-dbName
-dbOutputScriptDir
-dbPassword
-dbServerPort
-dbType
-dbUserId
-fileStoreForME (for stand-alone server profiles only)

On DB2 Universal

Table 3 shows the manageprofiles parameters available to configure the Common database used by a stand-alone server, deployment manager, or custom profile on DB2 Universal.

Table 3. Available manageprofiles parameters for configuration of Common database using DB2 Universal
Parameter
For custom profiles
-dbJDBCClasspath
-dbType
 
For stand-alone server or deployment manager profiles
-dbCommonForME (for stand-alone server profiles only)
-dbCreateNew
-dbDelayConfig
-dbDriverType
-dbHostName
-dbJDBCClasspath
-dbName
-dbOutputScriptDir
-dbPassword
-dbServerPort
-dbType
-dbUserId
-fileStoreForME (for stand-alone server profiles only)

On DB2 Universal Runtime Client

Table 4 shows the manageprofiles parameters available to configure the Common database used by a stand-alone server, deployment manager, or custom profile on DB2 Universal Runtime Client.

Table 4. Available manageprofiles parameters for configuration of Common database using DB2 Universal Runtime Client
Parameter
For custom profiles
-dbJDBCClasspath
-dbType
 
For stand-alone server or deployment manager profiles
-dbCommonForME (for stand-alone server profiles only)
-dbCreateNew
-dbDelayConfig
-dbJDBCClasspath
-dbName
-dbOutputScriptDir
-dbPassword
-dbType
-dbUserId
-fileStoreForME (for stand-alone server profiles only)

On DB2 UDB for iSeries (Native), DB2 UDB for iSeries (Toolbox), DB2 for i5/OS (Native), and DB2 for i5/OS (Toolbox)

Table 5 shows the manageprofiles parameters available to configure the Common database used by a stand-alone server, deployment manager, or custom profile on a database supplied with an i5/OS® operating system.

Table 5. Available manageprofiles parameters for configuration of Common database using a database supplied with an i5/OS operating system
Parameter
For custom profiles
-dbJDBCClasspath
-dbType
 
For stand-alone server or deployment manager profiles
-dbCommonForME (for stand-alone server profiles only)
-dbCreateNew
-dbDelayConfig
-dbHostName (for Toolbox driver, you need to specify the remote database host name)
-dbJDBCClasspath
-dbName
-dbOutputScriptDir
-dbPassword
-dbSchemaName
-dbType
-dbUserId
-fileStoreForME (for stand-alone server profiles only)

On DB2 for z/OS v8 and DB2 for z/OS v9

Table 6 shows the manageprofiles parameters available to configure the Common database used by a stand-alone server, deployment manager, or custom profile on DB2 for z/OS v8 or DB2 for z/OS v9.

Table 6. Available manageprofiles parameters for configuration of Common database using DB2 for z/OS v8 or DB2 for z/OS v9
Parameter
For custom profiles
-dbJDBCClasspath
-dbType
 
For stand-alone server or deployment manager profiles
-dbCommonForME (for stand-alone server profiles only)
-dbConnectionLocation
-dbCreateNew (must always be false)
-dbDelayConfig
-dbHostName
-dbJDBCClasspath
-dbName
-dbOutputScriptDir
-dbPassword
-dbSchemaName
-dbServerPort
-dbStorageGroup
-dbType
-dbUserId
-fileStoreForME (for stand-alone server profiles only)

On Oracle 9i, Oracle 10g, and Oracle 11g

Table 7 shows the manageprofiles parameters available to configure the Common database used by a stand-alone server, deployment manager, or custom profile on Oracle 9i, Oracle 10g, or Oracle 11g.

Table 7. Available manageprofiles parameters for configuration of Common database using Oracle 9i, Oracle 10g, or Oracle 11g
Parameter
For custom profiles
-dbJDBCClasspath
-dbType
 
For stand-alone server or deployment manager profiles
-dbCommonForME (for stand-alone server profiles only)
-dbCreateNew (must always be false)
-dbDelayConfig
-dbDriverType
-dbHostName
-dbJDBCClasspath
-dbName
-dbOutputScriptDir
-dbPassword
-dbServerPort
-dbType
-dbUserId
-fileStoreForME (for stand-alone server profiles only)

On Informix Dynamic Server

Table 8 shows the manageprofiles parameters available to configure the Common database used by a stand-alone server, deployment manager, or custom profile on Informix Dynamic Server.

Table 8. Available manageprofiles parameters for configuration of Common database using Informix Dynamic Server
Parameter
For custom profiles
-dbJDBCClasspath
-dbType
 
For stand-alone server or deployment manager profiles
-dbCommonForME (for stand-alone server profiles only)
-dbCreateNew
-dbDelayConfig
-dbHostName
-dbInstance
-dbJDBCClasspath
-dbLocation (only if -dbCreateNew is true)
-dbName
-dbOutputScriptDir
-dbPassword
-dbServerPort
-dbType
-dbUserId
-fileStoreForME (for stand-alone server profiles only)

On Microsoft SQL Server

Table 9 shows the manageprofiles parameters that are available to configure the Common database that is used by a stand-alone server, deployment manager, or custom profile on Microsoft® SQL Server. Three JDBC drivers are available for this database: DataDirect Connect JDBC (XA) 3.5 build 37 (type 4), IBM WebSphere embedded Connect JDBC (XA) 3.5 build 37 (type 4), and Microsoft SQL Server JDBC Driver, version 1.2. The driver names that are displayed on the Database Configuration page are Microsoft SQL Server (DataDirect), Microsoft SQL Server (Embedded), and Microsoft SQL Server (Microsoft), respectively.
Note: Support for the Microsoft SQL Server JDBC Driver, version 1.2 was added in WebSphere Process Server, version 6.2.0.1.
Table 9. Available manageprofiles parameters for configuration of Common database using Microsoft SQL Server.
Parameter
For custom profiles
-dbJDBCClasspath
-dbType
 
For stand-alone server or deployment manager profiles
-dbCommonForME (for stand-alone server profiles only)
-dbCreateNew
-dbDelayConfig
-dbHostName
-dbJDBCClasspath
-dbName
-dbOutputScriptDir
-dbPassword
-dbServerPort
-dbType
-dbUserId
-fileStoreForME (for stand-alone server profiles only)

concept Concept 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/cins_manageprofiles_parms_db.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).