Automatic Maintenance Setting in DBACOCKPIT

[former_member182505]

HI Experts,

This is regarding to my PRD server. In DBACOCKPIT->Configuration->automatic maintenance Settings.

What is the recommended Settings for

1-Genral (Currently automatic maintenance in switched-on (onlione maintenance window is enable))

2-Automatic Backup( Currently automatic backup is switched off)

3-Automatic RUNSTATS (Currently automatic runstats is swithed on)

4-Automatic REORG (automatic REORG is swithed off)

Its all are default setting . kindly guide me as per sap and db2 recommendation.

Thanks

Sadiq

[Former Member · Accepted solution]

These are all sap recommended already. Rest depends on your maintenance strategy.

Note 1329179 - DB6: DB2 V9.7 Standard Parameter Settings

Thanks