KCL.LISTLOG

Syntax

KCL.LISTLOG file.name | * {DET-SUPP}

Description

This program can be used to list the Kourier net change log for a file or all files accessible from the current account. A Kourier net change log contains an item-id for every record changed in the file since the last time the file was processed (i.e. exported). The detailed listing shows the following columns:

File Name	Indicates the name of the file where net change has been enabled.
Application	Indicates the applications (i.e. exports) that have net change enabled.
Processed	Indicates the number of records that have been processed (i.e. exported) by the application.
Pending	Indicates the number of records that have not been processed by the application.
Orphaned	Indicates that the application is no longer tracking net change but at least one record in the net change log was not processed by all applications when net change was disabled for that application.

The summary listing (e.g. specifying the DET-SUPP option) shows the following columns:

File Name	Indicates the name of the file where net change has been enabled.
Records	Indicates the number of records in the net log for all applications being tracked.

In most cases, the Kourier net change log will contain a very small fraction of the number of records in the primary file. However, if a large number of either pending or processed records exist on a consistent basis, it may indicated that:

Your application software writes all the records in the file to disk on a regular basis.
One or more exports are not running on a regular basis.
One or more exports have been orphaned.

In all cases, this may have a detrimental effect on the performance of net change exports and possibly the performance of you application software if the net change log is sized to small.

Options

file.name Enter the name of the file to list or an asterisk (*) to list all files where net change has been enabled.

DET-SUPP Indicates that only summary information should be displayed.

Example 1

In this example, all applications where net change has been enabled for the CUSTOMER file are listed.

>KCL.LISTLOG CUSTOMER

KCL.LISTLOG (Detail)

File Name................ Application......... Processed Pending. Orphaned

CUSTOMER                  MJD_CUSTOMER                 2        0
                          ODS_CUSTOMER                 0        2
                          ODS_CUSTOMER_SQL             0        2
                          TEST_CUSTOMER                2        0    *
                          TEST_NETNORECORD             0        2

1 records listed.

Example 2

In this example, all net change files in the current account are listed.

>KCL.LISTLOG *

PARTS KS45_BASE_PRICES 0 0
KS_BASE_PRICES 0 0

2 records listed.

Example 3

In this example, all net change files in the current account are listed in summary mode.

>KCL.LISTLOG * DET-SUPP

KCL.LISTLOG (Summary)

File Name................ Records.....

CUSTOMER 2
PARTS 0

2 records listed.