RENAME statement for Tablespace/Database

Bharath Nunepalli

RENAME statement for Tablespace/Database

Hi All,

I know we have RENAME statement for existing table or index in Db2 for z/OS. And, I didn't see RENAME statement for Tablespace or Database in Db2 for z/OS.

 

I just want to make sure I didn't miss any new updates. Do we have RENAME statement for Tablespace or Database in Db2 v11 or v12?

 

Thanks,

Bharath Nunepalli

Phil Grainger

RENAME statement for Tablespace/Database
(in response to Bharath Nunepalli)
Not yet

Sent from my iPhone

On 28 Nov 2017, at 22:19, Bharath Nunepalli <[login to unmask email]<mailto:[login to unmask email]>> wrote:


Hi All,

I know we have RENAME statement for existing table or index in Db2 for z/OS. And, I didn't see RENAME statement for Tablespace or Database in Db2 for z/OS.



I just want to make sure I didn't miss any new updates. Do we have RENAME statement for Tablespace or Database in Db2 v11 or v12?



Thanks,

Bharath Nunepalli

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.

Colin Clayton

RENAME statement for Tablespace/Database
(in response to Bharath Nunepalli)
I guess the difficulty would be that dbname an tsname make up the physical dataset name so more than just a catalog entry update.




Sent from my Samsung Galaxy smartphone.


-------- Original message --------
From: Bharath Nunepalli <[login to unmask email]>
Date: 28/11/2017 22:19 (GMT+00:00)
To: [login to unmask email]
Subject: [DB2-L] - RENAME statement for Tablespace/Database


Hi All,

I know we have RENAME statement for existing table or index in Db2 for z/OS. And, I didn't see RENAME statement for Tablespace or Database in Db2 for z/OS.



I just want to make sure I didn't miss any new updates. Do we have RENAME statement for Tablespace or Database in Db2 v11 or v12?



Thanks,

Bharath Nunepalli

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

Ruediger Kurtz

AW: RENAME statement for Tablespace/Database
(in response to Bharath Nunepalli)
Bharath,

there are several RFEs that deal with this topic.
A quick search brought up ID 28415 and ID 101147. You may want to vote for those so as to push the chances of the RFE being realized.

Regards

Ruediger


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 (stv.), Sarah Rössler, Daniel Thomas (stv.).
________________________________
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: Bharath Nunepalli [mailto:[login to unmask email]
Gesendet: Dienstag, 28. November 2017 23:19
An: [login to unmask email]
Betreff: [DB2-L] - RENAME statement for Tablespace/Database


Hi All,

I know we have RENAME statement for existing table or index in Db2 for z/OS. And, I didn't see RENAME statement for Tablespace or Database in Db2 for z/OS.



I just want to make sure I didn't miss any new updates. Do we have RENAME statement for Tablespace or Database in Db2 v11 or v12?



Thanks,

Bharath Nunepalli

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

Bharath Nunepalli

RE: AW: RENAME statement for Tablespace/Database
(in response to Ruediger Kurtz)

Will do. Thanks for the details.

Bharath Nunepalli,

Senior DB2 DBA.

Bharath Nunepalli

RE: RENAME statement for Tablespace/Database
(in response to Colin Clayton)

Phil & Colin,
Thanks for the response.

 

Bharath Nunepalli,

Senior DB2 DBA.