KCL.LISTLOG

This program can be used to list the Kourier net change log for a file or all files accessible from the current account or the remote account specified after the FROM keyword. 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:

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

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 indicate that:

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

Options

Usage

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

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.
PHYSICAL SIZE	The total number of bytes being used to store net change tracking information for a file.
DESIGN SIZE	The total number of bytes initially allocated to store net change tracking information.
RATIO	The ratio between the Physical Size and the Design Size of the space allocated to store net change tracking information. If this ratio is greater than 2 or 3 you should consider resizing this file. See KCL.RESIZELOG.

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.
FROM	Indicates that the Kourier net change log in the account name (UniVerse) or an account path name (UniData) should be used to create the listing. This option is only valid when all files are listed.

KCL.LISTLOG

Syntax

Description

Options

Usage