Extract, Replicat, Logger and Syncfile create reports about group process parameters, run statistics, error messages, and other diagnostic information. These reports can be created with the SEND REPORT
command and viewed with the VIEW REPORT
command. The report is displayed to your screen. Use the scrolling commands below to scroll through the report.
Use SEND REPORT
when you want to narrow reporting to a specific span of time, or to retrieve statistics about the current transaction.
Syntax
SEND [EXTRACT | REPLICAT | SYNCFILE] group_name, REPORT [time_option [RESET | FILE name | TABLE name]]
group_name
The group name you defined with the appropriate GGSCI ADD
command
REPORT
time_option
[RESET
| FILE
name
| TABLE
name
Returns Extract and Replicat processing statistics based on the selected options.
RESET
This resets the time_option
counters to zero. For example, the command SEND
RECENT
RESET
will report the RECENT
counters and then reset them to zero.
FILE
name
| TABLE
name
This limits the display to statistics for the file or table specified in name
.
time_option
Each of these reports statistics for a different time interval as listed below. REPORT
is the default. TRANSACTION
is valid only for Replicat.
REPORT
: since the last time the REPORT
was run
TOTALS:
since the Extract or Replicat was started
DAILY
: since the beginning of the current day
HOURLY
: since the beginning of the current hour
RECENT
: since the last time the RECENT
counter was reset
TRANSACTION
: since the beginning of the current transaction
Examples
The following sample Extract report uses the default REPORT
option.
Report at 2010-02-27 12:43:07 (activity since 2010-02-27 11:43:44) Elapsed time 0-00:59:22.916658 Total # records written to \NODEA.$TEST04.GGSDAT.ET 19 \NODEA.$TEST04.GGSSOU.TCUSTMER # inserts: 3 # updates: 0 # deletes: 0 \NODEA.$TEST04.GGSSOU.TCUSTORD # inserts: 3 # updates: 13 # deletes: 0
The next sample Extract report uses the TOTALS
option.
Report at 2010-02-27 12:44:15 counters for TOTALS since 2010-02-24 10:23:34 Elapsed time 3-02:20:41.216310 Total # records written to \NODEA.$TEST04.GGSDAT.ET 68 \NODEA.$TEST04.GGSSOU.TCUSTMER # inserts: 11 # updates: 3 # deletes: 0 \NODEA.$TEST04.GGSSOU.TCUSTORD # inserts: 15 # updates: 34 # deletes: 5
The following Replicat report uses the TRANSACTION
option.
Report at 2010-02-28 06:51:15 counters for TRANS since 2010-02-14 13:46:54 Elapsed time 13-17:04:21.290242 From \A.$TEST04.GGSSOU.ECUSTMER to \A.$TEST04.GGSTAR.HCUSTMER: # inserts: 3 # updates: 1 # deletes: 0 # discards: 0 From \A.$TEST04.GGSSOU.ECUSTORD to \A.$TEST04.GGSTAR.HCUSTORD: # inserts: 3 # updates: 3 # deletes: 2 # discards: 0
VIEW REPORT
allows read-only viewing of reports. Reports are aged each time Extract or Replicat is started. For example, if the report file for an Extract group is normally GGSRPT.EXTCUST
, where EXTCUST
is the group name, the reports are aged to GGSRPT.EXTCUST0
, GGSRPT.EXTCUST1
, and so on. This lets you trace through previous runs for diagnostic information.