UDB v9.1 on Linux - tablespace question

Bruce Lightsey

UDB v9.1 on Linux - tablespace question
We have discovered that we will need a large tablespace to be > 2
terrabytes in size. Said tablespace is currently defined with 4k pages and
we would like to move to 16k or 32k page size.
What would be the preferred method to do this - very little is loaded right
now and I'd like to get this cured before serious loading begins.
FYI this is to store raster data in a GIS implementation.

Thanks,
Bruce

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Dan Tuck

Re: UDB v9.1 on Linux - tablespace question
(in response to Bruce Lightsey)
Changing tablespace page size means dropping and recreating the tablespace.
Or creating a near duplicate tablespace, with the new page size, and
corresponding objects.

On 1/19/07, Bruce Lightsey <[login to unmask email]> wrote:
>
> We have discovered that we will need a large tablespace to be > 2
> terrabytes in size. Said tablespace is currently defined with 4k pages and
> we would like to move to 16k or 32k page size.
> What would be the preferred method to do this - very little is loaded
> right
> now and I'd like to get this cured before serious loading begins.
> FYI this is to store raster data in a GIS implementation.
>
> Thanks,
> Bruce
>
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm