Sybase 12.0 osdevices and the LVM

[Timothy Alexander]

On one of our HP boxes it appears that the total size of the osdevice files created by Sybase actually exceed the amount of the logical volume they reside on. Does Sybase play fair with the OS, or is something hinky going on?

tst-syb2[1] cd /sybakup/osDevices
tst-syb2[3] ls -ltr
total 10685644
-rw-rw-rw- 1 sybadmin other 2147481600 May 4 10:22 osData6
-rw-rw-rw- 1 sybadmin other 2097152000 May 4 10:25 osData8
-rw-rw-rw- 1 sybadmin other 2097152000 May 4 10:27 osData9
-rw-rw-rw- 1 sybadmin other 2147481600 Jul 19 11:35 osData7
-rw-rw-rw- 1 sybadmin other 104857600 Jul 26 09:58 osLog2
-rw-rw-rw- 1 sybadmin other 2147481600 Sep 10 10:09 osData3
-rw-rw-rw- 1 sybadmin other 2147481600 Oct 22 01:53 osData5
-rw-rw-rw- 1 sybadmin other 2147481600 Oct 22 05:48 osData4
-rw-rw-rw- 1 sybadmin other 104857600 Oct 22 16:17 osLog1
-rw-rw-rw- 1 sybadmin other 524288000 Oct 22 16:17 osData1
-rw-rw-rw- 1 sybadmin other 786432000 Oct 22 16:26 osTmp1

tst-syb2[109] bdf .
Filesystem kbytes used avail %used Mounted on
/dev/vgRAID00/sybakup
6144000 4727744 1327999 78% /sybakup

[harry d brown jr]

I think bdf is truncating the 1 in front of the 6144000. Instead of bdf, do a lvdisplay -v /dev/vgRAID00/sybakup |more, then look at the LV size.

[Timothy Alexander]

Nope, it looks about right, the LV size is 6000 which matches bdf.

-Timothy

[harry d brown jr]

Timothy,

how about an "ls -sil" on that directory.

[Timothy Alexander]

tst-syb2:tpolus:/sybakup/osDevices >ls -sil
total 9417452
6 1024128 -rw-rw-rw- 1 sybadmin other 524288000 Oct 24 10:03 osData1
491 4098052 -rw-rw-rw- 1 sybadmin other 2147481600 Sep 10 10:09 osData3
492 1678708 -rw-rw-rw- 1 sybadmin other 2147481600 Oct 24 06:12 osData4
493 670644 -rw-rw-rw- 1 sybadmin other 2147481600 Oct 23 11:21 osData5
499 204816 -rw-rw-rw- 1 sybadmin other 104857600 Oct 22 16:17 osLog1
501 204800 -rw-rw-rw- 1 sybadmin other 104857600 Jul 26 09:58 osLog2
5 1536304 -rw-rw-rw- 1 sybadmin other 786432000 Oct 24 10:08 osTmp1

[harry d brown jr]

Timothy,

first thing, note the block size of the files, take them and multiply by 512. Note that the file "osData4 " ,the byte count show's its larger than it really is.

Totaling up the "blocks", and multiplying by 512 you get 4,821,735,424 bytes in use which is roughly 80% of 6GB.


Second, make sure you have the latest patches installed.



live free or die

harry

[Timothy Alexander]

Well that helps some, but this box is set to the March 2001 patch release. While I could upgrade them it seems odd that this is the only box that I'd see this on. Mainly I was wondering if anyone had come across this specifically with Sybase device files, that somehow they trick the OS into allocating more space than they actually take up.