Just to add to what Rene said.  When a TurboIMAGE DB (TIDB) is first
attached to a DBE, there are two files that get created.  One goes with the
TIDB in the nomenclature format of rootnmTC where rootnm is the root file
name and the other is a DBE related file that usually goes by the
nomenclature format of dbenameATC, thought this last is configurable.

The DBTC file (file code -430) (the one that is missing in your case,)
contains the mapping of the datasets, fields and passwords into the DBE
concepts of tables, columns and views.  In other words, all the settings
that you do with IMAGESQL.PUB.SYS go into that file, for each DBE to which
this TIDB is attached.

The ATC file (file code -431) (which lives with the DBE) only contains the
name(s) of all the TIDB(s) to which this DBE is attached.  When the first
TIDB is attached to this DBE, the ATC file is created.  Correspondingly,
when the last TIDB is detached from the DBE, the file disappears.


Denys

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On Behalf Of
Adager Support (Rene Woc)
Sent: Monday, July 01, 2002 11:27 AM
To: [log in to unmask]
Subject: Re: database file missing

At 8:56 AM -0600 7/1/02, Larry Simonsen wrote:

>if i look at a database using dbutil and show db all the following message
>is at the bottom
>WARNING: Root file ATC flag is on, but CRDBTC file is missing.
>
>what is the TC file and how do i recreate it or reset the flag for the
>database?
>
>i tried to use dbutil to detach the database but since the tc file does not
>exist the detach fails.
>>>detach crdb
>
>   WARNING: Root file ATC flag is on, but CRDBTC file is missing,
>            cannot DETACH.
>
>what can i do now


The "TC" file contains information on the SQL DataBaseEnvironment(s)
to which this database is (was) attached.

If you don't care to which DBEs the TurboIMAGE database was attached,
you can reset the "ATC flag" by building a dummy file CRDBTC with
file code -430 and then use dbutil to detach CRDB.

Please note that the DBE that CRDB was attached to may still have an
entry for CRDB and may need to be cleaned up or rebuilt.


Cordially,


Rene

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *