Bob,
We too ran into the same problem with our SAP tablespaces. For us, the PSAPBTABD tablespace quickly reached the 64GB limit. The solution was to create a new tablespace using a larger pagesize. We then migrated the largest tables in PSAPBTABD to the new tablespace using export and load. Unfortunately there is no utility to migrate a tablespace from one pagesize to a larger pagesize. The "export and load" process is the only option.
Paul
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 1:52 PM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Tbl Spc - 4k Pages/64 gig limitation
Howdy,
I've got some legacy parameter settings (from DB2 Common Server ver. 2.1)
in my production SAP database tablespaces, one of which is currently at 59
gigs. I'm bumping up on the 64 gig limit. I'm hoping someone can help me
better understand the size limitation, and how best to deal with it. I'm
hoping there's a way other than exporting the data, dropping and recreating
the tablespace (and its bufferpool), then importing the data again. This is
an SAP database and the tablespace in question holds the transaction data.
There are thousands of tables in the tablespace.
Any thoughts would be greatly appreciated.
Regards,
-Bob Simard
#####################
Robert A. Simard
SAP Basis Architect
Tech. Services
Haelth Net, Inc.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
