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 Logical VOlume 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
============================================

[Chris C. Guevarra · Accepted solution]

Hi daedalus,

Im not familiar with sybase command, but our usual procedure is.

1. Create the raw device you intend to use in SAM or command line.

2. Change the permissions of the raw devices to sybase:sybase

3. Add raw devices
( eg. /dev/vgtfxase/ret8r8 ) created in OS to tables of devices in sybase using "add device" command.

Make sure the volume group is online to view the logical volumes.
# vgchange -a y vgtfxase

Regards,
Chris

[Daedalus_1]

Thx Chris

How every, would like to know whether it is normal to not seeing the raw volume in the Volume Group Screen in SAM ?


Thanks
Daedalus

[Chris C. Guevarra]

Hi Daedelus,

The volume group should be online to be able to see its logical volumes in SAM.

to make a volume group online issue
#vgchange -a y vgname

Use vgdisplay to check if it is already online.

Regards,
Chris