change from SMS to DMS 
Author Message
 change from SMS to DMS
Hi,

Any ways to change the tablespace from SMS to DMS?
Thanks for any advice in advance....

--
Best Regards,
Jacky Ng
dbONE (Hong Kong) Ltd

Tel: 3105-2138



Mon, 10 May 2004 18:18:35 GMT
 change from SMS to DMS

I  never did it but i  think that  "The  Professor"  (Mr St-Jacques)
or  other people  were talking about redirected restore.

You can search google  or  the doc to  verify.
(Maybe i'm just plain wrong  ?)

PM



Quote:
> Hi,

> Any ways to change the tablespace from SMS to DMS?
> Thanks for any advice in advance....

> --
> Best Regards,
> Jacky Ng
> dbONE (Hong Kong) Ltd

> Tel: 3105-2138



Tue, 11 May 2004 20:30:07 GMT
 change from SMS to DMS
Through "Restore ... redirect" can't change a SMS tablespace to a DMS
tablespace, it can move a DMS tablespace from file containers to device
containers.
Thanks & Regards,

Fan Ruo Xin

Quote:

> I  never did it but i  think that  "The  Professor"  (Mr St-Jacques)
> or  other people  were talking about redirected restore.

> You can search google  or  the doc to  verify.
> (Maybe i'm just plain wrong  ?)

> PM



> > Hi,

> > Any ways to change the tablespace from SMS to DMS?
> > Thanks for any advice in advance....

> > --
> > Best Regards,
> > Jacky Ng
> > dbONE (Hong Kong) Ltd

> > Tel: 3105-2138



Wed, 12 May 2004 03:07:52 GMT
 change from SMS to DMS
Well unless the "Professor" has other thoughts, you cannot change an SMS
table space to a DMS table space - regardless of using a re-directed
restore, or not. Professor?

--

Bob Harbus - Senior Consultant
DB2 UDB Data Management Consulting Services - IBM Toronto

Quote:

> I  never did it but i  think that  "The  Professor"  (Mr St-Jacques)
> or  other people  were talking about redirected restore.

> You can search google  or  the doc to  verify.
> (Maybe i'm just plain wrong  ?)

> PM



> > Hi,

> > Any ways to change the tablespace from SMS to DMS?
> > Thanks for any advice in advance....

> > --
> > Best Regards,
> > Jacky Ng
> > dbONE (Hong Kong) Ltd

> > Tel: 3105-2138



Wed, 12 May 2004 10:22:06 GMT
 change from SMS to DMS
Then I was wrong.
I recalled that you could do something about containers
with a redirected restore.  I wasn't exactly sure what it was though.

If Bob sais so then, it's not possible.
Thanks for the clarification. (refreshing my memory)
Also thanks to Fan Ruo Xin for remembering me
what it was exactly that you could do with the re-directed restore.

PM



Quote:
> Well unless the "Professor" has other thoughts, you cannot change an SMS
> table space to a DMS table space - regardless of using a re-directed
> restore, or not. Professor?

> --

> Bob Harbus - Senior Consultant
> DB2 UDB Data Management Consulting Services - IBM Toronto


> > I  never did it but i  think that  "The  Professor"  (Mr St-Jacques)
> > or  other people  were talking about redirected restore.

> > You can search google  or  the doc to  verify.
> > (Maybe i'm just plain wrong  ?)

> > PM



> > > Hi,

> > > Any ways to change the tablespace from SMS to DMS?
> > > Thanks for any advice in advance....

> > > --
> > > Best Regards,
> > > Jacky Ng
> > > dbONE (Hong Kong) Ltd

> > > Tel: 3105-2138



Wed, 12 May 2004 10:22:54 GMT
 change from SMS to DMS
Dear all,

Million thanks for all the advice!!

/Jacky


Quote:
> Then I was wrong.
> I recalled that you could do something about containers
> with a redirected restore.  I wasn't exactly sure what it was though.

> If Bob sais so then, it's not possible.
> Thanks for the clarification. (refreshing my memory)
> Also thanks to Fan Ruo Xin for remembering me
> what it was exactly that you could do with the re-directed restore.

> PM



> > Well unless the "Professor" has other thoughts, you cannot change an SMS
> > table space to a DMS table space - regardless of using a re-directed
> > restore, or not. Professor?

> > --

> > Bob Harbus - Senior Consultant
> > DB2 UDB Data Management Consulting Services - IBM Toronto


> > > I  never did it but i  think that  "The  Professor"  (Mr St-Jacques)
> > > or  other people  were talking about redirected restore.

> > > You can search google  or  the doc to  verify.
> > > (Maybe i'm just plain wrong  ?)

> > > PM



> > > > Hi,

> > > > Any ways to change the tablespace from SMS to DMS?
> > > > Thanks for any advice in advance....

> > > > --
> > > > Best Regards,
> > > > Jacky Ng
> > > > dbONE (Hong Kong) Ltd

> > > > Tel: 3105-2138



Fri, 14 May 2004 09:37:22 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Moving tables to SMS to DMS with more than 26000 lobs

2. aboure SMS and DMS difference in incremental backup

3. SMS vs DMS

4. SMS vs DMS

5. DMS vs SMS

6. Converting from SMS to DMS tablespaces

7. How to change a record within SQL/SMS database

8. Problem changing sql sa-account password and sms

9. SMS and IP change

10. db2: db2inidb on database after backup/restore (UDB 7.2. on AIX) (DMS AnD SMS)

11. Using SQL svr to build a simple DMS like Sharepoint

12. Can't connect to Oracle DMS with thin client applet


 
Powered by phpBB® Forum Software