onstat -g cat: Print ER global catalog information

Prints information from the Enterprise Replication global catalog.


Modifier	Description
`replname`	The name of a replicate

Usage

The global catalog contains 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. 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 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.

You can set the scope of the output by specifying one of the following options to onstat -g cat:

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

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.

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

The following replicate information shows that the replicate belongs to a grid replicate set. UTF8 indicates that code set conversion between replicates is enabled.

Name: grid_6553604_100_3, Id: 6553605 State: ACTIVE Flags: 0x900000 UTF8 GRID   
        use 0 lastexec Wed Dec 31 18:00:00 1969

        Local Participant: tdb:nagaraju.t1
        Attributes: ROW scope, Enable RIS, all columns sent in updates
        Conflict resolution[Prim::Sec]: [ALWAYSAPPLY]
        Column Mapping: OFF
        Column Name Verifcation: ON
        No Replicated UDT Columns

This sample output from the onstat -g cat servers command shows that the server g_bombay and g_delhi are active; neither one is a hub or a leaf server, and both have ATS and RIS files that are generated in XML format.

GLOBAL-CATALOG CACHE STATISTICS

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

    Id: 100, Nm: g_delhi, Or: 0x0004, off: 0, idle: 0, state Active
      root Id: 00, forward Id: 100, ishub: FALSE, isleaf: FALSE
      subtree map: <empty>
      atsrisformat=xml