We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Sybase using JFS instead of Raw Partitions

blacks
blacks asked
on
Medium Priority
519 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!
Comment
Watch Question

Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.