Symptom
You may get an error: Default dbspace 'XXXXXXX' not found when you attempt to create any objects on IQ.
(DBA)> create table test1(col1 int)
Could not execute statement.
Default dbspace 'IQ_USER_MAIN' not found
SQLCODE=-1068, ODBC 3 State="42S02"
Line 1, column 1
create table test1(col1 int)
Press ENTER to continue...
(DBA)>
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
Product
SAP IQ 16.0 ; SAP IQ 16.1
Keywords
Default dbspace, default_dbspace, sp_iqdbspace , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.