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.


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