Page 1 of 1

SYSMETAINDEX Value

Posted: Tue Jul 23, 2002 10:09 am
by source1Tamer
what is the maximum amount of data in bytes(THRESH in SYSMETAINDEX table) could be specified?
I'm trying to disable the autoindex only on one table no matter how many bytes inserted/updated, by adding a very high Wait/THRSH for time/data size -respectivly-entry in the SYSMETAINDEX table.
To let u know, I've 4+ Geg of updates.

SYSMETAINDEX Value

Posted: Tue Jul 23, 2002 10:16 am
by Kai
They're both long values, so the max would be 2GB on 32-bit systems and 2^63 (>9x10^18) on 64-bit Texis versions.

SYSMETAINDEX Value

Posted: Tue Jul 23, 2002 3:10 pm
by source1Tamer
so, in order to disable AutoIndexing for 15+ Gegs of changes (as a daily batch),
Should I disable the chkind for the whole system?(This will affect all other tables)..
Or, I have to turn chkind on, and Set SYSMETAINDEX to "1" and add entries only for tables that require autoindex in the SYSMETAINDEX table?

SYSMETAINDEX Value

Posted: Tue Jul 23, 2002 3:21 pm
by John
Setting SYSMETAINDEX to 1 would be the better option, as it still lets chkind run where needed.