| |
Command or Action
|
Purpose
|
Step 1
|
config t
Example:
se-10-0-0-0# config t
|
Enters global configuration mode.
|
Step 2
|
ccn subsystem edbs dbprofile dbprofilename
If a new database profile is being added, the following message appears on the console before going into database profile command mode:
Adding new Database profile
If a database profile already exists, the
following message appears on the console:
Modifying existing Database profile
Example:
se-10-0-0-0(config)# ccn subsystem edbs
dbprofile myDBProfile
Adding new Database profile
se-10-0-0-0(config-dbprof)>
|
Creates a new database profile and enters EDBS profile configuration mode. Use the no form of this command to remove a database profile.
|
Step 3
|
dbtype {DB2 | MSSQL-MSDE | ORACLE | SYBASE}
Example:
se-10-0-0-0(config-dbprof)# dbtype Oracle
|
Specifies the required database type:
• DB2: IBM underlying database system.
•MSSQL-MSDE: Microsoft SQL or Microsoft Database Engine underlying database system.
•ORACLE: Oracle underlying database system.
•SYBASE: Sybase underlying database system.
|
Step 4
|
db-username userid
and
db-password password
Example:
se-10-0-0-0(config-dbprof)# db-username james
se-10-0-0-0(config-dbprof)# db-password
dbpasswd
|
Specifies the db-username and db-password authentication options to connect to the database. Use the no form of this command to remove the specified username and password strings.
|
Step 5
|
credentials hidden credential-string
Example:
se-10-0-0-0(config-dbprof)# credentials
hidden James_dbpasswd
|
Specifies the command option to specify the username and password authentication in encrypted form to connect to the database
•Use the no form of this command to remove the specified credential string.
|
Step 6
|
dbname external-db-name
Example:
se-10-0-0-0(config-dbprof)# dbname atlanta
|
Specifies the dbname option to specify an external database name. If the name is specified, it connects to the named external database. Use the no form of this command to remove this configuration.
Note Some database documentation refers to dbname as Data Source Name (DSN).
|
Step 7
|
db-hostname {ip-address | hostname}
Example:
se-10-0-0-0(config-dbprof)# db-hostname
myHost
|
Specifies the database server IP address or DNS hostname. Use the no and default form of this command to remove this configuration.
Note If using a DNS hostname for the external database instead of an IP address, the DNS server must be configured before entering the DNS hostname.
|
Step 8
|
db-port port-number
Example:
se-10-0-0-0(config-dbprof)# db-port 10
|
(Optional) Specifies a port number other than the default port number of the database. Although databases are typically started using their default port numbers, the default port number might be changed to a different port number.
•Use the no form of this command to remove this configuration.
•The default port number varies depending on the underlying database. For example, the default port number is 1433 for the MSSQL and MSDE databases; the default port number is 1521 for the Oracle database,
|
Step 9
|
maxactive maximum-active-connections
Example:
se-10-0-0-0(config-dbprof)# maxactive 8
|
Specifies the maximum number of concurrent active connections to the external database.
•Connection requests made after the maximum limit is reached cause connection failures. The maximum value, which is also the default value, that can be specified is typically twice the number of licensed IVR sessions.
•Use the no and default form of this command to set the maximum number of concurrent active connections allowed to the default value.
•The default for maxactive is twice the value of max_ivr_port for the Cisco Unity Express module.
|
Step 10
|
parameter name value
Example:
se-10-0-0-0(config-dbprof)# parameter
*headerchar *continuation
|
(Optional) Specifies the JDBC driver-specific name-value pair. The name-value pair must match the requirements of the JDBC driver.
•Each JDBC driver can have a different set of customized parameters.
•Use this command multiple times to set multiple driver properties.
•Use the no and default form of this command to remove this configuration.
Note Use this command with caution. Its value impacts the way the module connects to the database. Consult with your database administrator before using this command. Unless you have a specific need, do not use this command.
|
Step 11
|
enabled
Example:
se-10-0-0-0(config-dbprof)# enabled
|
Enables the external database profile for use in running the database steps of a database script.
•Use the no form of this command to disable the database profile.
•Use the default form of this command to enable the profile.
|
Step 12
|
default {credentials | dbname | dbtype |
description | enabled | db-hostname | maxactive |
parameter | db-password | db-port | db-username}
Example:
se-10-0-0-0# config t
se-10-0-0-0(config)# ccn subsystem edbs
dbprofile mydbprofile
Adding new Database profile
se-10-0-0-0(config-dbprof)# default
credentials
se-10-0-0-0(config-dbprof)# default dbname
se-10-0-0-0(config-dbprof)# default dbtype
se-10-0-0-0(config-dbprof)# default
description cue_hostname
se-10-0-0-0(config-dbprof)# default enabled
se-10-0-0-0(config-dbprof)# default
db-hostname local
se-10-0-0-0(config-dbprof)# default maxactive
se-10-0-0-0(config-dbprof)# default parameter
se-10-0-0-0(config-dbprof)# default
db-password
se-10-0-0-0(config-dbprof)# default db-port
se-10-0-0-0(config-dbprof)# default
db-username
se-10-0-0-0(config-dbprof)# end
se-10-0-0-0(config)# exit
|
Reset the IVR EDBS values to their default values in Cisco Unity Express IVR database profile configuration mode:
•credentials: Has no effect on the IVR EDBS database.
•dbname: No database name is configured.
•dbtype: No database type is configured.
•description: No description for the database profile is specified.
•enabled: Enables the IVR EDBS. Use the no form of the command to disable the EDBS.
•db-hostname: No external database hostname is specified.
•maxactive: Sets the maximum value to twice the number of licensed IVR sessions.
•parameter: No parameter name-value pair is configured.
•db-password: Sets the IVR EDBS password to an empty string.
•db-port: No specific port number is specified. It uses the database default port number based on dbtype.
•db-username: Sets the IVR EDBS username to an empty string.
|
Step 13
|
end
Example:
se-10-0-0-0(config-dbprof)# end
|
Saves and exits EDBS database profile configuration mode.
Note Changes are not saved unless the end command is used.
|
Step 14
|
exit
Example:
se-10-0-0-0(config)# exit
|
Exits global configuration mode.
|
Step 15
|
show ccn subsystem edbs dbprofile {profilname
| all}
Example:
se-10-0-0-0# show ccn subsystem edbs
dbprofile profilname
|
Displays EDBS database subsystem parameters. If a profile name is not specified, all database profiles are visible.
|
