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