Ansicht
Dokumentation
05336 - Database Size for ASCII version
Addresses (Business Address Services) TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by SAP AG.
Database Size for ASCII version
Hi,When we moved from UNIX DB size also went down a bit. The degrade in ammount
is probably due to deleted records old DB logfiles etc. - After a short
while on AS400 size was about the same as I remember (this was in 1996).
regards
Klaus
-----Oprindelig meddelelse-----
Fra: Gueldenpfennig, Volker [mailto:volker.gueldenpfennigZs...]
Sendt: 11. marts 2002 18:10
Til: 'gary.bellZs...'
Cc: 'DoNotReply@consolut.eu'
Emne: RE: Database Size for ASCII version
Hello Gary,
you can expect about the same maount of DASD usage. I shortly heard about a
migration with 60GB on iSeries and 51GB on NT (don't know the DB now).
So, it should be nearly the same.
Regards
Volker
-----Original Message-----
From: Bell,Gary [mailto:gary.bellZs...]
Sent: Montag, 11. März 2002 16:27
To: 'DoNotReply@consolut.eu'
Subject: RE: Database Size for ASCII version
Quick question on this.
If you migrate off the AS400/iseries to NT or Unix can you expect the same
growth/sizing?
-----Original Message-----
From: Gueldenpfennig, Volker [mailto:volker.gueldenpfennigZs...]
Sent: Saturday, March 09, 2002 2:18 AM
To: 'Jim Doll '
Cc: 'DoNotReply@consolut.eu'
Subject: RE: Database Size for ASCII version
Hi Jim,
Yes, you are right. The numbers are still "packed".
That means, we do not change any decimal or binary representations in the
system. This is not necesary for Unicode. Unicode only changes the
representation of charcter fields.
As SAP has in R3 about 2/3 of the data stored in character fields, the
database grows by about +66% when transfering to the ASCII solution, which
means, that all transparent tables (with latin-1) represent full unnicode
already. This will improve in pure latin-1 systems the migration to unicode
a lot, because only the pool- and cluster-tables will have to be converted
to unicode then.
In BW a large part of the data resides in the fact tables. These tables only
contain numeric data. This is because we do only use artificial keys here.
Because of this, these tables won't grow at all. That's why the increase of
BW databases is less (about +50%) than for R3 databases.
ope this clarifies your questions, oterwise, please let me know. I think it
is necessary, that this is fully understood.
Regards
Volker
-----Original Message-----
From: Jim Doll
To: Gueldenpfennig, Volker
Sent: 08.03.02 23:15
Subject: RE: Database Size for ASCII version
Someday, I'll have to have someone explain this to me.... If it is
basically a double-byte character set, why isn't it twice as big? Are
numbers still "packed", and only take a half-byte per number?
>>> volker.gueldenpfennigZs... 03/08/02 02:43AM >>>
Hi Jay,
you can expect for R3 a 70% bigger database in ASCII. For BW it is about
+50% .
For the other types of systems I don't have real experiences by now, but
I
would guess in the area of 70% .
Regards
Volker
Have a look to our homepage at: http://www.consolut.net
<http://www.consolut.net>
DoNotReply@consolut.eu
Your use of consolut is subject to http://www.consolut.net
<http://www.consolut.net>
Have a look to our homepage at: http://www.consolut.net
<http://www.consolut.net>
DoNotReply@consolut.eu
Your use of consolut is subject to http://www.consolut.net
<http://www.consolut.net>
consolut Sponsor
<http://rd.consolut.net/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050073
89:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1015866629%
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007389:HM/A=847665/R=1>
<http://us.adserver.consolut.net/l?M=215002.1818248.3328688.1261774/D=egroupmai
l/S=1705007389:HM/A=847665/rand=406983496>
Have a look to our homepage at: http://www.consolut.net
<http://www.consolut.net>
DoNotReply@consolut.eu
Your use of consolut is subject to the consolut Terms of Service
<http://www.consolut.net> .
[Non-text portions of this message have been removed]
Durban Tours - Südafrika Safari
rdisp/max_wprun_time - Maximum work process run time SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 6970 Date: 20240416 Time: 084026 sap01-206 ( 5 ms )
