Re: Prevent creation of a logical over a physical

Hi Pete,

Please see inline:

Pete Hall wrote:
> I don't remember exactly, but I used to run a query over outfiles created
> by a combination of dspfd and dspobjd in order to get a list of files
that
> had dependents in other libraries. It shouldn't be too difficult to
figure out.

There is a file on the system, QADBXREF (IIRC), that contains all the
information that you want. It is REALTIME! Test it! We found it
beneficial insofar as Restores or DRP is concerned. Include it in your
backups and you are assured that you will not need to do multiple
restores in order to recover all dependents based on their dependants!

>I'd think a combination of that and gentle persuasion (with a big
> nasty stick) should, at least, make the problem manageable.

There is systems management, and then there is Management! If you cannot
get them to adhere to this 'simple' standard (which is easily
identifiable), how sure are you that they are adhering to your
programming standards and not hiding cr@p code in their programs?

Cheers.

Jan.