Oninit Logo
The Down System Specialists
+1-913-732-8892
+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 cat ER Global Catalog

The onstat -g cat command displays a summary of information about the defined servers, replicates, 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:

  • How many servers and how many replicates are configured
  • Which table matches a given replicate
  • Whether a server is a root or leaf server
  • The current bitmap mask for the specified server. You can use the bitmap mask with the output from the onstat -g rqm command to determine which server Enterprise Replication is waiting on for an acknowledgment.

The output can be filtered via the command line

  • full: (Default) Prints expanded information for both replicate servers and replicates.
  • servers: Prints information about servers only.
  • replname: Prints information about the specified replicate only.
  • repls: Prints information about replicates only. 


onstat -g cat repls

GLOBAL-CATALOG CACHE STATISTICS

REPLICATES
-------------------
  Parsed statements:
          Id 131073 table t9880wip
          Id 131074 table t9800dbaudit
          Id 131077 table t9810dbname_001
....
....
 Inuse databases: dbaudit(45)
    Name: repl_dbaudit_t9840stats_005, Id: 131132 State: 
             ACTIVE Flags: 0x40800000 FLOATIEEE   use 0 lastexec Wed Dec 31 18:00:00 1969

        Local Participant: dbaudit:informix.t9840stats_005
        Attributes: TXN scope, Enable ATS, Enable RIS, all columns sent in updates
        Conflict resolution[Prim::Sec]: [IGNORE]
        Column Mapping: ON, columns INORDER, offset 8, uncomp_len 104
        Column Name Verifcation: ON
        No Replicated UDT Columns



    Name: repl_dbaudit_t9840stats_006, Id: 131157 State: 
             ACTIVE Flags: 0x40800000 FLOATIEEE   use 0 lastexec Wed Dec 31 18:00:00 1969

        Local Participant: dbaudit:informix.t9840stats_006
        Attributes: TXN scope, Enable ATS, Enable RIS, all columns sent in updates
        Conflict resolution[Prim::Sec]: [IGNORE]
        Column Mapping: ON, columns INORDER, offset 8, uncomp_len 104
        Column Name Verifcation: ON
        No Replicated UDT Columns


onstat -g cat servers

GLOBAL-CATALOG CACHE STATISTICS


SERVERS
-------------------
  Current server  : Id 1, Nm g_theoden
  Last server slot: (0, 2)
  # free slots    : 0
  Broadcast map   : <[0005]>
  Leaf server map : <[0000]>
  Root server map : <[0006]>
  Adjacent server map: <[0004]>
    Id: 01, Nm: g_theoden, Or: 0x0002, off: 0, idle: 0, state Active
      root Id: 00, forward Id: 00, ishub: FALSE, isleaf: FALSE
      subtree map: 
      atsrisformat=text

    Id: 02, Nm: g_gimli, Or: 0x0004, off: 0, idle: 0, state Active
      root Id: 00, forward Id: 02, ishub: FALSE, isleaf: FALSE
      subtree map: 
      atsrisformat=text

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