SAP Knowledge Base Article - Preview

3479229 - Getting error: Default dbspace 'XXXXXXX' not found - SAP IQ

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.