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_node1
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_node1, Or: 0x0002, off: 0, idle: 0, state Active
root Id: 00, forward Id: 00, ishub: FALSE, isleaf: FALSE
subtree map: <empty>
atsrisformat=text
Id: 02, Nm: g_node2, Or: 0x0004, off: 0, idle: 0, state Active
root Id: 00, forward Id: 02, ishub: FALSE, isleaf: FALSE
subtree map: <empty>
atsrisformat=text
</div>