The onstat -g cat command prints information from the Enterprise Replication global catalog. The global catalog contains a summary of information about the defined servers, replicates, and replicate sets on each of the servers within the enterprise. If a replicated table is undergoing an alter operation, the onstat -g cat command shows that it is in alter mode. For example, use this command to determine:
The onstat -g cat command has the following formats:
onstat -g cat onstat -g cat scope onstat -g cat replname
The following table describes replname and scope.
| Modifier | Description |
|
replname |
The name of a replicate |
|
scope |
One of the following values:
servers—Print information on servers only repls—Print information on replicates only full—Print expanded information for both replicate servers and replicates |
This sample output from the onstat -g cat repls command shows that the table tab is in alter mode. The replicate rep1 is defined on this table, its replicate ID is 6553601. For more information on the replicate attributes that this command displays, see the IBM Informix Dynamic Server Enterprise Replication Guide.
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 00:01:39 -- 28672 Kbytes
GLOBAL-CATALOG CACHE STATISTICS
REPLICATES
-------------------
Parsed statements:
Id 6553601 table tab
Id 6553602 table tab12
Inuse databases: test(2)
Name: rep1, Id: 6553601 State: ACTIVE Flags: 0x800000 ALTERMODE
use 0 lastexec Wed Dec 31 18:00:00 1969
Local Participant: test:nagaraju.tab
Attributes: TXN scope, Enable ATS, Enable RIS, all columns
sent in updates
Conflict resolution: [TIMESTAMP]
Column Mapping: ON, columns INORDER, offset 8, uncomp_len 12
Column Name Verifcation: ON
No Replicated UDT Columns
Name: rep12, Id: 6553602 State: ACTIVE Flags: 0x800000 use 0
lastexec Wed Dec 31 18:00:00 1969
Local Participant: test:nagaraju.tab12
Attributes: TXN scope, Enable ATS, Enable RIS, all columns
sent in updates
Conflict resolution: [TIMESTAMP]
Column Mapping: ON, columns INORDER, offset 8, uncomp_len 2064
Column Name Verifcation: ON
No Replicated UDT Columns