1.15 Report commands
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.
1.15.1 SEND 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 | FILEname
| TABLEname
]]
-
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 commandSEND
RECENT
RESET
will report theRECENT
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 theREPORT
was runTOTALS:
since the Extract or Replicat was startedDAILY
: since the beginning of the current dayHOURLY
: since the beginning of the current hourRECENT
: since the last time theRECENT
counter was resetTRANSACTION
: since the beginning of the current transaction
-
Examples
- Example 1
-
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
- Example 2
-
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
- Example 3
-
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
1.15.2 VIEW REPORT
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.