Report commands

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.

return: Next page
/string: Search for next occurrence of string in file
number: Go to line indicated by number
l: Go to last page of file
b: Go backward one page in file
q: Quit display
h: Help

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 | 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

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.

Syntax

VIEW REPORT group_name[n] | file_name

group_name: The group name.
n: The sequence number of an aged report.
file_name: The fully qualified report file name. This is used when the report is not in the default location.