How to do data migration in DB2?

gokuldass · New User Joined: 18 Mar 2005 Posts: 48 Location: india

Hello Guys,

I am in search of a tool which will increase the column size of a table without modifying the existing data's from the table.

My table is already having around 20000 rows inserted. Now my current requirement is to increase the column size of each columns. In this case, the rows already inserted should not get affected.

Is there any db2 tool available to do this?

Thanks in advance.

REgards,
Gokuldass

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

If you are using db2 version 8, then it is possible to use the ALTER TABLE command to incearse the column width.

IF you are not using version 8, unload the table , the delete drop the table and possible the indexes, taking necessary precautions, cosiderations etc. Create the table again and use load to load back the data.