Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sybase using JFS instead of Raw Partitions

Posted on 1997-09-03
1
Medium Priority
?
497 Views
Last Modified: 2008-03-17
Sybase is adamant that we should not use the AIX JFS.  We could have data integrity problems.  They won't get specific on how an why.  Oracle uses JFS and works just fine.  Sybase also installs by default using NT file systems.  What gives?  We have been testing on a small AIX box using the Journal File System (JFS) instead of Raw Partitions.  We have tried a number of update processes and have literally pulled the plug on the box.  It recovers nicely.  I need a straight answer. So far testing has only shown Sybase needs to get their act together. JFS is fast!
0
Comment
Question by:blacks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 5

Accepted Solution

by:
n0thing earned 400 total points
ID: 1098020
Hi,

   I would recommend you to use raw partition instead of JFS ...
I'm having problems using ufs(Solaris 2.5 FS). I was using ufs,
and my database is kinda huge (18 gig). I've to insert around
500.000 rows a day and doing large SELECT on it... much faster with raw. Also, Sybase does recover more quickly with raw than Unix FS. It will work just fine with small database, but if you want to add on more partition to it, the more you add the worse performance gets. If you need some real testing, lets try to insert/update/delete 10000 rows with raw & with JFS. You'll see the difference. The way Sybase writes its data in raw is more efficient than JFS. I think in the Sybase man page somewhere, it
does explain why you should use raw instead of JFS. I don't have it here, but right now I'm maitaining 6 different Sybase databases with over 1 millions records in/out every day. Raw is much faster, specially on recovery, took me usually 1-2 hours to
recover my database now instead of 3-6 hours. I'm on a Sparc Ultra 2 with dual CPU and 384Megs of memory on it. If your database is small and doesn't do intense queries/updates like mine. Just use the fs you like. Otherwise go for raw.
   Just my little comments. If you need more details, you should
talk to an independant Sybase expert and get Sybase docs on raw vs Unix fs.

Regards,
Minh Lai

0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll show how research, determination, and use of modern technology helped me solve a DNA mystery.
A new hacking trick has emerged leveraging your own helpdesk or support ticketing tools as an easy way to distribute malware.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question