RE: Do third party products add access paths to system tables often?

At least then the problem is with-in the application libraries and not buried in the OS libraries. Good documentation will have a "**WARNING** please contact support before upgrading the OS as we have files over the OS base.***" or something along those lines. Any are not any application libraries installed after the OS?

You still have to deal with PTFs updating system tables that may cause your Index or view to die, but hopefully the software vendor is on top of it.

I just feel it is better to put everything an application vendor creates or modifies in their own library and NOT in system libraries. Just my 2 cents.

Oh and I agree the Order by clause would have been much better in this case.


Chris Bipes
Director of Information Services
CrossCheck, Inc.

-----Original Message-----
Subject: RE: Do third party products add access paths to system tables often?

Chris,

Cross library logicals are not the most popular item in the business. And
they still would have affected David (who came up with a better solution -
use an order by clause). So how does keeping them in a separate library
help? Documentation?


Rob Berendt