Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g cmsm Connection Manager information

The onstat -g cmsm command displays Connection Manager information. and replicate sets on each of the servers within the domain. If a replicated table is undergoing an alter operation, the onstat -g cat command shows that it is in alter mode. This command can be used to determine:

The example below is from onstat -g cac ed, most of the options have a similar format and detail the same information 

Unified Connection Manager: ucm1                     Hostname: frodo

CLUSTER         cluster1        LOCAL
        SLA                    Connections   Service/Protocol   Rule
        cm_primary1                      0     9050/onsoctcp   DBSERVERS=primary
        cm_sds1                          0     9051/onsoctcp   DBSERVERS=SDS
        cm_hdr1                          0     9052/onsoctcp   DBSERVERS=HDR
        cm_rss1                          0     9053/onsoctcp   DBSERVERS=RSS

        Failover Arbitrator: Active Arbitrator, Primary is up
        TIMEOUT=10 ORDER=SDS RETRY=1 PRIORITY=1

Unified Connection Manager: ucm2                     Hostname: frodo

CLUSTER         cluster1        LOCAL
        SLA                    Connections   Service/Protocol   Rule
        cm_primary2                      0     9060/onsoctcp   DBSERVERS=primary
        cm_sds2                          0     9061/onsoctcp   DBSERVERS=SDS
        cm_hdr2                          0     9062/onsoctcp   DBSERVERS=HDR
        cm_rss2                          0     9063/onsoctcp   DBSERVERS=RSS

        Failover Arbitrator: Active Arbitrator, Primary is up
        ORDER=SDS,HDR,RSS TIMEOUT=10 RETRY=1 PRIORITY=2

Output description

The output of the onstat -g cmsm command is divided into several sections. The first section displays the Connection Manager instance name and host name. The rest of the sections display service level agreements and failover configurations for each connection unit.

FieldDescription
Connection Manager Name The name of the Connection Manager instance.
Hostname The name of the host.
SLA The name of the service level agreement.
Connections The number of connections that are processed with the service level agreement.
Service/Protocol The port number or service name associated with the Service Level Agreement, followed by the protocol (onsoctcp, drsoctcp, onsocssl, drsocssl).
Rule The service level agreement definition which can include server types (Primary, SDS, RSS, HDR) or server names.
Failover Configuration
Connection Manager Name The name of the Connection Manager instance.
Rule The failover configuration.
Timeout The timeout value, in seconds, for the failover configuration.
State An indicator of the status of the primary server. Also indicates the Connection Manager instance serving as the failover arbitrator.

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.