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
: 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.
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
KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.