Cisco Unified Contact Center Express Command Line Interface Reference Guide, Release 9.0(2) - High Availability Commands [Cisco Unified Contact Center Express]

Contents
High Availability Commands
show uccx dbreplication tables
show uccx dbreplication servers
utils uccx modify remote_IPAddress
utils uccx modify remote_hostname
utils uccx database forcedatasync
utils uccx dbreplication setup
utils uccx dbreplication status
utils uccx dbreplication templatestatus
utils uccx dbreplication repair
utils uccx dbreplication stop
utils uccx dbreplication start
utils uccx dbreplication reset
utils uccx dbreplication teardown
High Availability Commands
show uccx dbreplication tables
This command is only available in the High Availability deployment of Unified CCX. This commands list all the database tables which are involved in replication in the high availability deployment.

Command Syntax:

show uccx dbreplication tables [options]

Options

page - displays the output one page at a time

file - stores the output to a file and displays the filename Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example
admin:show uccx dbreplication tables This operation may take a few minutes to complete. Please wait...

CURRENTLY DEFINED REPLICATES
-------------------------------
REPLICATE:        template_db_cra_pshree_dactyl_sub_uccx_1_2_agentstatedetail
STATE:            Active ON:g_pshree_dactyl_pub_uccx
CONFLICT:         Timestamp
FREQUENCY:        immediate
QUEUE SIZE:       0
PARTICIPANT:      db_cra:informix.agentstatedetail
OPTIONS:          transaction,ris,ats,fullrow
REPLID:           131075 / 0x20003
REPLMODE:         PRIMARY  ON:g_pshree_dactyl_pub_uccx
APPLY-AS:         INFORMIX ON:g_pshree_dactyl_pub_uccx
REPLTYPE:         Master

.............
.............
.............

REPLICATE:        template_fcrassvr_pshree_dactyl_sub_uccx_3_3_fcrascalllogweek
STATE:            Active ON:g_pshree_dactyl_pub_uccx
CONFLICT:         Timestamp
FREQUENCY:        immediate
QUEUE SIZE:       0
PARTICIPANT:      fcrassvr:informix.fcrascalllogweek
OPTIONS:          transaction,ris,ats,fullrow
REPLID:           131104 / 0x20020
REPLMODE:         PRIMARY  ON:g_pshree_dactyl_pub_uccx
APPLY-AS:         INFORMIX ON:g_pshree_dactyl_pub_uccx
REPLTYPE:         Master

 Command successful.
admin:
show uccx dbreplication servers
This command is only available in the High Availability deployment of Unified CCX. This commands list all the database servers which are involved in replication in the high availability deployment and whether replication is still connected or if replication is broken.

Command Syntax:

show uccx dbreplication servers [options]

Options

page - displays the output one page at a time

file - stores the output to a file and displays the filename Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example
admin:show uccx dbreplication servers
SERVER                 ID STATE    STATUS     QUEUE  CONNECTION CHANGED
-----------------------------------------------------------------------
10.76.253.106        110 Active   Connected       0 Apr  7 22:01:19
10.76.253.107        100 Active   Local           0
utils uccx modify remote_IPAddress
This command is only available in the High Availability deployment of Unified CCX. This command updates IP Address of remote node in the server. Use this command during IP Address change of remote node.

Note

Use this command only when the IP Address of the other node is going to be changed.

Note

After you run this command, you must reboot the Unified CCX server and restart all the Unified CCX services. For more information on how ro restart the Unified CCX services, see the Cisco Unified CCX Serviceability Administration Guide available here:

Note

http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_installation_and_configuration_guides_list.html

Command Syntax

utils uccx modify remote_IPAddress <remote_server_old_ip_address> <remote_server_new_ip_address>

Arguments

remote_server_old_ip_address—Old IP address of the remote server

remote_server_new_ip_address—New IP address of the remote server Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
admin:utils uccx modify remote_IPAddress 10.76.253.82 10.76.253.83
 Old Remote IP Address: 10.76.253.82
 New Remote IP Address: 10.76.253.83

This command should be executed only in case you are changing IP Address of remote server.
Are you sure you want to run this command?
Continue (y/n)?y
 Command successful.
utils uccx modify remote_hostname
This command is only available in the High Availability deployment of Unified CCX. This command updates hostname of remote node in the server. Use this command during hostname change of remote node.

Note

Use this command only when the hostname of the other node is going to be changed.

Note

After you run this command, you must reboot the Unified CCX server and restart all the Unified CCX services. For more information on how ro restart the Unified CCX services, see the Cisco Unified CCX Serviceability Administration Guide available here:

Note

http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_installation_and_configuration_guides_list.html

Command Syntax

utils uccx modify remote_hostname < remote_server_old_hostname> <remote_server_new_hostname>

Arguments

remote_server_new_hostname—New hostname of the remote server

remote_server_old_hostname—Old hostname of the remote server Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
admin:utils uccx modify remote_hostname uccx-node-1 uccx-node-2
 Old Remote Hostname: uccx-node-1
 New Remote Hostname: uccx-node-2

This command should be executed only in case you are changing Host name of remote server.
 Are you sure you want to run this command?
Continue (y/n)?y
Command successful.
utils uccx database forcedatasync
This command gets the data from the other node in the cluster; effectively overwriting the data on this node.

Command Syntax:

utils uccx database forcedatasync

Arguments:

NA

Options

NA

Requirements

Level privilege: 1

Command privilege level: 0

Allowed during upgrade: No

Example
admin: utils uccx database forcedatasync
Are you sure you want to overwrite the local database? (y/n).
 Command successful.
