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 DBA should report on table size and database usage. This produces some hints and allows an estimate for log builds.
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
Leave a Reply