Cisco Unified Contact Center Express Command Line Interface Reference Guide, Release 9.0(2)
Show Commands
Downloads: This chapterpdf (PDF - 1.29MB) The complete bookPDF (PDF - 2.57MB) | The complete bookePub (ePub - 251.0KB) | Feedback

Show Commands

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 EmailStatus

show 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-retention

show 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 output
admin: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_000674
admin:show cuic tech table ?
Syntax:
			show cuic tech table table_name
			table_name mandatory table name
admin: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_valuelist


show 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 cuic

show tech uccx_services

This command displays information on all the Unified CCX services that can run on the system.

Command Syntax :

show tech uccx_services

Options

None

Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

show tech uccx_services

show uccx version

This command displays the Unified CCX versions on the active partition and the inactive partition. The inactive version is displayed only if the inactive partition is available.

Command Syntax

show uccx version

Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

admin:show uccx version Active UCCX Version: 8.0.0.39000-151
 Inactive UCCX Version: NA
Command successful. 

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.

Command syntax

show uccx jtapi_client version

Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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.

Command syntax

show uccx components

Options

NA

Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

admin:show uccx componentsVarious UCCX components are as follows -

 UCCXEngine
 UCCXCVD
 UCCXEditor
 JTAPI_CLIENT
 UCCXAppAdmin 

show 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.

Command syntax:

show uccx subcomponents <component> [options]

Options

  • component—(mandatory) The component such as UCCXEngine or UCCXEditor.
  • page—Displays the output one page at a time

Requirements

Level privilege—0

Command privilege level—0

Allowed during upgrade—Yes

Example

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_MGR 

show 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.

Command syntax

show uccx license

Options

NA

Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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.

Command Syntax:

show uccx trace levels [options]

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

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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 provider ip axl

Shows the Unified CCX AXL provider IP address.

Command Syntax

show uccx provider ip axl

Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

admin: show uccx provider ip axl
Cisco Unified Communications Manager IP is 10.78.14.140

Command Successful.

show uccx provider ip jtapi

Shows the Unified CCX JTAPI provider IP address.

Command Syntax:

show uccx provider ip jtapi

Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

admin: show uccx provider ip jtapi
UCCX JTAPI Provider is 10.78.14.140

Command Successful.

show uccx provider ip rmcm

Shows the Unified CCX RmCm provider IP address.

Command Syntax

show uccx provider ip rmcm

Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

admin: show uccx provider ip rmcm
UCCX RMCM Provider is 10.78.14.140

Command Successful.

show uccx trace file size component size

Shows the trace file size for the specified component.

Command Syntax:

show uccx trace file size <component>

Arguments

  • component—Mandatory; The component such as UCCXEngine or UCCXEditor.

Requirements

Level privilege—1

Command privilege level—1

Allowed during upgrade—Yes

Example

admin: show uccx trace file size UCCXEngine
Trace file size for UCCXEngine is 3000000 bytes.

Command Successful.

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.

Command Syntax:

show uccx trace file count <component>

Arguments

  • component—Mandatory; The component such as UCCXEngine or UCCXEditor.

Requirements

Level privilege—1

Command privilege level—1

Allowed during upgrade—Yes

Example

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.

Command Syntax:

show uccx tech dbserver all


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.


Requirements

Level privilege—0

Command privilege level—0

Allowed during upgrade——Yes

Example

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.

Command Syntax

show uccx tech dbserver log diagnostic [options]

Arguments

NA

Options

  • page—displays the output one page at a time

Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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.

Command Syntax:

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

Level privilege—0

Command privilege level—0

Allowed during upgrade—Yes

Example

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.

Command Syntax

show uccx dbcontents database_name

Arguments:

  • database_name—mandatory; database whose contents will be output to csv

Requirements

Level privilege: 1

Command privilege level: 1

Allowed during upgrade: No

Example

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.

Command Syntax:

show uccx dbschema database_name

Arguments

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.


Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

admin:show uccx dbschema db_cra
Output is in file: uccx/cli/schema_db_cra_080212-110543.txt

show 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.

Command Syntax

show uccx dbtable list database_name [options]

Arguments

  • database_name—mandatory; database name where tables reside Options
  • page—displays the output one page at a time Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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

Command Syntax

show uccx dbtable schema database_name table_name [options]

Arguments

  • 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

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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).

Command Syntax

show uccx dbserver disk [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

Level privilege—0

Command privilege level—0

Allowed during upgrade—Yes

Example

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_dbs

show 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.

Command Syntax:

show uccx dbserver sessions all [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

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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 ASC

show 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.

Command Syntax

show uccx dbserver session session_id [options]

Arguments

  • session_id - mandatory; the Informix session ID number

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

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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.

Command Syntax:

show uccx dbserver sessions list [options]

Options

  • page - displays the output one page at a time

Requirements

Level privilege—0

Command privilege level—0

Allowed during upgrade—Yes

Example

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.

Command Syntax

show uccx dbserver user list [options]

Options

  • page - displays the output one page at a time Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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.

Command Syntax:

show uccx dbserver user waiting [options]

Options

  • page - displays the output one page at a time Requirements

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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.

Command Syntax:

show uccx tech dbserver log message [lines] [options]

Arguments:

  • 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

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

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.

Command Syntax:

show uccx dbtable contents database_name table_name [options]

Arguments:

  • 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

Level privilege: 0

Command privilege level: 0

Allowed during upgrade: Yes

Example

admin:show uccx dbtable contents db_cra resource Output is in file: uccx/cli/resource_Contents_1250666550481.csv

 Command successful.