Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Logical Volume used by Sybase

Daedalus_1
Advisor

Logical Volume used by Sybase

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
============================================
1 REPLY
Steven E. Protter
Exalted Contributor

Re: Logical Volume used by Sybase

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com