logindexbuild - Log index pages created configuration parameter
This parameter specifies whether index creation, recreation, or reorganization operations are logged so that indexes can be reconstructed during Db2® rollforward operations or high availability disaster recovery (HADR) log replay procedures.
- Configuration type
- Database
- Applies to
-
- Database server with local and remote clients
- Client
- Database server with local clients
- Partitioned database server with local and remote clients
- Parameter type
- Configurable online
- Configurable by member in a Db2 pureScale® environment
- Default [range]
- Off [On, Off]
When you set the logindexbuild configuration parameter to Off, index objects are marked invalid while rolling forward through index creation, recreation, or reorganization operations. You must re-create indexes after the rolling forward operation completes and the database is restarted. Index re-creation depends on the value of the indexrec configuration parameter and if you issue an explicit RESTART DATABASE command.
When you set the logindexbuild configuration parameter to On, each index page is logged during index creation, recreation and reorganization. Index objects are not marked invalid, and you do not have to re-create indexes after the rolling forward operation completes.