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.
SAP Knowledge Base Article - Preview