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

[Former Member]

Hi

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?

[tayeb_hadjou]

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" .

[Former Member]

Hi Tayeb

The tables are created by different user than DBA. I see that my user is a member of PUBLIC group. The tables are getting created using this user by the BW4HANA when we set object for cold storage. There is no explicit option for creating it in Q_SYSTEM_MAIN dbspace. I am not sure if there is a place in SAP IQ to check the command run to create these tables.

[tayeb_hadjou]

You can enable sql logging KBA 2270379 before tables creation and disable it afterwards.

The trace will show you the statements executed.

Another important points

1. Make sure the user dbspace is Read/Write and online (sp_iqdbspace output).
2. Have a look in iqmsg lines matching the create tables time frame. You may discover the messages pointing to the root cause.

[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.