Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.


On SAP IQ 16.1, I receive the below errors when DROP DATABASE '/opt2/sybaseiqdata/TestX.db' is executed. Error on the DBISQL prompt is

Unable to start specified database: Resource temporarily unavailable

and below error is recorded in the utility_db.0002.srvlog

Direct IO disabled for file '/opt2/sybaseiqdata/TestX.db' because the file system on which it resides does not support it

The Version & Platform as shown in @@VERSION is

SAP IQ/ - x86_64 - 3.10.0-327/64bit/2018-03-21 02:29:37

Please help me resolve this error.

2nd - If this error can't be treated, I can first Stop the Database and manually delete the Database files/folder. Does this approach has any side-affects? I am assuming No since each Database in IQ is independently run as Server and do not have dependencies with other running databases.

-- In 'thoughts'...

asked 04 Jul '20, 22:38

LonelyRogue's gravatar image

accept rate: 0%

edited 04 Jul '20, 22:39

Resource temporarily very likely means the the file is locked (recent versions will show a more relevant error message). Is it in use by an IQ server? Given your comments in "2nd", it sounds like it is. You need to stop the database first then either run DROP DATABASE (usually from the utility_db) or use the dberase command line utility.

The message about DirectIO is not relevant here although I wonder what kind of filesystem you are using on Linux that doesn't support Direct IO...

permanent link

answered 04 Jul '20, 22:50

John%20Smirnios's gravatar image

John Smirnios
accept rate: 37%

Thanks for replying. STOP DATABASE is issued but even then DROP DATABASE '/opt2/sybaseiqdata/TestX.db' and DROP DATABASE 'TestX.db' is failing with error - "Specified database not found". Either Logs of Utility_DB or TestX didn't record any error.

"/opt2/sybaseiqdata" is a Mount Point tied Logical Volume "/dev/vg_data/d_001" which is tied to Block Device( Block Special File) "/dev/dm-0"

Also when searching for this Direct IO error, found that OS_File_Cache_Buffering & OS_File_Cache_Buffering_Tempdb are set to OFF in SYSOPTIONS. Does it matter?

(05 Jul '20, 03:16) LonelyRogue
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 04 Jul '20, 22:38

question was seen: 1,431 times

last updated: 05 Jul '20, 03:16