utils uccx dbreplication setup
This command is only available in the High Availability deployment of Unified CCX. This command is used to setup the database replication. The command can be executed on any node and it will setup database replication in the cluster.

Command Syntax:

utils uccx dbreplication setup

Options

page - displays the output one page at a time Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
admin:utils uccx dbreplication setup
The DB replication for the UCCX cluster has been setup.
utils uccx dbreplication status
This command is only available in the High Availability deployment of Unified CCX. This command is used to check the Unfied CCX database replication status.

Command Syntax:

utils uccx dbreplication status

Options

None

Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
utils uccx dbreplication statusSERVER                 ID STATE    STATUS     QUEUE  CONNECTION CHANGED
-----------------------------------------------------------------------
g_alpha_ha_n1_uccx      1 Active   Connected       0 Aug  8 18:45:26
g_alpha_ha_n2_uccx      2 Active   Local           0


------------------------------------------------------------------
REPLICATE                                               STATE
------------------------------------------------------------------
db_cra:informix.agentconnectiondetail                   Active
db_cra:informix.contactcalldetail                       Active
db_cra:informix.contactroutingdetail                    Active
db_cra:informix.eememailstatusdescription               Active
db_cra:informix.eemreasoncodedescription                Active
db_cra:informix.eemcontactemaildetail                   Active
db_cra:informix.eememailagentstatedetail                Active
db_cra_repository:informix.promptsfoldertbl             Active
db_cra_repository:informix.promptsfiletbl               Active
db_cra_repository:informix.grammarsfiletbl              Active
db_cra_repository:informix.documentsfiletbl             Active
db_cra_repository:informix.sysgrammarsfiletbl           Active
db_cra_repository:informix.latestsynchedtime            Active
fcrassvr:informix.fcrascalllogweek                      Inactive
fcrassvr:informix.fcrasrecordlog                        Inactive
fcrassvr:informix.latestsynchedtime                     Inactive
db_cra:informix.agentstatedetail                        Active
db_cra_repository:informix.scriptsfiletbl               Active
fcrassvr:informix.fcrascalllogtoday                     Inactive
db_cra:informix.monitoredresourcedetail                 Active
db_cra:informix.latestsynchedtime                       Active
db_cra:informix.eemactiveemail                          Active
db_cra_repository:informix.grammarsfoldertbl            Active
db_cra_repository:informix.documentsfoldertbl           Active
db_cra_repository:informix.scriptsfoldertbl             Active
fcrassvr:informix.fcrasstatelogtoday                    Inactive
db_cra:informix.contactqueuedetail                      Active
db_cra:informix.remotemonitoringdetail                  Active
db_cra:informix.eemstatedescription                     Active
db_cra:informix.eemqueueagentdetail                     Active
db_cra_repository:informix.sysgrammarsfoldertbl         Active
------------------------------------------------------------------
utils uccx dbreplication templatestatus
This command is only available in the High Availability deployment of Unified CCX. This command is used to see the template status of the database replication.

Command Syntax:

utils uccx dbreplication templatestatus

Options

page - displays the output one page at a time Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
admin:utils uccx dbreplication templatestatus
The DB replication templatestatus is as follows.
utils uccx dbreplication repair
This command is only available in the High Availability deployment of Unified CCX. This command can be executed on any node. This command repairs mismatched data between cluster nodes; it does not repair replication setup. The command initiates the repair which executes in the background. The user would have to go to data store control centre in serviceability administration to monitor the status of the repair process. For more information, see the Cisco Unified CCX Serviceability Administration Guide available here:

http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_installation_and_configuration_guides_list.html

Command Syntax:

utils uccx dbreplication repair [database_name]|all

Arguments:

[database_name]|all - mandatory; database_name - which database to repair replication on. all - fix replication on all nodes. Options

page - displays the output one page at a time Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
admin:utils uccx dbreplication repair all
Repair has been initiated in the background...
Please go to Data Control Center in Serviceability Admin to monitor the status of the repair.
utils uccx dbreplication stop
This command is only available in the High Availability deployment of Unified CCX. This command is used to stop database replication. Run this command on any node to stop database replication in the entire cluster.

Command Syntax:

utils uccx dbreplication stop

Options

page - displays the output one page at a time Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
admin:utils uccx dbreplication stop
The DB replication for the UCCX cluster has been stopped.
utils uccx dbreplication start
This command is only available in the High Availability deployment of Unified CCX. This command is used to start the database replication. Run this command on any node to start database replication in the entire cluster.

Command Syntax:

utils uccx dbreplication start

Options

page - displays the output one page at a time Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
admin:utils uccx dbreplication start
The DB replication for the UCCX cluster has been started.
utils uccx dbreplication reset
This command is only available in the High Availability deployment of Unified CCX. This command is used to reset the database replication. Resetting replication involves the following activites, in the same order and is equivalent to the commands presented in parentheses.

Remove database replication (utils uccx dbreplication teardown)

Setup database replication (utils uccx dbreplication setup)

Initiate a data repair process for all the databases (utils uccx dbreplication repair all). Command Syntax:

utils uccx dbreplication reset

Options

page - displays the output one page at a time Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
admin:utils uccx dbreplication reset
The DB replication for the UCCX cluster has been reset.
utils uccx dbreplication teardown
This command is only available in the High Availability deployment of Unified CCX. This command is used to remove the database replication. Running this command on any node with the cluster will remove database replication between all nodes.

Command Syntax:

utils uccx dbreplication teardown

Options

page - displays the output one page at a time Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example
admin:utils uccx dbreplication teardown
The DB replication for the UCCX cluster has been teardown.