64GB limit for 4k page sized tablespace

[Patrick Tan]

I have a tablespace which is approaching 64 GB (for a single table), i
understand that for 4k page sized tablespaces, this is sized tablespace,
what's the best way / fastest way to do it ? can redirect restore change
page size ? I am looking for suggestions.

thanks!
Patrick Tan

[Matt Emmerton]

"Patrick Tan" <pa*********@symptico.ca> wrote in message
news:yh********************@news20.bellglobal.com. ..

I have a tablespace which is approaching 64 GB (for a single table), i
understand that for 4k page sized tablespaces, this is sized tablespace,
what's the best way / fastest way to do it ? can redirect restore change
page size ? I am looking for suggestions.

Redirect restore cannot change page size.

You have two alternatives.
1) Export the data, recreate the table with a larger page size, and import
the data
2) Investigate using the UNION ALL view approach to combine two (or more)
tables into one "virtual" table. This only works if your data is easily
partitionable. You need v8 FP4 for this as well.

--
Matt Emmerton
DB2 OLTP Performance
IBM Toronto Lab

[Ian]

Patrick Tan wrote:

I have a tablespace which is approaching 64 GB (for a single table), i
understand that for 4k page sized tablespaces, this is sized tablespace,
what's the best way / fastest way to do it ? can redirect restore change
page size ? I am looking for suggestions.

You can't change a tablespace's page size during a restore. You have 2
options:

1) Unload / reload data into the table after moving it to a tablespace
with a larger page size. (Be aware of the limit of 255 rows per page)

2) Move to a partitioned environment, where the limit is 64 Gb per
partition. Of course this requies money (to buy the data partitioning
feature), as well as time (to actually partition the data).
Good luck
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----