SAP Knowledge Base Article - Preview

2288377 - Failed to create and add db file in IQ.

Symptom

Failed to create or add db file due to below error in IQ.

[Error]

Could not execute statement.
Cannot create or add file /home1/gjang/IQDEV/TEST_MAIN_00.iq for dbspace
HPIA16_MAIN_TEST until new readwrite space is added to dbspace
IQ_SYSTEM_MAIN to hold the new freelist.
-- (slib/s_trycatch.cxx 983)
SQLCODE=-1009064, ODBC 3 State="HY000"
Line 1, column 1


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP Sybase IQ 15.3

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

SYBASE, IQ, DBSPACE, DB FILE, FILE, ADD, CREATE, Alter dbspace, Create dbspace, freelist, free list, IQ_SYSTEM_MAIN, space, Cannot create or add file , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , HAN-DYT , SAP HANA Dynamic Tiering , 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.