DB2 LOGINDEXBUILD

According to the DB2 documentation, the LOGINDEXBUILD database configuration parameter “specifies whether index creation, recreation, or  reorganization operations are to be logged so that indexes can be7 reconstructed during DB2 rollforward operations or high availability  disaster recovery (HADR) log replay procedures”

db2 get db cfg for mydb | grep 'LOGINDEXBUILD'
Log pages during index build            (LOGINDEXBUILD) = OFF| ON

Notes

1)       For HADR the recommendation is to have LOGINDEXBUILD turned on. This will create extra log files . Need to complete a  capacity planning task. Capacity planning for log space required during an index build can be complicated – as other clients can be connected , creating extra log files.

2)       The DB2 DBA should report on table size and database usage. This produces some hints and allows an estimate for log builds. Use this shell script for DB2 table sizes

3)       A reorg on large table can cause full transaction logs

4)       If LOGINDEXBUILD  is turned off , an index build will  create minimal logging. In a forward recovery situation – the index build will not occur. The index is flagged as invalid