Hi Bob, hi Paul
there are two very good hints from SAP
to solve this problems:
1.� 0,45�Conversion of tables into another tablespace
Note Number: 0362325�| Application Area: BC-DB-DB6�| Release: 40B - 46D
2.� 0,39�DB6: Move tables to other DB2 tablespaces
Note Number: 0136702�| Application Area: BC-DB-DB6�| Release: *
It worked as designed - our SAP-Retail system -, one table about 29 GB
large
we move them from one tablespace PSAPSTABD with 4k pages
to a new one ZSAPSTABD with 16k pages. All in all
it took 20 hour to move this table (IBM SP/2 S80 and ESS).
The same worked for use in our FI/CO R/3 System.
The developer wrote a fix for this db6conv, ask SAP for the very new
Version.
best regards
Joachim M�ller
--------------------------------------------------------
Datenbanken
DOUGLAS Informatik & Service GmbH
Kabeler Stra�e 4
D-58099 Hagen
Tel.:+49-2331-690-249
Fax:+49-2331-690-78-249
Mobile: +49-170-2221-249
mailto:[EMAIL PROTECTED]
http://www.douglas-informatik.de
Robert.A.Simard@health
.net An: [EMAIL PROTECTED]
Gesendet von: Kopie:
[EMAIL PROTECTED] Thema: DB2EUG: Tbl Spc - 4k
Pages/64 gig limitation
a.best.com
04.06.01 18:51
Bitte antworten an
db2eug
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
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
