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:
The output can be filtered via the command line
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.