SAP Knowledge Base Article - Preview

2038258 - When creating a tempdb device, received the error: Inappropriate ioctl for device - SAP ASE

Symptom

When creating a device for a tempdb database:

disk init
name = tempdb2_dat1,
physname = “/sybtmpfs/tempdb2_dat1”,
size = “15G”
go

Receive the message:

Attempt to set tmpfs file '/sybtmpfs/tempdb2_dat1' to Direct i/o mode failed, error: Inappropriate ioctl for device
The device does not support directio. '/sybtmpfs/tempdb2_dat1' will be activated using dsync instead of directio.
Initializing virtual device X, '/sybtmpfs/tempdb2_dat1' with dsync 'on'.
Virtual device X started using asynchronous i/o.
Initializing device /sybtmpfs/tempdb2_dat1 from offset 0 with zeros.
Finished initialization

 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 All Version

Product

SAP Adaptive Server Enterprise 15.7

Keywords

tempdb device, ioctl , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.