5.1 I just discovered that a database that is used infrequently is missing its root file. I can not find a copy on any backup tape. I do have a good schema. Is there anything I can do to recover this database?

You can replace the root file if you are careful. If you have a schema that matches the data sets EXACTLY then do the following:

1. create a separate group called dbtemp, and home yourself to that group then,

file dbstext=dbschema

run dbschema.pub.sys;parm=1

run dbutil.pub.sys

create dbname

Now you should have an empty data base with a good root file, but in the wrong group.

2. store the root file to tape

3. restore the root file using the group= option

At this point you should have a good root file in the correct group.

As a final point: Like running BULDACCT to get an alternative directory source in the full backup, it is also a good idea to run Adager, DBGeneral or some other utility to create a known good schema on a periodic basis.