onstat -g cat

Home | Previous Page | Next Page Appendix C. onstat Command Reference > onstat -g Command Summary >

onstat -g cat

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:

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 a given 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 acknowledgement.

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.

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