Symptom
- If IQ doesn't have write permission for the directory where DB space (IQ store file) exists because the owner is different, utility_db will abort when DROP DATABASE statement executes.
- From IQ log:
(dba)> drop database 'iqdb2'
Warning: Using default value for -iqmc or -iqtc is insufficient for most applications
Using licenses from: /tse_work/iq1603/SYSAM-2_0/licenses/IQ16.lic:/tse_work/iq1603/iqdb2/*.lic
Checked out license for 8 IQ_CORE (2015.08150/15-aug-2015/0676 EFBC 87E7 19B5) will expire Sun 16 Aug 2015 12:00:00 AM JST.
WARNING: IQ functionality that requires the IQ_CORE license will be disabled on Sun 16 Aug 2015 12:00:00 AM JST, unless a suitable IQ_CORE license is obtained before that date.
Exception Thrown from oslib/hos_unlk.cxx:95, Err# 17, tid 3 origtid 3
O/S Err#: 13, ErrID: 522 (hos_ioexception); SQLCode: -1006148, SQLState: 'QBB48', Severity: 14
[20386]: Operation failed on file due to file permissions. File: /tse_work/iq1603/iqdb2/main/iqdb2.iq
-- (oslib/hos_unlk.cxx 95)
**************************************************
**************************************************
*** Sybase IQ Abort:
*** Sybase IQ Abort:
*** From: stcxtlib/st_server.cxx:1539
*** From: stcxtlib/st_server.cxx:1539
*** PID: 14154
*** PID: 14154
*** Message: caught signal 11, program abort
*** Message: caught signal 11, program abort
*** Thread: 3618617088 (TID: 3)
*** Thread: 3618617088 (TID: 3)
**************************************************
**************************************************
Error! The connection to the database was closed by the server.
Communication error
SQLCODE=-85, ODBC 3 State="08S01"
Line 1, column 1
drop database 'iqdb2'
Press ENTER to continue...
Read more...
Environment
SAP IQ 16.0
SAP IQ 15.x
Product
Keywords
signal 11, abort, CR760575, 760575 , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.