Delete view in V7 that is in Systables but not in Sysviews

Michal Peleg

Delete view in V7 that is in Systables but not in Sysviews
Hello All,



We're converting our DB2 to V8.



One of the selects that we need to run, checks if there are miss-matched
views definitions in the catalog.

The select retrieved one problematic view from the catalog, it is
defined in SYS.SYSTABLES as view, but is not defined

In SYS.SYSVIEWS.



I'd like to delete this VIEW.

Any ideas??? DROP doesn't work, of course.



Thank you in advance,

Michal



_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Avram Friedman

Re: Delete view in V7 that is in Systables but not in Sysviews
(in response to Michal Peleg)
I would suggest the REPAIR DBD utility function with the guidence of IBM support.

This might be a bit problemmatic for a DB2 version like V7 that is out of support.
There are several options at this point
1. Pay for support for V7
2. Claim its a conversion issue so it is infact a V8 problem not a V7 one (I assume you have support for V8)
3. Migrate to V8 and then request it assistance with repair.

I do not know what IBM's response will be in any of these cases.

My guess is this is garbage left behind from a previous failed upgrade.
Id bet a cup of coffee that it is to or from V5 ... a lot of this sort of stuff dates from back then.

Best wishes
Avram Friedman

PS before you attempt a fix with or without the vendors help.
Warn the user commuity or at least management depending on shop standards.
Back up everything.
Be prepared for a total restore.

On Sun, 9 Jan 2011 13:49:57 +0200, Michal Peleg <[login to unmask email]> wrote:

>Hello All,
>
>
>
>We're converting our DB2 to V8.
>
>
>
>One of the selects that we need to run, checks if there are miss-matched
>views definitions in the catalog.
>
>The select retrieved one problematic view from the catalog, it is
>defined in SYS.SYSTABLES as view, but is not defined
>
>In SYS.SYSVIEWS.
>
>
>
>I'd like to delete this VIEW.
>
>Any ideas??? DROP doesn't work, of course.
>
>
>
>Thank you in advance,
>
>Michal
>
>
>
>_____________________________________________________________________
>* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
>* If you are going to attend only one conference this year, this is it! *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>How can you expand your staff or do succession planning in this economy?
>Mentoring is a proven, economical, way to train the next generation of DB2 Users!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv