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
