Hello all,
Were using OE10.2B on Windows server 2008 64bit.
Firstly, i'm probably going about this the wrong way so a nudge in the right direction would be nice. I'm trying to determine whether a table is sat in the wrong storage area and would benefit by being moved to something a little more homely.
My .st file looks a little like this:
and my tabanalys looks like this:
From my misguided understanding;
Area 7 has 64 records per block
Area 7 has 64 blocks per cluster
We have a 4K block size
Does that mean each record has an average size of 4096/64 ? 64bytes? or even 62.5?
If, by some miracle i'm on the right track here, does that mean that at least half of the tables above are in the wrong area.
Thanks in advance.
BS
Were using OE10.2B on Windows server 2008 64bit.
Firstly, i'm probably going about this the wrong way so a nudge in the right direction would be nice. I'm trying to determine whether a table is sat in the wrong storage area and would benefit by being moved to something a little more homely.
My .st file looks a little like this:
Code:
#
b C:\db\test.b1 f 1024000
b C:\db\test.b2
#
d "Schema Area":6,32;1 C:\db\test.d1 f 128000
d "Schema Area":6,32;1 C:\db\test.d2
#
d "Data Area":7,64;64 C:\db\test_7.d1 f 2048000
d "Data Area":7,64;64 C:\db\test_7.d2
#
d "Area8":8,32;64 C:\db\test_100.d1 f 2048000
d "Area8":8,32;64 C:\db\test_100.d2
#
d "Area9":9,64;64 C:\db\test_101.d1 f 2048000
d "Area9":9,64;64 C:\db\test_101.d2
#
d "Area10":10,128;64 C:\db\test_102.d1 f 2048000
d "Area10":10,128;64 C:\db\test_102.d2
and my tabanalys looks like this:
Code:
RECORD BLOCK SUMMARY FOR AREA "Data Area" : 7
-------------------------------------------------------
-Record Size (B)- ---Fragments--- Scatter
Table Records Size Min Max Mean Count Factor Factor
PUB.table1 1 57.0B 57 57 57 1 1.0 1.0
PUB.table2 95890 6.5M 64 276 71 95890 1.0 1.0
PUB.table3 101789 18.2M 113 317 187 101789 1.0 1.0
PUB.table4 57 3.8K 50 81 68 57 1.0 1.3
PUB.table5 95 10.6K 65 236 114 95 1.0 1.0
PUB.table6 511 23.3K 32 50 46 511 1.0 1.0
PUB.table7 39 1.7K 29 69 44 39 1.0 1.0
PUB.table8 1 35.0B 35 35 35 1 1.0 1.0
PUB.table9 11 1.5K 132 151 144 11 1.0 1.0
PUB.table10 1646 358.3K 196 255 222 1646 1.0 1.0
PUB.table11 33 52.3K 216 15099 1624 36 1.0 1.0
From my misguided understanding;
Area 7 has 64 records per block
Area 7 has 64 blocks per cluster
We have a 4K block size
Does that mean each record has an average size of 4096/64 ? 64bytes? or even 62.5?
If, by some miracle i'm on the right track here, does that mean that at least half of the tables above are in the wrong area.
Thanks in advance.
BS