- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Sybase devices - raw versus file system devices
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2001 10:04 AM
тАО10-29-2001 10:04 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2001 10:53 AM
тАО10-29-2001 10:53 AM
Re: Sybase devices - raw versus file system devices
As with any type of DB using raw devices, you have to come up with a backup strategy to back those raw volumes up. you also have to remember that they are raw, and won't show up in a bdf.
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2001 11:06 AM
тАО10-29-2001 11:06 AM
Re: Sybase devices - raw versus file system devices
Look at the threads below for more info.
http://us-support.external.hp.com/cki/bin/doc.pl/sid=0a87389b0118025d65/screen=ckiDisplayDocument?docId=200000046888132
http://us-support.external.hp.com/cki/bin/doc.pl/sid=0a87389b0118025d65/screen=ckiDisplayDocument?docId=200000052470361
http://us-support.external.hp.com/cki/bin/doc.pl/sid=1bbcb24f155955b579/screen=ckiDisplayDocument?docId=200000018911225
http://us-support.external.hp.com/cki/bin/doc.pl/sid=523acad805153ea3e3/screen=ckiDisplayDocument?docId=200000024631210
hope this helps.
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2001 11:15 AM
тАО10-29-2001 11:15 AM
SolutionMy understanding is that FC60 doesn't care if you use raw disk or a file system. It matters only for the system. So, eventually FC60 is going to use it's cache for any operations.
It's better to have filesystems than Raw devices. You can load OnlineJFS and enable mincache/convosync options on the file systems that will do the same job as raw devices. Moreover, your data will be safe during the crash scenes.
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2001 12:08 PM
тАО10-29-2001 12:08 PM
Re: Sybase devices - raw versus file system devices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-02-2001 11:47 AM
тАО11-02-2001 11:47 AM
Re: Sybase devices - raw versus file system devices
Maybe you have had your question anserwed, but let me add my two cents.
Beginning with ASE 12, sybase now supports database files on file systems, and garantees that you will not loose data in the event of a crash. Since we are still running 11.9.2 on hpux 10.20 for our databases, and have no need to upgrade anything yet, I am speaking from knowledge aquired by attending sybase classes and reading about this.
So, as far as performance is concerned, NOTHING beats having the database devices on raw file systems, bypassing the i/o buffering here. However, as pointed out below, you have to have some kind of backup process in order to be able to recover from a disk crash. We dump the databases to files daily and dump the transaction logs hourly, and backup is done to tape after the full daily backup.
From what I have read, dsync is on by default, and people were having performance problems on ASE 12, because master and tempdb were not raw devices, and the advantage of putting database devices on file systems is not performance, but for piece of mind that you are backing up a file and so a junior sys admin does not blow away your database by doing something on sam on these files ( raw ) that are not showing up on bdf !!!!
In any case, the thing to do there is to see what are your goals, performance as opposed to having your device files showing up on bdf and being able to back those files up without having to create a different process, and go from there, BUT, make sure you understand that if master and possibly tempdb is setup with dsync on, you might have performance problems eventhough your production database might be on raw devices.
As far as the FC60, it does not care what kind of file it is using, it will use its hardware to speed things up anytime you need to, and since you have raw file systems, it will bypass any kind of buffering too.
I hope this helps,
Henrique Silva
IT Engineer
UST R&D Lab
HP Burlington