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

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

V6.1.0 LPAR

We recently (April 21, 2013) installed Cumulative PTF fix pack C3058610 and related Groups, HIPERs, etc.Here are our current *INSTALLED levels:

PTF Group LevelStatusText

SF9962610Installed 6.1 ELECTRONIC SERVICES GROUP PTF

SF9961013058Installed CUMULATIVE PTF PACKAGE C3058610

SF99609144Installed GROUP HIPER

SF9960840Installed GROUP SECURITY

SF996054Installed HARDWARE AND RELATED PTFS

SF9960129Installed DB2 FOR IBM I

SF9956223Installed JAVA

SF9935626Installed PRINT PTFS

SF9935415Installed TCP/IP PTF

SF991446Installed PERFORMANCE TOOLS

SF9911530Installed IBM HTTP SERVER FOR I

* * * * *E N DO FL I S T I N G* * * * *

Now, we are finding that there are SQL views that have mysteriously disappeared and must be re-created.We use a mix of DDS-defined files/logicals and DDL-described tables/indexes/views and we are unaware of any way to tell which ones could be missing until they are found to be gone.

Has anyone else had this issue?Is there anything else we can do to determine what needs to be re-created?

Thanks in advance,

Robert Clay

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.