This is getting to be a common problem.

The links between the components in ALLBASE - IMAGESQL and IMAGE are fully
qualified!

If you store off a group containing an ALLBASE  database (DBE) and/or an
IMAGE database (TIDB) then restore elsewhere there WILL be problems.

If it is just DBE then you may get problems referring to the log.

If the DBE is attached then it will be attached FULLY QUALIFIED!

You can clean up the TIDB with DBUTIL

BUT I have not found any other way of cleaning up the DBE other than:

Destroy it (SQLUTIL PURGEFILE)
Go back to the live version and run SQLGEN to create a script.
Use Denys' DBTSQL to generate IMAGESQL attach script (change this because
ATCINFO will point to the LIVE group)
Return to the TEST group and build the DBE from the scripts in ISQL then
IMAGESQL.

Ken Vickers

LINKWAY Development and Support
__________________________________
Computing Solutions Limited

Tel. +44 1905 794400
Fax. +44 1905 794464
mailto:[log in to unmask]
http://www.csllink.com
__________________________________

-----Original Message-----
From: B T Vikram Kumar <[log in to unmask]>
To: [log in to unmask] <[log in to unmask]>
Date: 28 September 1999 07:22
Subject: Re: ImageSQL Question


>This may indicate that the ATCINFO file is corrupt or got erased. DBUTIL
>says it is attached, as the attach info on root file is still intact ,
>while some alien tool/program might have changed/erased the ATCINFO file.
>One option is to create a new dbe and attach. The old attach info will
>remain in root file. Or if you have a backup of ATCINFO file, you could
>recover the same and continue.
>
>
>Regards,
>Vikram
>
>Bob Walker wrote:
>
>> I've managed to gibble the ImageSQL connection between an Image
>> database and Allbase DBE.
>>
>> DBUTIL reports the database connected, but ImageSQL says their not.
>>
>> When I try to re-attach in ImageSQL I get an error:
>> ALLBASE/SQL CREATE TABLE command failed (ATCERR 32353).
>>   Table/View WHDB.TERMS already exists.  (DBERR 2207)
>>
>> When I try to drop these tables by hand from ISQL I get:
>> Command not allowed on TurboIMAGE table.  (DBERR 13502)
>>
>> ..nor can I delete them from  SYSTEM.TABLE (although I probably
>> shouldn't be messing around in there anyways)
>>
>> This is our test environment, but I really don't want to have to
>> purge and re-create the DBE, and this still may not solve the problem
>> as the database will still thinks it attached.
>>
>> TIA Bob.
>>
>> --=--=--
>> Bob Walker, Computer Centre  --  [log in to unmask]
>> Capilano College, North Vancouver, BC, CANADA.
>> ------