Logical Volume used by Sybase

[Daedalus_1]

Hi

I found that there are some files which was created by sybase are not displayed on the Volume Group screen of SAM.

1. In this case, can I know which logical volume or Physical Device it's actually using ?

2. Say, if I want to create another DB device for my sybase, what procedure I've to perform on the OS and what info I've to give sybase ?


Many Thanks
Daedalus


============================================
# pwd
/dev/vgtfxase
# ll
total 0
brw-r----- 1 root sys 64 0x01000e Mar 12 2003 et8data
brw-r----- 1 root sys 64 0x01000f Mar 12 2003 et8log
brw-r----- 1 sybase sybase 64 0x010004 Jan 17 2001 et8r1
brw------- 1 sybase sybase 64 0x01000d Sep 19 2001 et8r10
brw-r----- 1 sybase sybase 64 0x010005 Jan 17 2001 et8r2
brw-r----- 1 sybase sybase 64 0x010006 Jan 17 2001 et8r3
brw-r----- 1 sybase sybase 64 0x010007 Jan 17 2001 et8r4
brw-r----- 1 sybase sybase 64 0x010008 Jan 17 2001 et8r5
brw-r----- 1 sybase sybase 64 0x010009 Jan 17 2001 et8r6
brw-r----- 1 sybase sybase 64 0x01000a Jan 17 2001 et8r7
brw-r----- 1 sybase sybase 64 0x01000b Apr 2 2001 et8r8
brw-r----- 1 sybase sybase 64 0x01000c Apr 2 2001 et8r9
crw-rw-rw- 1 root sys 64 0x010000 Jan 12 2001 group
brw-r----- 1 root sys 64 0x010001 Sep 8 2001 lvol1
brw-r----- 1 root sys 64 0x010002 Jan 12 2001 lvol2
brw------- 1 root sys 64 0x010013 Apr 9 2001 lvol3
brw-r----- 1 sybase sybase 64 0x010003 Jan 17 2001 rawvol
crw-r----- 1 sybase sybase 64 0x01000e Mar 12 2003 ret8data
crw-r----- 1 sybase sybase 64 0x01000f Mar 12 2003 ret8log
crw-r----- 1 sybase sybase 64 0x010004 Jan 17 2001 ret8r1
crw------- 1 sybase sybase 64 0x01000d Sep 19 2001 ret8r10
crw-r----- 1 sybase sybase 64 0x010005 Jan 17 2001 ret8r2
crw-r----- 1 sybase sybase 64 0x010006 Jan 17 2001 ret8r3
crw-r----- 1 sybase sybase 64 0x010007 Jan 17 2001 ret8r4
crw-r----- 1 sybase sybase 64 0x010008 Jan 17 2001 ret8r5
crw-r----- 1 sybase sybase 64 0x010009 Jan 17 2001 ret8r6
crw-r----- 1 sybase sybase 64 0x01000a Jan 17 2001 ret8r7
crw-r----- 1 sybase sybase 64 0x01000b Apr 2 2001 ret8r8
crw-r----- 1 sybase sybase 64 0x01000c Apr 2 2001 ret8r9
crw-r----- 1 sybase sybase 64 0x010001 Jan 12 2001 rlvol1
crw-r----- 1 sybase sybase 64 0x010002 Jan 12 2001 rlvol2
crw------- 1 sybase sybase 64 0x010013 Apr 9 2001 rlvol3
crw-r----- 1 sybase sybase 64 0x010003 Jan 17 2001 rrawvol
============================================

[Steven E. Protter]

determine which logical volume is being used by sybase. If its a filesystem you can see whats going on as far as which disks as follows:

lvdisplay -v /dev/vg01/et8r1

just put in a real logical volume name.

If however sybase is using raw disk, you need to use a sybase utilty to display contents.

Based on the fact that I admin Software AG Adabas, a database that uses raw or cooked filesystems, I would say that the entire volume group is devoted to sybase.

the lvdisplay command will tell you what disks its using. The database utility will tell you a little more.

SEP