Kbase P18894: Where the differences in size lie on a DB created in V8 and
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/15/2003 |
|
Status: Unverified
GOAL:
Where the differences in size lie on a DB created in V8 and a one migrated to V9 ?
GOAL:
What are the differences in the backup size between a DB created in V8 and one migrated to V9 ?
FIX:
A V9 DB probkup and one of the same DB in V8 will differ in size due to the additional metaschema tables to support Areas and the SQL system tables.
Example:
Comparing a V8's Tabanalys against V9:
V9 V8 Size
Table Size Size Diference
_____ ____ ____ _________
PUB.Customer 11.1 11.1 0
PUB.Invoice 3.8 3.8 0
PUB.Item 4.3 4.3 0
PUB.Local-Def. 0.584 0.584 0
PUB.Order 9 9 0
PUB.Order-Line 20.1 20.1 0
PUB.Ref-Call 2.3 2.3 0
PUB.Salesrep 0.638 0.638 0
PUB.State 1.1 1.1 0
_Area 0.142 0.142
_AreaExtent 0.168 0.168
_Db 1.1 1.1 0
_Field 269.9 35.9 234
_Field-Trig 0.038 0.038 0
_File 24.8 3.5 21.3
_File-Trig 0.383 0.383 0
_Index 12.3 3.5 8.8
_Index-Field 13.4 4 9.4
_Sequence 0.222 0.217 0.005
_StorageObject 5.6 5.6
_Sysattachtbls 0 0
_Sysbigintstat 0 0
_Syscalctable 0.006 0.006
_Syscharstat 0 0
_Syschkcolusage 0 0
_Syschkconstrs 0 0
_Syscolauth 0 0
_Syscolstat 0 0
_Sysdatatypes 0.522 0.522
_Sysdatestat 0 0
_Sysdbauth 0.02 0.02
_Sysdblinks 0 0
_Sysfloatstat 0 0
_Sysidxstat 0 0
_Sysintstat 0 0
_Syskeycolusage 0 0
_Sysncharstat 0 0
_Sysnumstat 0 0
_Sysnvarcharst. 0 0
_Sysprocbin 0 0
_Sysproccolumns 8.6 8.6
_Sysprocedures 0.73 0.73
_Sysproctext 0 0
_Sysrealstat 0 0
_Sysrefconstrs 0 0
_Syssmintstat 0 0
_Syssynonyms 0 0
_Systabauth 11.6 11.6
_Systblconstrs 0 0
_Systblstat 0 0
_Systimestat 0 0
_Systinyintstat 0 0
_Systrigcols 0 0
_Systrigger 0 0
_Systsstat 0 0
_Sysvarcharstat 0 0
_Sysviews 6.2 6.2
_User 0 0 0
_View 0 0 0
_View-Col 0 0 0
_View-Ref 0 0 0
_____________________________________________________
408.653 101.56 307.093