Kourier Integrator Online Help

KCL.BUILDINDEX

Syntax

KCL.BUILDINDEX FILE.NAME | * {(S}

Description

This program can be used to build the RDBMS level index that Kourier uses to track net change on UniData systems. This command is not necessary on UniVerse systems and for most applications that run on UniData.

For those applications on UniData that required all RDBMS indexes to be built you will only need to run this command when:

You turn on net change on a file for the first time.
You recreate Kourier’s net change indexes via the KT.SETUPNETCHG command.

Options

FILE.NAME	The name of application file or "*" to build indexes for all files that have net change enabled.
(S	An optional parameter that suppresses the "Are you sure prompt".

Cautions

This command should only be run during a system maintenance window since rebuilding indexes on a system where transactions are being processed may affect those transactions.

Usage

Example 1 – Building a Net Change Index for a single file.

>KCL.BUILDINDEX CUSTOMER

KCL.BUILDINDEX - 05 JUL 2018

This program will run BUILD.INDEX ON one or all of the Kourier net changes files.

!!! WARNING !!! WARNING !!! WARNING !!! WARNING

There are currently 2 users logged into the system. Doing file
maintenance with more than one active user may cause file corruption.

OK to Continue(Y,N=<CR>)? Y

CUSTOMER 

 BUILD.INDEX CUSTOMER KCL_INDEX started at 11:25:56.778 
 BUILD.INDEX CUSTOMER KCL_INDEX completed at 11:25:57.091
 
Files Read 1  Indexes Built:    1  Errors:    0 

 KCL.BUILDINDEX complete at 11:25:57 Jul 06 2018