KCL.LISTLOG

Syntax

KCL.LISTLOG file.name | *

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

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:

  1. Your application software writes all the records in the file to disk on a regular basis. 
  2. One or more exports are not running on a regular basis.
  3. 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. 

Example 1

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

>KCL.LISTLOG CUSTOMER

KCL.LISTLOG

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 *

KCL.LISTLOG

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

PARTS                     KS45_BASE_PRICES             0        0
                          KS_BASE_PRICES               0        0

2 records listed.

User Guide - Table of Contents