Solved

Sybase using JFS instead of Raw Partitions

Posted on 1997-09-03
1
421 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
1 Comment
 
LVL 5

Accepted Solution

by:
n0thing earned 200 total points
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

772 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now