D00: SYBMULTBUF WARNING: Cannot use Asynchronous I/O for database device ...

[Tim Mottershead]

Hi,

Whilst attempting to dump and load DBs on ASE 12.5.2 ESD#1 under MacOS 10.3,
we are getting the following warnings in the backup server error log:

D00: SYBMULTBUF WARNING: Cannot use Asynchronous I/O for database device
'<deviceName>' because either the device type does not allow it or because
the Adaptive Server Enterprise is using Synchronous I/O. Backup Server is
using Synchronous I/O for this device which will cause significant
performance degradation.

ASE reports that it IS using asynch I/O in it's error log. DB devices
concerned are OS files on HFS+. Backup server version reports it's version
string as:

Backup Server/12.5.2/EBF 11802/P/PowerPC G4/Mac OS X
10.1.4/ase1252/2266/32-bit/OPT/Fri Mar 26 19:25:26 2004

Does anyone if these warnings are accurate? It seems to me that the warning
is misleading because ASE says that it IS using asynch I/O on the devices
concerned. ( "Initializing virtual device 13,
'/Volumes/stripea1/syb_data/....Virtual device 13 started using asynchronous
i/o.")

Does anyone know how to resolve this issue?

As always, all comments and observations gratefully received!

Tim

[Steve Olson]

This is a warning message from the backup server, indicating that it
is not using async io. When initially implemented, we didn't use
async io for backup server; however, that has been fixed in ase 12.5.3.

Since it is only an informational message, it can be safely ignored.

Regards,
Steve

[Tim Mottershead]

Hi Steve,

Thanks for the info, I will happily ignore the warning for now!

So when does 12.5.3 come out?! More to the point, how about 12.5.2 ESD #2
for OSX?

Cheers,

Tim

"Steve Olson" <ol...@sybase.nospamminplease.com> wrote in message
news:414ca64a@forums-2-dub...

[Steve Olson]

Tim Mottershead wrote:
> Hi Steve,
>
> Thanks for the info, I will happily ignore the warning for now!
>
> So when does 12.5.3 come out?! More to the point, how about 12.5.2 ESD #2
> for OSX?

ASE 12.5.3 is scheduled for general release by the end of the year -
we're hoping for November. While backupserver asyncio could be added
to a 12.5.2 maintenance release, it would probably take about as long
to get the maintenance release out as it would to deliver 12.5.3,
which is going through a q/a stage right now.

Regards,
Steve

[nickchen]

Please check sp_configure
that max memory and allow sql server async i/o.

if allow sql server async i/o Run Value is 0 that need have
to change back to 1.

sp_configure 'allow sql server async i/o' , 1
go

and then restart sybase backup server

nick