dbsizes/chunk sizes/raw partitions
Posted in 1997
We recently did a new install of SAP R/3 3.0f on a Solaris 2.51
system. I used the Solaris DiskSuite tools to mirror ten 4.2
Gig drives into five 4.2G 'metadevices'. These raw metadevices
where set up for the Informix 7.2 DB for SAP. I noticed as
I increased some dbspaces that I did not seem to have as much
space as I though I should. It appears to me that I only have
about one half of my raw space available to Informix. Is there a
problem with Informix using a 4.2G 'raw' device?
Thank you,
Richard Moldovan
moldovan@mmsi.com
The following are outputs of some diagnostics I have run:
Partial output from Solaris DiskSuite metastat:
d10: Mirror
Submirror 0: d0
State: Okay
Submirror 1: d5
State: Okay
Pass: 1
Read option: roundrobin (default)
Write option: parallel (default)
Size: 8378640 blocks
d0: Submirror of d10
State: Okay
Size: 8378640 blocks
Stripe 0:
Device Start Block Dbase State Hot Spare
c0t3d0s7 0 No Okay
d5: Submirror of d10
State: Okay
Size: 8378640 blocks
Stripe 0:
Device Start Block Dbase State Hot Spare
c1t3d0s7 0 No Okay
Same output for d11-d14
*******************************************************************
Output from ls -lR command at /informix/DEV/sapdata:
total 10
drwxrwxr-x 2 root other 512 Aug 8 13:40 physdev1
drwxrwxr-x 2 root other 512 Aug 8 13:40 physdev2
drwxrwxr-x 2 root other 512 Aug 8 13:40 physdev3
drwxrwxr-x 2 root other 512 Aug 8 13:41 physdev4
drwxrwxr-x 2 root other 512 Aug 8 13:41 physdev5
./physdev1:
total 2
lrwxrwxrwx 1 root other 16 Aug 8 13:40 data1 ->
/dev/md/rdsk/d10
./physdev2:
total 2
lrwxrwxrwx 1 root other 16 Aug 8 13:40 data2 ->
/dev/md/rdsk/d11
./physdev3:
total 2
lrwxrwxrwx 1 root other 16 Aug 8 13:40 data3 ->
/dev/md/rdsk/d12
./physdev4:
total 2
lrwxrwxrwx 1 root other 16 Aug 8 13:41 data4 ->
/dev/md/rdsk/d13
./physdev5:
total 2
lrwxrwxrwx 1 root other 16 Aug 8 13:41 data5 ->
/dev/md/rdsk/d14
*******************************************************************
Output from onstat -d
Chunks
address chk/dbs offset size free bpages flags pathname
10c5c170 1 1 8 75000 20125 PO-
/informix/DEV/sapdata/physdev1/data1
10c5c438 2 2 8 250000 18517 PO-
/informix/DEV/sapdata/physdev2/data2
10c5c510 3 3 8 25106 53 PO-
/informix/DEV/sapdata/physdev3/data3
10c5c5e8 4 4 8 50000 49947 PO-
/informix/DEV/sapdata/physdev4/data4
10c5c6c0 5 5 8 350000 0 PO-
/informix/DEV/sapdata/physdev5/data5
10c5c798 6 6 75008 450000 163552 PO-
/informix/DEV/sapdata/physdev1/data1
10c5c870 7 7 250008 330000 5 PO-
/informix/DEV/sapdata/physdev2/data2
10c5c948 8 8 25114 175106 53 PO-
/informix/DEV/sapdata/physdev3/data3
10c5ca20 9 9 50008 400000 89428 PO-
/informix/DEV/sapdata/physdev4/data4
10c5caf8 10 10 350008 200000 19030 PO-
/informix/DEV/sapdata/physdev5/data5
10c5cbd0 11 11 525008 50000 4960 PO-
/informix/DEV/sapdata/physdev1/data1
10c5cca8 12 12 200220 25000 15963 PO-
/informix/DEV/sapdata/physdev3/data3
10c5cd80 13 13 450008 50000 15179 PO-
/informix/DEV/sapdata/physdev4/data4
10c5ce58 14 7 225220 820000 124130 PO-
/informix/DEV/sapdata/physdev3/data3
10c5cf30 15 14 500008 20000 11137 PO-
/informix/DEV/sapdata/physdev4/data4
10c5d008 16 15 520008 10000 9854 PO-
/informix/DEV/sapdata/physdev4/data4
10c5d0e0 17 16 530008 10000 9891 PO-
/informix/DEV/sapdata/physdev4/data4
10c5d1b8 18 2 580008 150000 149997 PO-
/informix/DEV/sapdata/physdev2/data2
10c5d290 19 11 575008 100000 99997 PO-
/informix/DEV/sapdata/physdev1/data1
10c5d368 20 5 550008 200000 17 PO-
/informix/DEV/sapdata/physdev5/data5
10c5d440 21 10 730008 50000 49997 PO-
/informix/DEV/sapdata/physdev2/data2
10c5d518 22 2 780008 150000 149997 PO-
/informix/DEV/sapdata/physdev2/data2
10c5d5f0 23 5 750008 150000 120017 PO-
/informix/DEV/sapdata/physdev5/data5
10c5d6c8 24 6 675008 200000 199997 PO-
/informix/DEV/sapdata/physdev1/data1
10c5d7a0 25 9 540008 200000 199997 PO-
/informix/DEV/sapdata/physdev4/data4
10c5d878 26 11 875008 100000 99997 PO-
/informix/DEV/sapdata/physdev1/data1
10c5d950 27 12 740008 200000 199997 PO-
/informix/DEV/sapdata/physdev4/data4
14982280 28 5 900008 148567 148564 PO-
/informix/DEV/sapdata/physdev5/data5
28 active, 2047 maximum
Total of 'size' column = 4,938,779 (x 2048) =10,114,619,392
*******************************************************************
Output from sapdba/dbspaces/dbreports/list chunk information:
logdbs 3 data3 350212 106 0.0 106
106
physdbs 3 data3 50212 106 0.2 106
106
psapbtab 1 data1 900000 327104 36.3 327104
327104
psapbtab 1 data1 400000 399994 100.0 399994
399994
psapclu 2 data2 300000 299994 100.0 299994
299994
psapclu 2 data2 300000 299994 100.0 299994
299994
psapclu 2 data2 500000 37034 7.4 37034
37034
psapddic 1 data1 200000 199994 100.0 199994
199994
psapddic 1 data1 100000 9920 9.9 9920
9920
psapddic 1 data1 200000 199994 100.0 199994
199994
psapdocu 4 data4 40000 22274 55.7 22274
22274
psapel30f 2 data2 100000 99994 100.0 99994
99994
psapel30f 5 data5 400000 38060 9.5 38060
38060
psapes30f 3 data3 1640000 248260 15.1 248260
248260
psapes30f 2 data2 660000 10 0.0 10
10
psapload 4 data4 20000 19708 98.5 19708
19708
psappool 5 data5 400000 34 0.0 34
34
psappool 5 data5 297134 297128 100.0 297128
297128
psappool 5 data5 700000 0 0.0 0
0
psappool 5 data5 300000 240034 80.0 240034
240034
psapprot 4 data4 400000 399994 100.0 399994
399994
psapprot 3 data3 50000 31926 63.9 21104
15963
psapsource 4 data4 100000