https://userapps.support.sap.com/sap/support/knowledge/en/2037847
2037847 - How to shrink dbspace size - SAP IQ | SAP Knowledge Base Article
It is not possible to shrink dbspace size by "alter dbspace alter file size". If it is needed to shrink dbspace size, it is needed to drop dbfile of the...
how tosap iqknowledge baseshrink