page size of an existing dbspace
Sobha Rani Cheruku asked how to change the page size of an existing dbspace. Tilman Model-Bosch, Martin Fuerderer and Jonathan Leffler all said it is not possible; page size is set at creation. In IDS 10 you can create a new dbspace with a bigger page size and move tables, or back up, empty, drop and rebuild the dbspace.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi every one , How can we change the page size of existing dbspace ? If possible , what is the command used ? regards, Sobha --------------------------------------- Sobha Rani Cheruku IBM India Software Labs Lab Services Team EGL Block B,4th Floor Direct: 91-80-51925356 Extn: 5356 Mobile:91-9886792481 Email:scheruku@in.ibm.com ---------------------------------------
Sobha Rani wrote > How can we change the page size of existing dbspace ? > If possible , what is the command used ? > No it is not possible. In IDS 10.00 you may create a new dbspace witgh a bigger pagesize and then move the tables from one dbspace to the new one. So it is possible to have dbspaces with different pagesizes in one IDS instance.
Hi, as far as I know, this is not possible. Only during dbspace creation can you set the page size for that dbspace. Ragrds, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management ids-bounces@iiug.org wrote on 17.02.2006 07:50:17: > > Hi every one , > How can we change the page size of existing dbspace ? > If possible , what is the command used ? > > regards, > Sobha > --------------------------------------- > Sobha Rani Cheruku > IBM India Software Labs > Lab Services Team > EGL Block B,4th Floor > Direct: 91-80-51925356 > Extn: 5356 > Mobile:91-9886792481 > Email:scheruku@in.ibm.com > --------------------------------------- > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
On 2/16/06, Sobha Rani .... <scheruku@in.ibm.com> wrote: > How can we change the page size of existing dbspace ? > If possible , what is the command used ? Succinctly, you can't. You'd have to backup the data from the dbspace, remove all the objects from it, drop it, and rebuild it with the new desired page size. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/