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.
SAP Knowledge Base Article - Preview