IBM Support

maximo db2 database logging configuration for accurate recovery

Technical Blog Post


Abstract

maximo db2 database logging configuration for accurate recovery

Body

It is important to have maximo db2 database to run in ARCHIVE mode in Production environments.

This configuration will allow the Roll Forward recovery option and and restore the database to the

closest possible point in time before the crash. To use this future , please run

 

db2 update db configuration for maxdb76 using logarchmeth1  disk:\\m1maxdb\c:\db2_backups\db2_logs;

Note:

the disk:\\m1maxdb\c:\db2_backups\db2_logs sample path on windows OS , change it to the location you would like to have the logs saved.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11131423