page size of an existing dbspace

Posted in 2006

Sobha Rani Cheruku — Fri, 17 Feb 2006 06:50:16 — source: IIUG Forums & Mailing Lists

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 ---------------------------------------

↪ replying to Sobha Rani Cheruku

Model-Bosch, Tilman — Fri, 17 Feb 2006 08:37:59 — source: IIUG Forums & Mailing Lists

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.

↪ replying to Sobha Rani Cheruku

Martin Fuerderer — Fri, 17 Feb 2006 10:03:24 — source: IIUG Forums & Mailing Lists

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. >

↪ replying to Sobha Rani Cheruku

Jonathan Leffler — Sat, 18 Feb 2006 18:36:32 — source: IIUG Forums & Mailing Lists

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/

Glossary

dbspace