Solved

Sybase using JFS instead of Raw Partitions

Posted on 1997-09-03
1
458 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
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sybase SQL Anywhere ISQL 8 1,009
installing Sybase IQ express edition 15.4 16 890
sybase T-sql different 2 117
Dynamic SQL select query 4 38
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
Riverbed Technology's webinar discusses networking for the cloud era with simplified SD-WAN cloud connectivity.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 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