Feedback
Contents
- Show Commands
- show cuic component-status
- show cuic properties
- show cuic tech
- show cuic trace
- show tech uccx_services
- show uccx version
- show uccx jtapi_client version
- show uccx components
- show uccx subcomponents
- show uccx license
- show uccx trace levels
- show uccx provider ip axl
- show uccx provider ip jtapi
- show uccx provider ip rmcm
- show uccx trace file size component size
- show uccx trace file count component no-of-files
- show uccx tech dbserver all
- show uccx tech dbserver log diagnostic
- show uccx tech dbserver status
- show uccx dbcontents
- show uccx dbschema
- show uccx dbtable list
- show uccx dbtable schema
- show uccx dbserver disk
- show uccx dbserver sessions all
- show uccx dbserver session
- show uccx dbserver sessions list
- show uccx dbserver user list
- show uccx dbserver user waiting
- show uccx tech dbserver log message
- show uccx dbtable contents
Show Commands
show cuic component-status
These command show the status of the Unified CCX components. The Component name parameter is mandatory.
Command syntax
show cuic component-status [Component name]
Component name
- CuicStatus—shows status of cuic web engine and the DB replication
- DBRepStatus—shows status of database replication on this node
- DBStatus—shows the database status
- EmailStatus—shows status of the emailer component
- SchedulerStatus—shows status of the report scheduler
- DataSourceConnectionStatus—shows a data source connection status
Requirements
Level Privilege—0
Command Privilege Level—0
Allowed during Upgrade—No
Example
admin:show cuic component-status EmailStatusshow cuic properties
These commands show information about cuic properties.
Command syntax
show cuic properties [options]
Options
- purge-retention—number of days data is retained in the CUIC database before it is purged
- purge-time—time of day and the regular interval in minutes when the CUIC database will be purged
- session-timeout—session timeout for the CUIC web applications
- host-to-ip—current host-to-ip translation for the CUIC databases in the cluster
Requirements
Level Privilege—0
Command Privilege Level—0
Allowed during Upgrade—Yes
Example
admin:show cuic properties purge-retentionshow cuic tech
Command Syntax
show cuic tech procedures [options]
This command displays the stored procedures in use for the database.
show cuic tech systables [options]
This command displays the names of all the tables in the Unified IC database.
show cuic tech dbschema [options]
This command displays the database schema in a CSV file.
show cuic tech table table_name
The command shows the contents of a table on the Unified IC database.
show cuic tech triggers [options]
This command displays Unified IC table names and the triggers associated with those tables.
show cuic tech table cuicreport [options]
This command redirects the contents of the specified database table into a file.
Requirements
Level Privilege—1
Command Privilege Level—1
Allowed during Upgrade—No
Example
admin:show cuic tech dbschema ------------show cuic tech dbschema-------------- Database schema Output is in /cm/trace/dbi/dbSchema1331705967878.csv Use "file view activelog/cm/trace/dbi/dbSchema1331705867878.csv" command to see outputadmin:show cuic tech systables --------Show cuic tech system tables----------- SYSTEM TABLES tabname =================== GL_COLLATE GL_CTYPE VERSION cdr_deltab_000657 cdr_deltab_000658 cdr_deltab_000659 cdr_deltab_000660 cdr_deltab_000661 cdr_deltab_000662 cdr_deltab_000663 cdr_deltab_000664 cdr_deltab_000665 cdr_deltab_000666 cdr_deltab_000667 cdr_deltab_000668 cdr_deltab_000669 cdr_deltab_000670 cdr_deltab_000671 cdr_deltab_000672 cdr_deltab_000673 cdr_deltab_000674admin:show cuic tech table ? Syntax: show cuic tech table table_name table_name mandatory table nameadmin:show cuic tech triggers -------------show cuic tech triggers--------- Triggers tablename trigger =========================================== cuiccategory tr_del_category cuiccategory tr_ins_category cuiccategory tr_upd_category cuiccollection tr_del_collection cuiccollection tr_ins_collection cuiccollection tr_upd_collection cuicdashboard tr_del_dashboard cuicdashboard tr_ins_dashboard cuicdashboard tr_upd_dashboard cuicdatasource tr_del_datasource cuicdatasource tr_ins_datasource cuicdatasource tr_upd_datasource cuicreport tr_del_report cuicreport tr_ins_report cuicreport tr_upd_report cuicreportdefinition tr_del_reportdefinition cuicreportdefinition tr_ins_reportdefinition cuicreportdefinition tr_upd_reportdefinition cuicuser tr_upd_userdefaultgroup cuicvaluelist tr_del_valuelist cuicvaluelist tr_ins_valuelistshow cuic trace
These commands show the log level and trace masks of the given subsystem. If the logging level is set to DEBUG, the tracemask is displayed. if the logging level is set to INFO, the tracemasks are not displayed
The command is case-sensitive and can only be run on the Controller node.
To set traces on the member nodes, use the Operations Console command Device Management > Log And Trace Settings.
Command Syntax
show cuic trace cuicserver subsystem|CUIC
Options
- subsystem—reports the log level and the trace masks of the subsystem
- CUIC—reports the log level and the trace masks of CUIC
Requirements
Level Privilege—0
Command Privilege Level—0
Allowed during Upgrade—No
Example
show cuic trace cuicshow uccx version
show uccx jtapi_client version
This command displays the JTAPI client version that the Unified CCX is using on the active and the inactive partitions. The inactive version is displayed only if the inactive partition is available.
show uccx jtapi_client version
admin:show uccx jtapi_client version Active:Cisco JTAPI version 8.0(0.38000)-5 Release Inactive: NA Command successful.show uccx components
This command displays the various components in Unified CCX for which tracing can be turned on or off from CLI commands. This command is useful when you need the list of components to modify the trace settings of Unified CCX.
admin:show uccx componentsVarious UCCX components are as follows - UCCXEngine UCCXCVD UCCXEditor JTAPI_CLIENT UCCXAppAdminshow uccx subcomponents
This command displays the various subcomponents in specific Unified CCX component. This command is useful when you need the list of subcomponents to modify the trace settings of Unified CCX.
show uccx subcomponents <component> [options]
- component—(mandatory) The component such as UCCXEngine or UCCXEditor.
- page—Displays the output one page at a time
admin:show uccx subcomponents uccxengine
Various UCCX sub components for component 'UCCX_ENGINE' are as follows - APP_MGR ARCHIVE_MGR BOOTSTRAP_MGR CFG_MGR CHANNEL_MGRshow uccx license
This command displays various licenses configured for Unified CCX and the features which have been activated. This command will work only if the Unified CCX Cluster View Daemon (CVD) is running.
Note
License expiry information is not displayed by this command. To know more on viewing licenses, see Cisco Unified CCX Administration Guide.admin:show uccx licenseConfigured Licenses: Package: Cisco Unified CCX Premium IVR Port(s): 150 Cisco Unified CCX Premium Seat(s): 400 High Availability: Enabled Cisco Unified CCX Preview Outbound Dialer: Enabled Cisco Unified CCX Maximum Agents: 300 Command successful.show uccx trace levels
Displays the names and trace levels of the various Unified CCX components and sub-components. This command will *not* display the trace settings for Cisco Agent/Supervisor Desktop services (CAD/CSD). If the optional component is specified, then the trace settings of all the sub-components of the specified component will be displayed. If both the optional component and sub-component are specified, then the trace settings of the specified sub-component of the specified component will be displayed.
show uccx trace levels [options]
- Component—Displays the various trace levels of all the sub-components of this component.
- Sub-component—Displays the various trace levels of this sub-component for the specified component. This can be specified only if the component was specified.
- page—displays the output one page at a time
- file—stores the output to a file instead of showing it on the console. The name of the file will be displayed after the completion of the command. Requirements
admin:show uccx trace levels UCCXEngine SS_TEL Trace settings for component 'UCCX_ENGINE' and module 'SS_TEL' are ALARM = true DEBUGGING = false XDEBUGGING1 = false XDEBUGGING2 = false XDEBUGGING3 = false XDEBUGGING4 = false XDEBUGGING5 = false Command successful.show uccx trace file size component size
show uccx trace file count component no-of-files
This commands shows the trace file count for the specified component. which is the maximum number of trace files after which older files are overwritten.
show uccx trace file count <component>
Requirements
admin: show uccx trace file count UCCXEngine Trace file count for UCCXEngine is 300. Command Successful.show uccx tech dbserver all
Outputs the results of all of the show uccx tech **** commands to a text file. The user can view the file using the command file view activelog file-spec or can sftp the file out of the Unified Communications Operating System (UCOS) box using the command file get activelog file-spec [options]. Basically this command runs the commands show uccx tech dbserver log diagnostic and show uccx tech dbserver status in succession and stores the output of the commands in a file.
Note
The name of the file containing the output from each show uccx tech command run is automatically generated by the command script. The file path and file name are displayed upon completion.
admin:show uccx tech dbserver all This operation may take a few minutes to complete. Please wait... Output is in file: uccx/cli/DbServerAll_1250664874580.txt Command successful.show uccx tech dbserver log diagnostic
This command checks for the existence of Informix assertion failure and shared memory dump logs. If logs exist, the name and path of the log files is displayed.
show uccx tech dbserver log diagnostic [options]
admin:show uccx tech dbserver log diagnostic This operation may take a few minutes to complete. Please wait... The following diagnostic logs are available for the UC database server. core/log.txt core/gskit.log Command successful.show uccx tech dbserver status
Outputs a detailed status report of the Unified CCX database server (IDS engine) instance, i.e. onstat -a to a txt file.
show uccx tech dbserver status
Note
The name of the file is automatically generated by the command script. The file path and file name are displayed upon completion.
Requirements
admin:show uccx tech dbserver status This operation may take a few minutes to complete. Please wait... Output is in file: uccx/cli/DbServerStatus_1250666138379.txt Command successful.show uccx dbcontents
Dumps the contents of the specified database. This can be used to recreate a customer's database on a test system for troubleshooting. For each Unified CCX database table a dump csv file will be created. Since there would be huge number of files, these files will be created in a subdirectory which will have the name as DbContents_<TIMESTAMP>. After the completion of the command the subdirectory name and subdirectory path will be displayed.
show uccx dbcontents database_name
admin:show uccx dbcontents db_cra This operation may take a few minutes to complete. Please wait... Database contents dump is in directory: uccx/cli/DbContents_1250666234370 Command successful.show uccx dbschema
Outputs the schema for all the tables, views and stored procedures in the specified database to a text file. The output consists of SQL statements that are necessary to replicate a specified database. The IDS "dbschema" utility is used to create the file. This command will only display the DB schema, it will not provide any data in the tables.
show uccx dbschema database_name
database_name—mandatory; name of the database whose schema will be output
Note
The name of the file containing the schema is automatically generated by the command script. The file path and file name are displayed upon completion.
admin:show uccx dbschema db_cra Output is in file: uccx/cli/schema_db_cra_080212-110543.txtshow uccx dbtable list
Displays the names of all the tables contained in the specified Unified CCX IDS database. The database names can be db_cra, db_cra_repository, FCRasSvr, sysmaster.
show uccx dbtable list database_name [options]
- database_name—mandatory; database name where tables reside Options
- page—displays the output one page at a time Requirements
admin:show uccx dbtable list db_craList of tables in database 'db_cra' is - agentconnectiondetail agentroutingsetting agentstatedetail application areacode campaign campaigncsqmap configlog configschema configschemacolumn configseed … … teamcsqmapping workflowtask Command successful.show uccx dbtable schema
Displays the column names of the specified table
show uccx dbtable schema database_name table_name [options]
- database_name - mandatory; name of the database (db_cra, db_cra_repository etc.,) in which the table resides
- table_name - mandatory, name of the table Options
- page—displays the output one page at a time Requirements
admin:show uccx dbtable schema db_cra_repository documentsfiletblList of columns in table 'documentsfiletbl' in database 'db_cra_repository' is - filename (nvarchar) parentfolderid (nvarchar) payload (blob) lastmodifystamp (datetime year to fraction(3)) lastmodifyuser (nvarchar) length (int) checksum (int) Command successful.show uccx dbserver disk
Displays information for each storage space (chunks and dbspaces).
show uccx dbserver disk [options]
- page - displays the output one page at a time
- file - outputs the information to a txt file. The file name will be generated dynamically at runtime and the file name and path will be displayed to user after the completion of the operation.
Requirements
admin:show uccx dbserver diskSNO. DATABASE NAME TOTAL SIZE (MB) USED SIZE (MB) FREE SIZE (MB) PERCENT FREE ---- ------------------ --------------- -------------- -------------- ------------ 1 rootdbs 358.4 66.3 292.1 81% 2 log_dbs 317.4 307.3 10.1 3% 3 db_cra 512.0 8.8 503.2 98% 4 db_hist 13000.0 3651.4 9348.6 71% 5 db_cra_repository 10.2 2.9 7.3 71% 6 db_frascal 512.0 2.8 509.2 99% 7 temp_uccx 1572.9 0.1 1572.7 99% 8 uccx_sbspace 3145.7 2988.1 157.6 5% 9 uccx_er 204.8 0.1 204.7 99% 10 uccx_ersb 1572.9 1494.1 78.8 5% CHUNK NO. OFFSET TOTAL SIZE (MB) FREE SIZE (MB) FILENAME --------- ------ --------------- -------------- --------------------------------------------- 1 0 358.4 292.1 /var/opt/cisco/uccx/db/root_uccx_dbs 2 0 317.4 10.1 /var/opt/cisco/uccx/db/log_dbs 3 0 512.0 503.2 /var/opt/cisco/uccx/db/db_cra_dbs 4 0 13000.0 9348.6 /common/var-uccx/dbc/db_hist_dbs 5 0 10.2 7.3 /var/opt/cisco/uccx/db/db_cra_repository_dbs 6 0 512.0 509.2 /var/opt/cisco/uccx/db/db_frascal_dbs 7 0 1572.9 1572.8 /common/var-uccx/dbc/temp_uccx_dbs 8 0 3145.7 157.6 /var/opt/cisco/uccx/db/uccx_sbspace_dbs 9 0 204.8 204.7 /common/var-uccx/dbc/uccx_er_dbs 10 0 1572.9 78.8 /common/var-uccx/dbc/uccx_ersb_dbsshow uccx dbserver sessions all
Displays detailed session and SQL-related information for each database user session. The content of the information displayed is equivalent to running the IDS command onstat -g ses for each active session.
show uccx dbserver sessions all [options]
- page - displays the output one page at a time
- file - outputs the information to a txt file. The file name will be generated dynamically at runtime and the file name and path will be displayed to user after the completion of the operation. Requirements
admin:show uccx dbserver sessions allIBM Informix Dynamic Server Version 10.00.UC5XD -- On-Line -- Up 58 days 02:26:37 -- 444676 Kbytes session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 27 cudbeven - 6750 crslnx 1 151552 75400 off tid name rstcb flags curstk status 75 sqlexec 52477164 Y--P--- 4208 cond wait(netnorm) Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 27 V 5309a020 147456 73704 148 50 27*O0 V 5442f020 4096 2448 1 1 name free used name free used overhead 0 3296 scb 0 96 opentable 0 6456 filetable 0 1088 sqscb info scb sqscb optofc pdqpriority sqlstats optcompind directives 52fda4d0 53234018 0 0 0 0 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 27 - uccxdirdb CR Wait 30 0 0 9.03 Off Last parsed SQL statement : SELECT FIRST 100 *, CAST(Timestamp AS varchar(32)) AS strTimestamp, CAST(Object_Id AS varchar(64)) AS strObject_Id FROM UccxDb: DbChangeEventQ WHERE EventId > ? ORDER BY EventId ASCshow uccx dbserver session
Displays detailed session and SQL-related information for a specific session, which represents a user connected to the database server. The content of the information displayed is equivalent to running the IDS command onstat -g ses for an active session specified by the session-id.
show uccx dbserver session session_id [options]
Options
- page—displays the output one page at a time.
- file—outputs the information to a txt file. The file name will be generated dynamically at runtime and the file name and path will be displayed to user after the completion of the operation.
Requirements
admin:show uccx dbserver session 58IBM Informix Dynamic Server Version 11.50.UC4 -- On-Line -- Up 14 days 04:43:40 -- 254160 Kbytes session effective #RSAM total used dynamic id user user tty pid hostname threads memory memory explain 58 uccxuser - - -1 sakkumar 1 126976 107496 off tid name rstcb flags curstk status 93 sqlexec 4b2deca0 Y--P--- 5680 cond wait netnorm - Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 58 V 4caa9028 122880 17064 332 18 58*O0 V 4c9d0028 4096 2416 1 1 name free used name free used overhead 0 3360 scb 0 96 opentable 0 8344 filetable 0 1104 ru 0 464 log 0 16512 temprec 0 21600 keys 0 1392 ralloc 0 5120 gentcb 0 1240 ostcb 0 2600 sqscb 0 29384 sql 0 40 rdahead 0 848 hashfiletab 0 280 osenv 0 1552 sqtcb 0 7464 fragman 0 368 GenPg 0 592 udr 0 5136 sqscb info scb sqscb optofc pdqpriority sqlstats optcompind directives 4c907018 4cc92018 1 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 58 - db_cra LC Not Wait 0 0 9.28 Off Last parsed SQL statement : select campaignen0_.campaignID as campaignID3_, campaignen0_.profileID as profileID3_, campaignen0_.recordID as recordID3_, campaignen0_.active as active3_, campaignen0_.ansMachineRetry as ansMachi5_3_, campaignen0_.cacheSize as cacheSize3_, campaignen0_.callbackTimeLimit as callback7_3_, campaignen0_.campaignName as campaign8_3_, campaignen0_.createDateTime as createDa9_3_, campaignen0_.dateInactive as dateIna10_3_, campaignen0_.description as descrip11_3_, campaignen0_.enabled as enabled3_, campaignen0_.endTime as endTime3_, campaignen0_.maxAttempts as maxAtte14_3_, campaignen0_.missedCallbackAction as missedC15_3_, campaignen0_.privateData as private16_3_, campaignen0_.startTime as startTime3_ from Campaign campaignen0_ where campaignen0_.active=? Command successful.show uccx dbserver sessions list
Displays a one-line summary of each active Unified CCX database session. The summary includes the database name, username, session id and process id. The session ID information can be used to display more detailed information about a specified session using the show uccx dbserver session command.
show uccx dbserver sessions list [options]
Requirements
admin:show uccx dbserver sessions listDATABASE USERNAME SESSION PROCESS ID ------------------ ------------ ------- ---------- db_cra uccxcaduser 64 9395 db_cra uccxuser 49 -1 db_cra uccxuser 44 -1 db_cra uccxuser 46 -1 db_cra uccxuser 61 -1 db_cra uccxuser 24 -1 db_cra uccxuser 18 -1 db_cra uccxhruser 31224 -1 db_cra uccxuser 62 -1 db_cra uccxuser 60 -1 db_cra uccxuser 47 -1 db_cra uccxuser 59 -1 db_cra uccxuser 58 -1 db_cra uccxuser 48 -1 db_cra uccxuser 50 -1 db_cra uccxcliuser 31616 -1 Command successful.show uccx dbserver user list
Displays a one-line summary of each active Unified CCX database user. The summary includes the database name, session id and process id. The session ID information can be used to display more detailed information about a specified user session using the "show uccx dbserver session" command.
show uccx dbserver user list [options]
admin:show uccx dbserver user listDATABASE USERNAME SESSION PROCESS ID ------------------ ------------ ------- ---------- sysadmin informix 15 0 sysadmin informix 16 0 sysadmin informix 17 0 sysmaster uccxuser 18 -1 db_cra uccxuser 18 -1 sysmaster uccxuser 24 -1 db_cra uccxuser 24 -1 db_cra_repository uccxuser 25 -1 sysmaster uccxuser 25 -1 fcrassvr uccxuser 26 -1 sysmaster uccxuser 26 -1 sysmaster uccxuser 44 -1 db_cra uccxuser 44 -1 db_cra_repository uccxuser 45 -1 sysmaster uccxuser 46 -1 db_cra uccxuser 46 -1 sysmaster uccxuser 47 -1 db_cra uccxuser 47 -1 db_cra uccxuser 48 -1 sysmaster uccxuser 48 -1 sysmaster uccxuser 49 -1 Command successful.show uccx dbserver user waiting
This command displays a one-line summary of each Unified CCX database user and will display whether a user session is waiting for a resource.
show uccx dbserver user waiting [options]
admin:show uccx dbserver user waitingUSERNAME SESSION ID LATCH LOCK BUFFER CHECKPOINT TRANSACTION INCRITICAL ------------ ---------- ----- ---- ------ ---------- ----------- ---------- informix 16 N N N N N N informix 17 N N N N N N informix 15 N N N N N N uccxcaduser 63 N N N N N N uccxcaduser 64 N N N N N N uccxcliuser 33927 N N N N N N uccxcliuser 32784 N N N N N N uccxcliuser 32737 N N N N N N uccxcliuser 32631 N N N N N N uccxcliuser 34424 N N N N N N uccxcliuser 32522 N N N N N N uccxcliuser 34364 N N N N N N uccxcliuser 32508 N N N N N N uccxcliuser 32480 N N N N N N uccxcliuser 31616 N N N N N N uccxcliuser 31601 N N N N N N uccxcliuser 34327 N N N N N N uccxcliuser 34071 N N N N N N uccxcliuser 33981 N N N N N N uccxcliuser 33939 N N N N N N uccxhruser 31224 N N N N N N uccxuser 30278 N N N N N N uccxuser 60 N N N N N N Command successful.show uccx tech dbserver log message
Displays the most recent messages in the Informix message log. The number of messages displayed is determined by the lines parameter.
show uccx tech dbserver log message [lines] [options]
- lines - optional; number of lines from message log that will be displayed. Defaults to 20. Options
- page - displays the output one page at a time Requirements
admin:show uccx tech dbserver log message 10Message Log File: online.uccx.log The last 10 lines of the log file are - 16:05:19 Maximum server connections 33 16:05:19 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 21, Llog used 12 16:10:19 Checkpoint Completed: duration was 0 seconds. 16:10:19 Wed Aug 19 - loguniq 8, logpos 0x93c018, timestamp: 0xb0244c Interval: 4106 16:10:19 Maximum server connections 33 16:10:19 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2 Command successful.show uccx dbtable contents
Displays the contents of the specified table.
show uccx dbtable contents database_name table_name [options]
- database_name - mandatory; name of the database (db_cra, db_cra_repository etc.,) in which the table resides
- table_name - mandatory, name of the table Options
- page - displays the output one page at a time Requirements
admin:show uccx dbtable contents db_cra resource Output is in file: uccx/cli/resource_Contents_1250666550481.csv Command successful.
