index file location

Post Reply
sourceuno
Posts: 225
Joined: Mon Apr 09, 2001 3:58 pm

index file location

Post 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.
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

index file location

Post 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.
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

index file location

Post 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
John Turnbull
Thunderstone Software
aitchon
Posts: 118
Joined: Mon Jan 22, 2007 10:30 am

index file location

Post 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?
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

index file location

Post 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.
John Turnbull
Thunderstone Software
aitchon
Posts: 118
Joined: Mon Jan 22, 2007 10:30 am

index file location

Post 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
aitchon
Posts: 118
Joined: Mon Jan 22, 2007 10:30 am

index file location

Post 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
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

index file location

Post 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.
John Turnbull
Thunderstone Software
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

index file location

Post 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.
John Turnbull
Thunderstone Software
Post Reply