fastest way to change tablespace pagesize

udbdb2 · #1 (**permalink**) 02-21-05, 19:24

Is anyone know this or has done this before withought drop/recreate tablespace ? and import data in to it ?

TIA.

ARWinner · #2 (**permalink**) 02-22-05, 07:57

No. That is the only way to do it.
Export, drop, create, import.

Andy

udbdb2 · #3 (**permalink**) 02-22-05, 14:21

IBM should have some faster ways as they have it for MF.

Anyway thanks for your response...

jacampbell · #4 (**permalink**) 02-24-05, 02:02

Quote:

IBM should have some faster ways as they have it for MF.

And what might they be?

James Campbell