Page 1 of 1
index file location
Posted: Wed Nov 21, 2001 4:38 pm
by sourceuno
I'm able to create an index for a table on a different drive using indexspace. Is there a way to directly update the index file location in the SYSINDEX table? I tried to update the FNAME column in that table, but I get an insufficient permissions error.
index file location
Posted: Wed Nov 21, 2001 4:50 pm
by mark
Do it as the _SYSTEM user.
And the obligatory caveat:
You had better know what you are doing before you attempt to modify any SYS tables.
index file location
Posted: Wed Nov 21, 2001 4:51 pm
by John
You can update the SYSINDEX table, but you do need to login as the _SYSTEM user, as if you get it wrong you can mess up your system. e.g.
tsql -u _SYSTEM
index file location
Posted: Tue Feb 28, 2012 11:17 am
by aitchon
One of my system tables was corrupt. Do I have to reinstall Texis to recreate the system tables, or is there another way to recreate the system database?
index file location
Posted: Tue Feb 28, 2012 11:44 am
by John
Which one? You don't need to reinstall Texis, as creating a new database will recreate the system tables in that database. The greater challenge will be getting the right information into that table.
index file location
Posted: Tue Feb 28, 2012 11:49 am
by aitchon
I was getting this error:
e:\modules>texis -ci -log "" -force -module sitevalidations sitevalidations
Texis Web Script (Vortex) Copyright (c) 1996-2009 Thunderstone - EPI, Inc. Commercial Version 5.01.1258488718 20091117 (i686-intel-winnt-64-32) 002 sitevalidations: Cannot open KDBF file e:\texissystemdb\T06848a_D.btr for writing: error 2/2: The system cannot find the file specified/No such file or directory
015 sitevalidations: Probable corrupt KDBF file e:\texissystemdb\T06848a_D.btr: FDBF disabled, enable in texis.cnf only if known to be FDBF
000 sitevalidations: Vortex (3296) ABEND: exception 0xC0000005 (ACCESS_VIOLATION) at ip 0x47b069
index file location
Posted: Tue Feb 28, 2012 12:42 pm
by aitchon
I'm also seeing this error when trying to compile a script:
Texis Web Script (Vortex) Copyright (c) 1996-2009 Thunderstone - EPI, Inc.
Commercial Version 5.01.1258488718 20091117 (i686-intel-winnt-64-32)
100 e:\testscript: Index e:\texissystemdb\xsdd-0 appears to be being updated
000 e:\testscript: Cannot create index xsdd: Already exists as type `T' in the function createindex
000 e:\testscript: SQLPrepare() failed with -1 in the function prepntexis
index file location
Posted: Tue Feb 28, 2012 12:44 pm
by John
If you look in SYSINDEX to find out which index and type that is. You may want to open a support ticket, as it may be a fairly easy fix after seeing SYSINDEX.
index file location
Posted: Tue Feb 28, 2012 12:45 pm
by John
It sounds like you were running the script, and it was trying to update an index that it thought was already being updated.