Paul is right on the mark with this one. The DBOPEN is failing because
indexing is enabled and the necessary information for TPI is not available.
In DBUTIL you can "DISABLE dbname FOR INDEXING" and QUERY should open it
just fine. With the missing datasets you won't be able to do a FORM SETS,
but a F ALL ITEM-NAME against a dataset that has been restored should work
just fine.

Doug.

Doug Werth                                     Beechglen Development Inc.
[log in to unmask]                                       Cincinnati, Ohio

The opinions expressed do not necessarily represent the views or opinions
of Beechglen Development. They might, but not necessarily. They represent
solely the opinions of the author.

-----Original Message-----
From: Paul H. Christidis <[log in to unmask]>
To: [log in to unmask] <[log in to unmask]>
Date: Friday, March 19, 1999 2:51 PM
Subject: Re[2]: Partial IMAGE data base restore


Ron stated:
>
>> I restored only the parts of an AMISYS data base that I
>> needed to run my process, the detail sets and the associated
>> masters for the keys I was using.  However when I open the
>> data base using SUPRTOOL or QUERY I get the Following Error.
>
Joe replied:
>You *must* restore the ENTIRE database, not just sets.  You need the root
>file, all dataset files, as well as any other support files (TC file,
>Jumbo dataset files, b-tree files in the HFS filespace, etc.).

Unless something has changed recently that is not true.

We would routinely restore the root file, a specific detail set and all
masters
having paths into said detail for a variety of reasons (Data recovery,
re-generating reports, etc..) without any problems.

Of course the database that I'm referring had no TPI or Jumbo sets or any of
the
newer features.  As long as we 'limited' our access to the restored sets we
would accomplish the needed task without any problems.

Regards
Paul H. Christidis