Db2 12 for z/OS, Dataset not deleted during drop tablespace

Ruediger Kurtz

Db2 12 for z/OS, Dataset not deleted during drop tablespace
Hi,

during some change process yesterday I had to drop and re-create a partitioned tablespace.
The drop ran just fine, but the create failed with

SQLCODE = -601, ERROR: THE NAME (VERSION OR VOLUME SERIAL NUMBER) OF THE OBJECT TO BE DEFINED OR THE TARGET OF A RENAME
STATEMENT IS IDENTICAL TO THE EXISTING NAME (VERSION OR VOLUME SERIAL NUMBER)
TSGDDBAD.TPSCR117 OF THE OBJECT TYPE DATASET

I then checked whether any dataset had survived the drop and lo and behold, there it was …

TDB2DB.DSNDBD.D00SC110.TPSCR117.I0001.A014

And later on during the change process I encountered the very same error, on a different object though, but still.

I now wonder why a drop would not clean up all datasets belonging to an object. Any ideas?

Thanks

Rüdiger

Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer, Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________

Roy Boxwell

Db2 12 for z/OS, Dataset not deleted during drop tablespace
(in response to Ruediger Kurtz)
I would bet that a REORG on the part failed at some point in the past. This could have left the “shadow” dataset allocated. By the DROP the “real” datasets were deleted and the dead bodies were left in the cellar... just waiting for the next CREATE... To verify this look at the IPREFIX column in the Db2 Catalog backup that you probably have somewhere for these two parts.



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Vagedesstrasse 19
40479 Dusseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



