SAP Knowledge Base Article - Preview

2447968 - Can not drop dbfile with a space in the name - SAP IQ


I have a raw device named /dev/user27, and I created an IQ dbfile on it that mistakenly had a space in the name:

ALTER DBSPACE IQ_USER_MAIN ADD FILE user27 '/dev/ user27';

SAP IQ did not use the raw device but instead created a file in /dev called 'user27' and is using it as the dbfile.

All non-coordinator nodes crashed with the following:

Exception Thrown from oslib/hos_bio.cxx:1540, Err# 10, tid 1098 origtid 1098
   O/S Err#: 2, ErrID: 518 (hos_bioexception); SQLCode: -1006067, SQLState: 'QBA67', Severity: 14
[20305]: Filename does not exist. File: /dev/ user27
-- (oslib/hos_bio.cxx 1540)

Any attempt to restart the secondary servers hits the same error (notice the space in the file name).

Any attempt to drop the dbfile from the coordinator results in the following error:

(DBA)> alter dbspace IQ_USER_MAIN drop file user27;
Could not execute statement.
  Cannot execute 'drop IQ_USER_MAIN' yet since previous alter command is
  not yet propagated through the multiplex. Try again.
  (dblib/db_createdb.cxx 4137)
  SQLCODE=-1009066, ODBC 3 State="HY000"
  Line 1, column 1
  alter dbspace IQ_USER_MAIN drop file user27
Press ENTER to continue...





SAP IQ 16.0


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.