1. Sybase 10.0.2 and Sun's Storage Arrays
So far, your troubleshooting looks pretty good. Here are some more suggestions:
1. Call Sybase tech support for and ask which Solaris patches are required for running
the server in Solaris 2.4 . I know that we had to load a couple.
2. I know that for a while Online Disk Suite (the volume manager) was not certified
certified for use with the Sybase SQL Server. Make sure that the version that
you are using is O.K. with Sybase.
3. Make absolutely sure that you do not use sector 0 on any disk in your Raid Array.
Here's what happens: Typically, the disk label and other O/S housekeeping
information is written to the first sector on an O/S disk. Sybase, by default,
writes its Object Allocation Map (OAM) to the first available 512K page in a
database. If one of your Sybase virtual devices starts on the first sector, you
run the risk of overwriting your disk label. In the case of logical volume
managers, they also write their housekeeping information at the beginning of the
disk (at least, this is what happens in AIX, I'm not as familiar with Online Disk
Suite or Solstice). Given this scenario, you can have Sybase and the O/S competing
for to write information to the same place. Either way, if you overwrite the disk
label, or the OAM, you are heading for 605 city.
Sybase has some good technical information on this issue. It is a fairly common
problem -- one which we have been through, and have since corrected. Just make
absolutely, positively sure that at Sybase cannot write to the first 2 or 3 sectors on
your disks, and you should be fine. Oh, by the way, we are using asynchronous I/O to
raw UNIX partitions with no problems.
Then again, you may have something else going on...
2. Remote Servers vs Linked Servers
3. Sybase and Sun Storage Array
4. Multiple Portals of same file
5. SUN Sparc 2000 with SUN Storage Array (30GB)`
6. Scrolling ListBox
7. Migrate Sybase SQL server from Netware NLM 4.2.2 to Sybase 10 on Sun
8. Tuning for Export and Import Tool
9. HELP - SYBASE System 10 / OpenClient 10.0.2 P2 / FTP PCTCP stack
10. Database Administrator for Sybase System 10 (future System 11) needed in San Diego California
11. System 10 storage size?
12. Downgrading a Sybase System 10 database to Sybase 4.X database