Short text
Activates the “Deflated Tables” functionality.
Parameter Description
Activates the functionality known as the QAQQINI option SQL_DEFLATE_TABLE for database connections on the ABAP schema. This means that from this point onwards all new tables, indexes, or views are “deflated” – in other words, they are created without members. This status is retained for as long as the Basis table on which the objects are based contains no data. The aim is to keep the size of databases with several unused objects as small as possible.
Keep in mind that the status of existing empty tables, as well as views and indexes dependent on them, are not changed by this. For this purpose, use AS4FIXFILE with the option DEFLATE(*YES).
Also keep in mind that the parameter only affects connections to the ABAP database schema, not secondary connections that were defined using transaction DBCO. Normally, this is not of concern since accesses via secondary connections generally do not create any database objects. Should this be desired, however, the parameter must be maintained – as up to now – through QAQQINI and its location must be included as the AS4_QAQQINILIB parameter in the definition of the secondary connection.
For more informaion on this as well as on all the requirements for “Deflated Tables”, please see SAP Note 2259105.
Application Area
Database
Default Value
0
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
No.
Values allowed
L 0 1 OFF ON NO YES FALSE TRUE