From: Kurtz, Rüdiger [mailto:[login to unmask email]
Sent: Thursday, September 26, 2019 7:14 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - Db2 12 for z/OS, Dataset not deleted during drop tablespace



Hi,

during some change process yesterday I had to drop and re-create a partitioned tablespace.
The drop ran just fine, but the create failed with



SQLCODE = -601, ERROR: THE NAME (VERSION OR VOLUME SERIAL NUMBER) OF THE OBJECT TO BE DEFINED OR THE TARGET OF A RENAME

STATEMENT IS IDENTICAL TO THE EXISTING NAME (VERSION OR VOLUME SERIAL NUMBER)

TSGDDBAD.TPSCR117 OF THE OBJECT TYPE DATASET



I then checked whether any dataset had survived the drop and lo and behold, there it was …

TDB2DB.DSNDBD.D00SC110.TPSCR117.I0001.A014

And later on during the change process I encountered the very same error, on a different object though, but still.

I now wonder why a drop would not clean up all datasets belonging to an object. Any ideas?

Thanks

Rüdiger

Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg


Telefon:

09561 96-44148


Telefax:

09561 96-44104


E-Mail:

[login to unmask email] <mailto:[login to unmask email]>


Internet:

www.huk.de http://www.huk.de

_____

HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer, Sarah Rössler, Daniel Thomas.

_____

Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.

_____



-----End Original Message-----

Attachments

  • smime.p7s (5.1k)

Daniel Luksetich

Db2 12 for z/OS, Dataset not deleted during drop tablespace
(in response to Ruediger Kurtz)
Did you search for any corresponding AMS messages around the time of the drop?



+--------------------------------------+-----------------------------------------------------------+

| Daniel L Luksetich | IBM Certified Advanced Database Administrator – |

| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and Windows |

| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator – Db2 11 DBA for z/OS |

| IDUG DB2-L Administrator | IBM Certified System Administrator – Db2 11 for z/OS |

| URL: https://db2expert.com https://db2expert.com | IBM Certified Application Developer – Db2 11 for z/OS |

+--------------------------------------+-----------------------------------------------------------+





From: Kurtz, Rüdiger <[login to unmask email]>
Sent: Thursday, September 26, 2019 12:14 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - Db2 12 for z/OS, Dataset not deleted during drop tablespace



Hi,

during some change process yesterday I had to drop and re-create a partitioned tablespace.
The drop ran just fine, but the create failed with



SQLCODE = -601, ERROR: THE NAME (VERSION OR VOLUME SERIAL NUMBER) OF THE OBJECT TO BE DEFINED OR THE TARGET OF A RENAME

STATEMENT IS IDENTICAL TO THE EXISTING NAME (VERSION OR VOLUME SERIAL NUMBER)

TSGDDBAD.TPSCR117 OF THE OBJECT TYPE DATASET



I then checked whether any dataset had survived the drop and lo and behold, there it was …

TDB2DB.DSNDBD.D00SC110.TPSCR117.I0001.A014

And later on during the change process I encountered the very same error, on a different object though, but still.

I now wonder why a drop would not clean up all datasets belonging to an object. Any ideas?

Thanks

Rüdiger

Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg


Telefon:

09561 96-44148


Telefax:

09561 96-44104


E-Mail:

[login to unmask email] <mailto:[login to unmask email]>


Internet:

www.huk.de http://www.huk.de

_____

HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer, Sarah Rössler, Daniel Thomas.

_____

Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.

_____



-----End Original Message-----

Attachments

  • image001.png (9.9k)
  • image002.png (14k)
  • image003.png (13.1k)
  • image004.png (14.5k)
  • image005.png (15.3k)
  • image006.png (14.2k)
  • image007.png (7.5k)

Ruediger Kurtz

AW: Db2 12 for z/OS, Dataset not deleted during drop tablespace
(in response to Daniel Luksetich)
Dan and Roy,

@Dan: thanks for pointing me into the right direction … I took a butcher’s in the syslog, and there I found what I’d been looking for:

DSNP009I .DBT4 THE FOLLOWING ERROR MESSAGES WERE
RECEIVED FOR DELETE CLUSTER ON
TDB2DB.DSNDBC.D00SC110.TPSCR117.I0001.A014
IKJ56225I DATA SET TDB2DB.DSNDBC.D00SC110.TPSCR117.I0001.A014 ALREADY
IKJ56225I IN USE, TRY LATER
IKJ56225I DATA SET IS ALLOCATED TO ANOTHER JOB OR USER
IEFA110I DATA SET CONTENTION
DATA SET TDB2DB.DSNDBC.D00SC110.TPSCR117.I0001.A014 IN USE BY
SYSNAME JOBNAME ASID
SY4 AP803TKW 00AB
IDC0551I ** ENTRY TDB2DB.DSNDBC.D00SC110.TPSCR117.I0001.A014 NOT
DELETED


@Roy: I must admit I had the same idea yesterday, but wasn’t sure how to dig further into the matter. Today I unloaded the one Image-Copy of SYSTABLEPART before the drop, the IPREFIX there was “I”, and the last standing dataset also has the I-Prefix, so what we’re betting for now?

Thanks to both of you, guys

regards

Rüdiger


Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer, Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Daniel L Luksetich [mailto:[login to unmask email]
Gesendet: Donnerstag, 26. September 2019 14:04
An: [login to unmask email]
Betreff: [DB2-L] - RE: Db2 12 for z/OS, Dataset not deleted during drop tablespace

Did you search for any corresponding AMS messages around the time of the drop?

+--------------------------------------+-----------------------------------------------------------+
| Daniel L Luksetich | IBM Certified Advanced Database Administrator – |
| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and Windows |
| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator – Db2 11 DBA for z/OS |
| IDUG DB2-L Administrator | IBM Certified System Administrator – Db2 11 for z/OS |
| URL: https://db2expert.com https://db2expert.com | IBM Certified Application Developer – Db2 11 for z/OS |
+--------------------------------------+-----------------------------------------------------------+
[cid:[login to unmask email][cid:[login to unmask email][cid:[login to unmask email][cid:[login to unmask email][cid:[login to unmask email][cid:[login to unmask email][cid:[login to unmask email]

From: Kurtz, Rüdiger <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, September 26, 2019 12:14 AM
To: '[login to unmask email]' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - Db2 12 for z/OS, Dataset not deleted during drop tablespace

Hi,

during some change process yesterday I had to drop and re-create a partitioned tablespace.
The drop ran just fine, but the create failed with

SQLCODE = -601, ERROR: THE NAME (VERSION OR VOLUME SERIAL NUMBER) OF THE OBJECT TO BE DEFINED OR THE TARGET OF A RENAME
STATEMENT IS IDENTICAL TO THE EXISTING NAME (VERSION OR VOLUME SERIAL NUMBER)
TSGDDBAD.TPSCR117 OF THE OBJECT TYPE DATASET

I then checked whether any dataset had survived the drop and lo and behold, there it was …

TDB2DB.DSNDBD.D00SC110.TPSCR117.I0001.A014

And later on during the change process I encountered the very same error, on a different object though, but still.

I now wonder why a drop would not clean up all datasets belonging to an object. Any ideas?

Thanks

Rüdiger

Rüdiger Kurtz
Abteilung Informatik - Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon:

09561 96-44148

Telefax:

09561 96-44104

E-Mail:

[login to unmask email]<mailto:[login to unmask email]>

Internet:

www.huk.de http://www.huk.de

________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer, Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________

-----End Original Message-----

-----End Original Message-----
Attachments

  • image001.png (9.9k)
  • image002.png (14k)
  • image003.png (13.1k)
  • image004.png (14.5k)
  • image005.png (15.3k)
  • image006.png (14.2k)
  • image007.png (7.5k)