4

The following example shows output for the onstat -g 4sync command.

4

IBM Informix Dynamic Server Version 10.00.U --On-Line-- Up 00:10:16 -- 44084 Kbytes
4Prim   Sync   St.  Shadow Flag Stat Block  EndBlk
4Repl   Source      Repl             Num    Num
4
4655361 20     0    1310729 2    0    592    600

4Output Description 4

4

4

Prim Repl

4

Replicate number of the replicate being synchronized 4

4

Sync Source

4

Source server of the sync 4

4

St

4

Sync replicate state 4

4

Shadow Repl

4

The shadow replicate used to perform the sync 4

4

Flag

4

Internal flags: 4

4
• 0x02 = external sync
4
• 0x04 = shutdown request has been issued
4
• 0x08 = abort has occurred
4
• 0x010 = a replicate stop has been requested
4
• 0X020 = shadow or primary replicate has been deleted

4

4

Stat

4

Resync job state 4

4

Block num

4

Last block applied on targets (on source always 0) 4

4

EndBlock Num

4

Last block in resync process. Marks the end of the sync scan on the 4target. A value of' -2 indicates that the scan is still in progress, and the 4highest block number is not yet known. 4

4

4

Additional fields for forwarded rows:

4

4

ServID

4

Server where forwarded row originated 4

4

fwdLog ID

4

Originator's log ID of the forwarded row 4

4

fwdLog POS

4

Originator's log position of the forwarded row 4

4

endLog ID

4

Operation switches back to normal at this point 4

4

endLog POS

4

Operation switches back to normal at this log position 4

4

complete flag

4

Set to 1 after normal processing resumes for the originating source 4

4