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 ONE Support launchpad (Login required).

Search for additional results

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