thanks Joellen, I am reading that..


From: Sayles Joellen [mailto:joellen.[Email address protected]
Sent: April 27, 2006 3:34 PM
To: Pham, Anh
Subject: RE: COPY the WHOLE DB in UDB/solaris platform
Look at using the db2move utility.


-----Original Message-----
From: Pham Anh
[mailto:db2udbdba-ezmlmshield-x21834609.[Email address protected]
Sent: April 27, 2006 3:09 PM
To: LazyDBA Discussion
Subject: COPY the WHOLE DB in UDB/solaris platform


Good afternoon all,

I am having a question, might you give me a quick clue

+ I have DBX1 with all tables + index + RI + data loaded

+ we built another DBX2 in same instance, starting fresh but with first change, only change is pagesige 32 KB pagesize comparing to the DBX1,all 4KB pagesize

do we have any faster way than what I am doing now, run DDL and un-load/reloaded to DBX2 - all TS, TB, IX, RI name are exactly same

Thank you


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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