RE: Prevent creation of a logical over a physical

At 18:12 12/13/2002, Walden H Leverich wrote:

Here's the bigger issue, the physicals we're concerned with are in a test
environment. The programmers need access to the environment to review test
data when there is a problem. However, they have a (nasty) habit of building
logicals in their private library over the physical in the test library, so
when we go to clear that lib to refresh from production we have to find all
the cross-library logicals and delete them first. We were hoping for a
simple authority-fix to prevent them from creating the logical.

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. I'd think a combination of that and gentle persuasion (with a big
nasty stick) should, at least, make the problem manageable.


Pete Hall
pbhall@ameritech.net
http://www.pbhall.us/