DB2 LOGINDEXBUILD

20 April,2012 by Jack Vamvas

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

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 LOGINDEXBUILD

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright