MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » November 2006

View properties



fixed

How does one alter these properties on a view:
DSPFD mylib/SYSTABLES
Allow read operation  . . . . . . . . . . . :            Yes 
Allow write operation . . . . . . . . . . . :            Yes 
Allow update operation  . . . . . . . . . . : ALWUPD     *YES
Allow delete operation  . . . . . . . . . . : ALWDLT     *YES

Here's the problem.
This view was created back in 1997 with the following statement:
STRSQL
CREATE COLLECTION mylib
This sql statement builds a library and automatically creates a journal, 
journal receiver and a set of views that select various records from the 
database cross reference files with the Where clause restricting it to 
only data from that library.

When I run this now
CREATE COLLECTION newlib
The properties are set to
Allow read operation  . . . . . . . . . . . :            Yes
Allow write operation . . . . . . . . . . . :            No 
Allow update operation  . . . . . . . . . . : ALWUPD     *NO
Allow delete operation  . . . . . . . . . . : ALWDLT     *NO
Which is a perfect match for DSPFD QADBXREF.  So, maybe the view assumes 
the property of the physical file?

Now, when I restore this library on to a backup Mimix lpar on another box 
(same os level and ptf level) it changes the properties on the view 
created back in 1997 to the properties of QADBXREF.  Every day my Mimix 
audits flag this file as the properties are different and point right to 
here.  I run their SYNCOBJ and it says it runs successfully (liar) but the 
properties still differ.  Even started a WebEx with Mimix support and it's 
looking like I'll have to call IBM on this one.

Nearest I can figure is that back in 1997 the properties of QADBXREF were 
different and the LF adopted it's authorities as of then.  Then with some 
new release IBM changed the properties on the PF but it didn't change on 
the underlying view.

Last time we restored the 1997 view was back in 09/18/04 (?unload/reload?) 
and it didn't seem to mind the properties then.  But the restore from the 
source system to the target system this month to initiate our Mimix 
environment didn't restore the properties so I suspect that if I ever have 
to restore that file again on the source system then the properties will 
be different.

Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact