SAP Knowledge Base Article - Preview

3092388 - How to change the PATH of temporary store file in MPX - SAP IQ


For simplex server, we can change the PATH of temporary dbspace file as same as IQ_SYSTEM_MSG in KBA 2705275:

  ALTER DBSPACE IQ_SYSTEM_TEMP RENAME '<new-file-pathname>';

However the syntax doesn't work on MPX. How can we change the PATH of temporary dbspace file on MPX ?

  (DBA)> ALTER DBSPACE IQ_SYSTEM_TEMP RENAME 'C:\mpx\mpx02\tempdbs\mpx02.iqtmp'
  Could not execute statement.
    Use ALTER DBSPACE ALTER FILE for this operation.
    -- (dblib\db_iqddl.cxx 922)
    SQLCODE=-1013105, ODBC 3 State="HY000"

  Line 1, column 1
    ALTER DBSPACE IQ_SYSTEM_TEMP RENAME 'C:\mpx\mpx02\tempdbs\mpx02.iqtmp'

Press ENTER to continue...



SAP IQ 16.1


SAP IQ 16.1


temporary store file, path, multiplex , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.