|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.