Skip to Content
0

SAP IQ 16.0 size of empty database

May 16, 2017 at 04:07 PM

103

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
0

Hi,

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.
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01771.1604/doc/html/san1283555467906.html

Best Regards,

Gi-Sung Jang

Share
10 |10000 characters needed characters left characters exceeded