DOMINO AND DB2

Compact database options are enabled for Domino and DB2
Several Compact options are implemented for IBM® Lotus® Domino™ and IBM® DB2 Universal Database™ Enterprise Server Edition configurations. When the -B option is applied to a DB2 enabled IBM® Lotus® Notes® database, it reclaims disk space through tablespace reduction. This is accomplished by a series of table and index reorganizations in DB2, which attempt to lower the tablespace's high water mark (HWM) so that the tablespace can be reduced in size. The effect of the DB2 table and index reorganizations is more significant if you run compact when Domino is not running. Space reclamation in DB2 is entirely different than that which a Domino administrator is accustomed to. Performing compact -B on a DB2 enabled Notes database does not guarantee that any space can be reclaimed.

Running compact -B on a directory results in a single set of table and index reorganizations because several DB2 enabled Notes databases can exist in a set of tables within a tablespace. The table and index reorganizations for data in a DB2 enabled Notes database are deferred until compact is finished with regular NSF processing.

Note The Compact -b option does not have any impact on a DB2 enabled Notes database.

The Domino administrator should be familiar with the DB2 Database Analysis and Reporting Tool (db2dart.) Db2dart is a DB2 utility that displays tablespace usage information, including what needs to be done to best lower the HWM of a tablespace so that the tablespace can be reduced in size.

For more information about db2dart, go to the DB2 Information Center at http://publib.boulder.ibm.com/infocenter/db2help/index.jsp.

See also