DB2, change from SMS to DMS

change from SMS to DMS

Author	Message
Jacky N #1 / 6	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

Pascal-Marc Gelina #2 / 6	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

Fan Ruo Xi #3 / 6	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

Bob Harbu #4 / 6	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

Pascal-Marc Gelina #5 / 6	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

Jacky N #6 / 6	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

Page 1 of 1

[ 6 post ]