Chkind behaviour

Post Reply
source1Tamer
Posts: 91
Joined: Tue Nov 13, 2001 3:49 pm

Chkind behaviour

Post by source1Tamer »

I have a problem with CHKIND/SYSMETAINDEX table,
I'm doing a batch of updates, CHKIND is turned on, but SYSMETAINDEX = 1 in texis.cnf file.so I update the metamorph index manually at the end of the batch.
Here is a snippet of Texis.cnf:

[Chkind] ; --------------------- Check-Index settings ---------------------

; How often to check for tables that need to be checked.

;Refresh = 4

; Only check indexes in SYSMETAINDEX

;SYSMETAINDEX = 1

; Automatically invoke chkind if 1. Set to 0 if you're doing manual index
; updates, ie. after a batch table update:

;Automatic = 1
-------------------------------------------------

I have no records in the SYSMETAINDEX table for that db directory.
The script is doing 3 steps:
step 1: delete some records from the table.
step 2: insert some records to the table.
step 3: Update the metamorph index.

But I've noticed that during the processing of step2, there is an index in SYSINDEX table with the same name as the manual metamorph index, with a temporary FNAME "T02612a"
also, there is another few files being updated called "T02612b.btr" ,"T02612b.dat", "T02612c.btr" and "T02612c.dat".

When the script reaches step3, it returns an error:
*Index E:\IncBuild\mainlocation\T02612a appears to be being updated*

any reasons why chkind is still insisting to refresh the index? should I set ;Automatic = 0 in the CNF file?
User avatar
Kai
Site Admin
Posts: 1272
Joined: Tue Apr 25, 2000 1:27 pm

Chkind behaviour

Post by Kai »

A semicolon or pound sign introduces a comment in texis.cnf. Most of the default settings -- including SYSMETAINDEX -- are commented out in your file, so SYSMETAINDEX is really the default value of 0, hence the attempt to update the index. Delete the semicolon.
source1Tamer
Posts: 91
Joined: Tue Nov 13, 2001 3:49 pm

Chkind behaviour

Post by source1Tamer »

that make sense!!
source1Tamer
Posts: 91
Joined: Tue Nov 13, 2001 3:49 pm

Chkind behaviour

Post by source1Tamer »

By the end of the metamorph manual index update process, the final merged Temp files are not renamed to the index name, the index is working fine, but the final file names are still "T02108a" , also it's the index file name in the SYSINDEX table.
should I worry about this?
User avatar
Kai
Site Admin
Posts: 1272
Joined: Tue Apr 25, 2000 1:27 pm

Chkind behaviour

Post by Kai »

The Windows version does that, because in-use files can't be renamed under Windows. It's normal.
Post Reply