dbconfig command

Avaya Logo

dbconfig command

The dbconfig command administers the configuration of a JDBC database Data Interface Process (DIP).

Synopsis

dbconfig

Description

Use the dbconfig command to administer the configuration of any of the following database DIPs:

DBDIP1
DBDIP2
DBDIP3
DBDIP4
DBDIP5
Database CDH
File CDH

Any of the following functions can be administered for any of the database DIPs listed above:

List configuration – lists DIP configuration parameters
Add/change configuration – adds or changes DIP configuration parameters
Delete configuration – deletes DIP configuration parameters
Test configuration – tests a DIP configuration
Start/stop/restart DIP – starts, stops, or restarts a DIP

The following table describes the database DIP configuration parameters for all database types except Custom:

Parameter	Description
Database type	The type of database you want to use. Values: Oracle, Sybase, IBM DB2, Informix, Microsoft SQL Server, Custom Note: If you select Custom, the page displays different fields, which are described in the next table.
Database host name	The LAN host name for the server hosting the database. Values: Any string
Database name	The name of the database. Values: Any string
Database port	The LAN port monitored by the database DIP. Values: 1-65535
Database user name	The user name used to access the database. Values: Any string
Database password	The password used to access the database. Values: Any string
Connection pool size	The maximum anticipated number of concurrent JDBC connections that the IVR implementation will use. Values: 1-200

The following table describes the database DIP configuration parameters for the database type of Custom:

Parameter	Description
Database port	The LAN port monitored by the database DIP. Values: 1-65535
Database type	The type of database you want to use. Values: Oracle, Sybase, IBM DB2, Informix, Microsoft SQL Server, Custom
Database user name	The user name used to access the database. Values: Any string
Database password	The password used to access the database. Values: Any string
Classname	The Java classname for the driver, such as `com.microsoft.jdbc.sqlserver.SQLServerDriver`.
Database URL	Enter the URL that the IR system uses to connect to the database, such as `jdbc:microsoft:sqlserver://domain_name:1433;databaseName=yourdatabasename` where `domain_name` is the domain name for the MS SQL Server 2000 server, and `yourdatabasename` is the filename of the database. Values: Any string
Additional properties	Values: Any string
Connection Pool Size	The maximum anticipated number of concurrent JDBC connections that the IVR implementation will use. Values: 1-200
Database subtype	The database type that matches the JDBC drivers you are using. Values: Any string
Check connection SQL query	If you select any Database type besides Custom with a Database subtype of other, the default query displays. Accept the default by pressing the Enter key. If you select a Database type of Custom with a Database subtype of other, no default query displays. Enter a simple SQL query that will be used to test that the database connection is working properly when the database DIP is running. Values: Any string