Skip to Content

SAP IQ 16.0 size of empty database

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded