I understand John's concern, but I would like to somewhat disagree.

First, you must have creator access to perform DBUTIL functions.  IMHO the
only
reason to log on as database creator should be perform database maintenance
functions.  If you are allowing inexperienced programmers to log on as the
database creator, you are asking for trouble.  We have a seperate creator
user,
who is homed to the PUB group, and the databases reside in seperate groups.

Second, DBUTIL does not consider this an error.  I have had many a database
maintenance job fail because I forgot to add the reset file equation to the
job.  I could live with the file equations, if my jobs would blow up when
DBUTIL failed.  Then I could be notified when it happens, instead of  finding
out in the morning when everybody is aborting because a structure change did
not occur but the new version of a program was rolled out.

So, I will keep my vote for DB2, but would happily change it for one that had
DBUTIL report file equations as an error and abort.

Andy  Schriber

At 08:57 AM 9/10/98 -0400, you wrote:
>
> Hello List Members,
>
> Regarding Jeff Vance's message on CFE's. As I was reading these and
> trying to figure out where to spend my $5 and wishing I had more money
> to spend, I was considering item DB 2. "DBUTIL to ignore file
> equations."
>
> I would think that it would be better to leave it like it is. Maybe for
> those of us who are experienced it would be nice to change it, but for
> the inexperienced it could be a nightmare. Consider that someone might
> issue a file equation to a test database, use some programs to do
> testing, and then want to erase that database to restart their testing
> cycle. They use DBUTIL and erroneously think that they've just erased
> their test database only to be horrified to find that by chance no one
> was accessing the production database and it was just erased.
>
> If you leave it like it is, it'll tell them that they can't use a file
> equation and they'll have to CHGROUP or whatever to erase the database.
>
> So what do y'all think?
>
> John Zoltak
> North American Mfg Co



Andrew Schriber
LabCorp
Systems Programmer
[log in to unmask]