Re: SQL views missing after Cumulative PTF's applied -- MIDRANGE-L

Subject: Re: SQL views missing after Cumulative PTF's applied
From: Charles Wilt <charles.wilt@xxxxxxxxx>
Date: Mon, 26 Aug 2013 12:37:46 -0400
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Hmm...that seems telling to me...

Can you do a DSPFD on SYSIBM.SYSDUMMY1 and see if by chance it got
replaced\recreated as part of the PTFs?

IIRC, if you delete a table, the system gives you an option to delete
dependents...

So I could see you're views being deleted if SYSDUMMY1 got recreated...

Have you past the info about SYSDUMMY1 back to IBM via your PMR? If not
I'd strongly suggest doing so.

Charles

On Mon, Aug 26, 2013 at 11:15 AM, Robert Clay <zreclay@xxxxxxxxx> wrote:

The one thing that these five views have in common is that they each
utilize UNION with values based on SYSIBM.SYSDUMMY1 (don't ask).

Follow-Ups:

Re: SQL views missing after Cumulative PTF's applied , rob

This mailing list archive is Copyright 1997-2026 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.