SAP Knowledge Base Article - Preview

1996161 - utility_db may abort by DROP DATABASE statement

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

SAP IQ 16.0 ; SAP Sybase IQ 15.4

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.