Technical article 104911

I am experiencing database corruption running Sybase 10.0.1 over AIO.

OpenServer 5.0.0

Written · Last revised

Problem

Database corruption occurs when running a system that is using Sybase over Asynchronous I/O raw filesystems.

Cause

The Sybase installation scripts run a script called
sco_kernel.scr.  This script fails to add the aiolkinit(ADM)
to a script in /etc/rc2.d, which can result in database
corruption in Sybase databases on heavily loaded systems.

Solution

Add the aiolkinit(ADM) command to one of the scripts in /etc/rc2.d that is invoked before your Sybase Databases are started.

Specify the raw disk device that is going to support AIO as
a parameter to aiolkinit(ADM).  If you are using AIO on a raw
division called "master", run this command in one of the
/etc/rc2.d scripts:
aiolkinit /dev/rmaster

From the Xinuos technical article database, record 104911. Reproduced with permission. The original is at www.sco.com/ta/104911, which is reachable but blocked from search engines. Xinuos marks this article against a retired product line. That refers to the product’s lifecycle, not to whether the advice still works — plenty of it still applies to running systems.

Next step

Need this fixed rather than explained?

Tell us the release, what the system runs and what it is doing. We will reply by email with what we would do next.

  • You deal with the people who do the work
  • No obligation, and no upgrade required before we will help
  • We tell you plainly if something is not worth doing

Send an enquiry

We reply by email. If a server is down, say so in the first line. You can also write to help@scoexpert.com.