Skip to Content
avatar image
Former Member

SAP IQ 16 as NLS for BW4HANA creating tables in IQ_SYSTEM_MAIN DBSpace


We have setup SAP IQ as NLS for BW4HANA environment. I have created a new DBspace as "user_space" to store tables for NLS with required size. I have also set the default dbspace using the below command.

set option public.default_dbspace='user_space';

But when ever the NLS tables are created by BW4HANA it always creates it in the IQ_SYSTEM_MAIN dbspace.

I checked the sp_iqcheckoptions; on the database and it shows for both public and the user default dbspace is 'user_space'.

Is there any other setting that needs to be done to force create the tables in 'user-space' dbspace?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 12, 2018 at 09:09 PM

    Check if tables are created by DBA.

    If yes, you need then set the option for DBA as it is not PUBLIC member.

    Other possibility. Tables created with explicit option "IN Q_SYSTEM_MAIN" .

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Enabled the SQL log and I see the table create command is explicitly getting issued with "in IQ_SYSTEM_MAIN" dbspace statement. I will open a message with SAP as this command is being generated from the BW4HANA side.