RE: SYSCATSPACE from SMS tablespace to DMS tablespace

RE: SYSCATSPACE from SMS tablespace to DMS tablespace

 

  

This may be a nice idea but not for SYSCATSPACE.. This does not work for
SYSCATSPACE as it cannot be renamed nor can the catalogue tables be renamed
nor dropped.

-----Message d'origine-----
De : Lavezzo.Craig
[mailto:db2udbdba-ezmlmshield-x26833840.[Email address protected]
Envoyé : 19 octobre 2007 10:23
À : LazyDBA Discussion
Objet : RE: SYSCATSPACE from SMS tablespace to DMS tablespace

I wrote a script to move everything from one table space to another.
From there it is easy to move just one table across tablespaces is you
need to.



1. Rename the table space.

2. Rename the tables and indexes on that table space.

3. Create the new DMS space.

4. Create the old table/index names onto the new DMS table space.

5. Cursor load the renamed tables into the old table names that now
live on the new DMS table space.



Sometime I hate DB2





-----Original Message-----
From: Khan Nadeem
[mailto:db2udbdba-ezmlmshield-x31466112.[Email address protected]
Sent: Friday, October 19, 2007 2:14 AM
To: LazyDBA Discussion
Subject: RE: SYSCATSPACE from SMS tablespace to DMS tablespace





Well



I don't think so its possible

As SYSCATSPACE holds DDC, which can make Database useless if played

around



But you can always change state of SMS tablespace to DMS

Thru some extra effort



Thanks,

Nadeem Khan



-----Original Message-----

From: Mohammed Mohsin

[mailto:db2udbdba-ezmlmshield-x33338305.[Email address protected]

Sent: Friday, October 19, 2007 2:16 PM

To: LazyDBA Discussion

Subject: SYSCATSPACE from SMS tablespace to DMS tablespace



Hi,







I want to change the SYSCATSPACE of DB2 8.1 on Solaris 5.10 from SMS

tablespace to DMS tablespace without dropping the database and

recreating. Is it possible??







Rgds,



Mohsin



Phone : +91-80-22489390x8456











---------------------------------------------------------------------

TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY

To post a dba job: http://jobs.lazydba.com

To Subscribe : http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html





This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient,
you are not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all
copies of this message.







---------------------------------------------------------------------

TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY

To post a dba job: http://jobs.lazydba.com

To Subscribe : http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html



____________________________________________________________________________
____________________________________

CONFIDENTIALITY NOTICE: This email from the State of California is for the
sole use of the intended recipient and may contain confidential and
privileged information. Any unauthorized review or use, including
disclosure or distribution, is prohibited. If you are not the intended
recipient, please contact the sender and destroy all copies of this email.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page