Page Size
User with tables having row sizes exceeding page size asked whether compression could reduce row sizes and whether compression works with changed dbspace page sizes. Expert confirmed compression reduces row size on disk but requires separate licensing. Maximum supported page size is 16K; supported pages are multiples of platform default (4K on AIX/Windows/MacOS, 2K elsewhere).
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, everybody. I talked about this subject before, but I'm not sure what is the best solution for my environment. I have a lot of table that have the row size bigger than page size. I've been thinking about change the dbspace size, use a clob or blob to store those data. I have a idea and would like to know your opinion. Compress resource can be a good option to reduce tyhe row size. Does compress algorithm can reduce the row size? thanks a lot, André Luiz Rufino
Yes, compression will reduce the size of a row on disk, however, compression is not included in the engine for free, you have to have licensed compression separately. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jun 26, 2013 at 9:19 AM, André Luiz Rufino <andre_rufino@msn.com>wrote: > Hi, everybody. > I talked about this subject before, but I'm not sure what is the best > solution > for my environment. I have a lot of table that have the row size bigger > than > page size. I've been thinking about change the dbspace size, use a clob or > blob to store those data. > I have a idea and would like to know your opinion. Compress resource can > be a > good option to reduce tyhe row size. Does compress algorithm can reduce the > row size? > thanks a lot, > André Luiz Rufino > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b34419a912db604e00f31d3
Just one more question. May I use the compression feature with dbspace with page size changed ? What is the page size limit in a 11.7 enterprise version ? > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: Page Size [30666] > Date: Wed, 26 Jun 2013 10:09:43 -0400 > > Yes, compression will reduce the size of a row on disk, however, > compression is not included in the engine for free, you have to have > licensed compression separately. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Wed, Jun 26, 2013 at 9:19 AM, André Luiz Rufino > <andre_rufino@msn.com>wrote: > > > Hi, everybody. > > I talked about this subject before, but I'm not sure what is the best > > solution > > for my environment. I have a lot of table that have the row size bigger > > than > > page size. I've been thinking about change the dbspace size, use a clob or > > blob to store those data. > > I have a idea and would like to know your opinion. Compress resource can > > be a > > good option to reduce tyhe row size. Does compress algorithm can reduce the > > row size? > > thanks a lot, > > André Luiz Rufino > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --047d7b34419a912db604e00f31d3 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Not sure I understand this last question. The supported page sizes are any multiple of the platform's default page size (so 4K on AIX, Windows, and MacOS X and 2K on all other platforms). Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jun 26, 2013 at 10:13 AM, André Luiz Rufino <andre_rufino@msn.com>wrote: > Just one more question. May I use the compression feature with dbspace with > page size changed ? What is the page size limit in a 11.7 enterprise > version ? > > > To: ids@iiug.org > > From: art.kagel@gmail.com > > Subject: Re: Page Size [30666] > > Date: Wed, 26 Jun 2013 10:09:43 -0400 > > > > Yes, compression will reduce the size of a row on disk, however, > > compression is not included in the engine for free, you have to have > > licensed compression separately. > > > > Art > > > > Art S. Kagel > > Advanced DataTools (www.advancedatatools.com) > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > > other organization with which I am associated either explicitly, > > implicitly, or by inference. Neither do those opinions reflect those of > > other individuals affiliated with any entity with which I am affiliated > nor > > those of the entities themselves. > > > > On Wed, Jun 26, 2013 at 9:19 AM, André Luiz Rufino > > <andre_rufino@msn.com>wrote: > > > > > Hi, everybody. > > > I talked about this subject before, but I'm not sure what is the best > > > solution > > > for my environment. I have a lot of table that have the row size bigger > > > than > > > page size. I've been thinking about change the dbspace size, use a > clob or > > > blob to store those data. > > > I have a idea and would like to know your opinion. Compress resource > can > > > be a > > > good option to reduce tyhe row size. Does compress algorithm can reduce > the > > > row size? > > > thanks a lot, > > > André Luiz Rufino > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --047d7b34419a912db604e00f31d3 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013c676004bd6704e00fa74d
Oops, the maximum page size is 16K either way. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jun 26, 2013 at 10:41 AM, Art Kagel <art.kagel@gmail.com> wrote: > Not sure I understand this last question. The supported page sizes are > any multiple of the platform's default page size (so 4K on AIX, Windows, > and MacOS X and 2K on all other platforms). > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > > On Wed, Jun 26, 2013 at 10:13 AM, André Luiz Rufino <andre_rufino@msn.com>wrote: > >> Just one more question. May I use the compression feature with dbspace >> with >> page size changed ? What is the page size limit in a 11.7 enterprise >> version ? >> >> > To: ids@iiug.org >> > From: art.kagel@gmail.com >> > Subject: Re: Page Size [30666] >> > Date: Wed, 26 Jun 2013 10:09:43 -0400 >> > >> > Yes, compression will reduce the size of a row on disk, however, >> > compression is not included in the engine for free, you have to have >> > licensed compression separately. >> > >> > Art >> > >> > Art S. Kagel >> > Advanced DataTools (www.advancedatatools.com) >> > Blog: http://informix-myview.blogspot.com/ >> > >> > Disclaimer: Please keep in mind that my own opinions are my own opinions >> > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any >> > other organization with which I am associated either explicitly, >> > implicitly, or by inference. Neither do those opinions reflect those of >> > other individuals affiliated with any entity with which I am affiliated >> nor >> > those of the entities themselves. >> > >> > On Wed, Jun 26, 2013 at 9:19 AM, André Luiz Rufino >> > <andre_rufino@msn.com>wrote: >> > >> > > Hi, everybody. >> > > I talked about this subject before, but I'm not sure what is the best >> > > solution >> > > for my environment. I have a lot of table that have the row size >> bigger >> > > than >> > > page size. I've been thinking about change the dbspace size, use a >> clob or >> > > blob to store those data. >> > > I have a idea and would like to know your opinion. Compress resource >> can >> > > be a >> > > good option to reduce tyhe row size. Does compress algorithm can >> reduce >> the >> > > row size? >> > > thanks a lot, >> > > André Luiz Rufino >> > > >> > > >> > > >> > > >> > >> >> ******************************************************************************* >> > > Forum Note: Use "Reply" to post a response in the discussion forum. >> > > >> > > >> > >> > --047d7b34419a912db604e00f31d3 >> > >> > >> > >> >> ******************************************************************************* >> > Forum Note: Use "Reply" to post a response in the discussion forum. >> > >> >> >> >> ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --089e013d174246b28404e00fa851
Yes, and the upper limit is 16K, for any dbspace pagesize. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Informix Senior DBA - Orizon Brasil BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: Page Size [30670] > Date: Wed, 26 Jun 2013 10:42:33 -0400 > > Not sure I understand this last question. The supported page sizes are any > multiple of the platform's default page size (so 4K on AIX, Windows, and > MacOS X and 2K on all other platforms). > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > On Wed, Jun 26, 2013 at 10:13 AM, André Luiz Rufino > <andre_rufino@msn.com>wrote: > > > Just one more question. May I use the compression feature with dbspace with > > page size changed ? What is the page size limit in a 11.7 enterprise > > version ? > > > > > To: ids@iiug.org > > > From: art.kagel@gmail.com > > > Subject: Re: Page Size [30666] > > > Date: Wed, 26 Jun 2013 10:09:43 -0400 > > > > > > Yes, compression will reduce the size of a row on disk, however, > > > compression is not included in the engine for free, you have to have > > > licensed compression separately. > > > > > > Art > > > > > > Art S. Kagel > > > Advanced DataTools (www.advancedatatools.com) > > > Blog: http://informix-myview.blogspot.com/ > > > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > > > other organization with which I am associated either explicitly, > > > implicitly, or by inference. Neither do those opinions reflect those of > > > other individuals affiliated with any entity with which I am affiliated > > nor > > > those of the entities themselves. > > > > > > On Wed, Jun 26, 2013 at 9:19 AM, André Luiz Rufino > > > <andre_rufino@msn.com>wrote: > > > > > > > Hi, everybody. > > > > I talked about this subject before, but I'm not sure what is the best > > > > solution > > > > for my environment. I have a lot of table that have the row size bigger > > > > than > > > > page size. I've been thinking about change the dbspace size, use a > > clob or > > > > blob to store those data. > > > > I have a idea and would like to know your opinion. Compress resource > > can > > > > be a > > > > good option to reduce tyhe row size. Does compress algorithm can reduce > > the > > > > row size? > > > > thanks a lot, > > > > André Luiz Rufino > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --047d7b34419a912db604e00f31d3 > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e013c676004bd6704e00fa74d > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >