[DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC

Ruediger Kurtz

[DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC
Cheers,

we suspected that much. Nonetheless we would have thought it more appropriate if DB2 issued a warning message somewhere along the line 'Recover is not possible, use DSN1COPY instead'; if DB2 knows that table and IC are no longer in sync why not say so ?

Still, thanks a lot anyway

Ruediger




Rüdiger Kurtz
Abteilung Informatik Betrieb
HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon 09561 96-3914
Telefax 09561 96-3678
E-Mail [login to unmask email]


________________________________

Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Michael Ebert
Gesendet: Dienstag, 12. Dezember 2006 15:03
An: [login to unmask email]
Betreff: Re: [DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC



Yes it's WAD (at least under V7, but I don't think V8 changed the UNLOAD semantics that much). DB2 knows that the IC is not from the same table as the one you currently have and it's protecting you from all sorts of data inconsistency issues. Use DSN1COPY with OBIDXLAT and RESET to trick DB2. The usual DSN1COPY caveats apply. Also note: DB2 COPY and RECOVER are designed to protect you from media failure, nothing else. They're definitely not for drop recovery.

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




Kurtz, Rüdiger <[login to unmask email]>
To
[login to unmask email]
cc
bcc
Subject
[DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC



Kurtz, Rüdiger <[login to unmask email]>

Please respond to DB2 Database Discussion list at IDUG <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12-12-06 14:49




Hi everyone out there,

yesterday we experienced the following scenario:

We accidentally dropped a table, but since we had an image-copy from that very day we didn't think that we might run into big trouble; we unloaded the image-copy and got the following warning:
DBT2 DSNUULIA - TABLESPACE DT7DB990.TMKUN013 IS EMPTY

OK, we thought, just re-create the table and everything will be fine.

After we recreated the table we re-ran the unload and this time we got
DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0

A RECOVER TO COPY also produced an empty table.

We then checked via DSN1PRNT and IEBGENER and found that the data we were looking for was actually in the dataset, but apparently DB2 couldn't get to it.

We do think that all this is because of a change of the table's OBID, but our question runs as follows:

Is this a WAD-issue ?

Any comments or suggestions are highly appreciated.

TIA Ruediger
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Ebert

Re: AW: [DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC
(in response to Ruediger Kurtz)
Maybe because if you want to use DSN1COPY successfully, you need detailed
knowledge about DB2 and its inner workings; so if you need to be told, you
shouldn't try to do it :-)) Remember, DSN1COPY is an offline utility,
you're bypassing many DB2 integrity checks with it.

MfG, ME.




Kurtz, Rüdiger <[login to unmask email]>
To
[login to unmask email]
cc

bcc

Subject
[DB2-L] AW: [DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC





Kurtz, Rüdiger <[login to unmask email]>
Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12-12-06 15:19


Cheers,
we suspected that much. Nonetheless we would have thought it more
appropriate if DB2 issued a warning message somewhere along the line
'Recover is not possible, use DSN1COPY instead'; if DB2 knows that table
and IC are no longer in sync why not say so ?

Still, thanks a lot anyway

Ruediger


Rüdiger Kurtz
Abteilung Informatik Betrieb
HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon 09561 96-3914
Telefax 09561 96-3678
E-Mail [login to unmask email]

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ruediger Kurtz

AW: [DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC
(in response to Michael Ebert)
You know, you might be right, but ending up with an empty table caused us more problems in the long run than a simple 'Use DSN1COPY instead' would have done.

Regards

Ruediger

________________________________

Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von Michael Ebert
Gesendet: Dienstag, 12. Dezember 2006 15:28
An: [login to unmask email]
Betreff: Re: [DB2-L] AW: [DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC



Maybe because if you want to use DSN1COPY successfully, you need detailed knowledge about DB2 and its inner workings; so if you need to be told, you shouldn't try to do it :-)) Remember, DSN1COPY is an offline utility, you're bypassing many DB2 integrity checks with it.

MfG, ME.




Kurtz, Rüdiger <[login to unmask email]>
To
[login to unmask email]
cc
bcc
Subject
[DB2-L] AW: [DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC



Kurtz, Rüdiger <[login to unmask email]>

Please respond to DB2 Database Discussion list at IDUG <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12-12-06 15:19




Cheers,
we suspected that much. Nonetheless we would have thought it more appropriate if DB2 issued a warning message somewhere along the line 'Recover is not possible, use DSN1COPY instead'; if DB2 knows that table and IC are no longer in sync why not say so ?

Still, thanks a lot anyway

Ruediger



Rüdiger Kurtz
Abteilung Informatik Betrieb
HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon 09561 96-3914
Telefax 09561 96-3678
E-Mail [login to unmask email]
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Ebert

Re: AW: [DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC
(in response to Ruediger Kurtz)
That's what this list is for!

MfG, ME.




Kurtz, Rüdiger <[login to unmask email]>
To
[login to unmask email]
cc

bcc

Subject
[DB2-L] AW: [DB2-L] DB2 V8 for z/OS Unload from a dropped table's FIC





Kurtz, Rüdiger <[login to unmask email]>
Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
12-12-06 15:42


You know, you might be right, but ending up with an empty table caused us
more problems in the long run than a simple 'Use DSN1COPY instead' would
have done.

Regards

Ruediger

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm