Migrate 4K Tablespace to 8K Tablespace in DB2 v8

#1 (**permalink**) 02-27-2008, 01:43 PM

What is the best practise to migrate all data in a 4K User tablepace
to an 8K User tablespace for DB2 v8.2.7?

The idea i am toying with is to interrogate the system catalog and
EXPORT all data that is in the 4K user tablespace in IXF format. Then,
IMPORT this data into an 8K user tablespace. Is there a better way?

#2 (**permalink**) 02-27-2008, 01:43 PM

On Jun 5, 9:04 am, Otto Carl Marte <Otto.Ma...@gmail.com> wrote:
> What is the best practise to migrate all data in a 4K User tablepace
> to an 8K User tablespace for DB2 v8.2.7?
>
> The idea i am toying with is to interrogate the system catalog and
> EXPORT all data that is in the 4K user tablespace in IXF format. Then,
> IMPORT this data into an 8K user tablespace. Is there a better way?

Instead of Export/Import you may use cursor load to speed up the
process, but you need to have enough space to have 2 copies of table.

like db2 declare c1 cursor for select * from tab1_4K
db2 load from c1 of cursor insert into tab1_8K

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode