SAP Knowledge Base Article - Preview

3217204 - How to drop or rename dbfile path which was created incorrectly with SPACE character in filename ?

Symptom

A dbfile is added with SPACE character in filename. 
--------------------------------------------------------------------------------------------

$ dbisql -c 'uid=dba;pwd=sqlsql;eng=iq161sp04pl11_iqdemo' -nogui

(dba)> alter dbspace iq_main add file iq_main_2 'iqdemo_main.iq MAIN' size 200MB  -- Bad physical path 

(dba)> select DBFileName , Path from sp_iqfile()
DBFileName     Path
----------------------------------
IQ_SYSTEM_MAIN iqdemo.iq
iq_main        iqdemo_main.iq
iq_main_2      iqdemo_main.iq MAIN
IQ_SYSTEM_TEMP iqdemo.iqtmp

(4 rows)
--------------------------------------------------------------------------------------------


Read more...

Environment

IQ 16.x

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , 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.