Skip to Content

SAP IQ 16.0 size of empty database

May 16, 2017 at 04:07 PM


avatar image

Hello, I have noticed that after the new and empty SAP IQ 16.0 database is created it instantly reserves about a 1/5 of the MAIN_IQ DBSPACE size. In example after I create a database with 100 GB of MAIN_IQ store then in sp_iqstatus and SAP IQ Cockpit it shows that ~20GB is already used. What are the reasons for this behavior and how can we avoid it? Thank you in advance. Best regards. Donatas

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member
May 17, 2017 at 05:32 AM


You need to separate IQ_SYSTEM_MAIN from User Dbspace.

In case of IQ_SYSTEM_MAIN, Approximately 20 percent of the IQ_SYSTEM_MAIN dbspace is now used for preallocated free list space and not available for user data.

Please refer to the following url for details.

Best Regards,

Gi-Sung Jang

10 |10000 characters needed characters left characters exceeded