Control history collection for databases

While the database administrator controls whether history is collected for a database, the session is the unit of collection. The default is to collect history for the user and the database.

Use the COLLECT HISTORY clause on the CREATE DATABASE or ALTER DATABASE statements to disable or enable history collection for a database.

To create the database and turn on the COLLECT HISTORY feature, use the following syntax:

CREATE DATABASE database-name [create-db-clause]...
create-db-clause ::=
            ... existing clauses ...
        |   COLLECT HISTORY ON

With cross-database access, settings might be different. The history collection setting of the session creation determines access.

For example, if the session setting is set to ON, history is collected, even if the cross-database setting is OFF. If the session setting is OFF, history is not collected, even if the cross-database settings are set to ON.