Hi!

I have DB2
MXMLNBW01:db2bwd 2> db2level
DB21085I Instance "db2bwd" uses "32" bits and DB2 code release "SQL08022" with
level identifier "03030106".
Informational tokens are "DB2 v8.1.0.88", "s050422", "MI00105", and FixPak "9".
Product is installed at "/opt/IBM/db2/V8.1".

My db name is BWP and the configuration for the automatic task is:

Automatic maintenance (AUTO_MAINT) = OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF
Automatic runstats (AUTO_RUNSTATS) = OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF
Automatic reorganization (AUTO_REORG) = OFF

But, all of these task are executed everyday, and i dont want to execute anymore. Where can i force to cancel the automatic execution??

This is a part of the db2diag.log

2006-12-12-09.49.03.777545-360 I578401G320 LEVEL: Event
PID : 4305 TID : 2920524720 PROC : db2hmon
INSTANCE: db2bwd NODE : 000
FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup, probe:260
STOP : Automatic Backup: evaluation has finished successfully on database BWD

2006-12-12-09.49.17.057943-360 I578722G315 LEVEL: Event
PID : 4305 TID : 2931014576 PROC : db2hmon
INSTANCE: db2bwd NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:10
START : Automatic reorg evaluation has started on database BWD

2006-12-12-09.49.20.578678-360 I579038G329 LEVEL: Event
PID : 4305 TID : 2931014576 PROC : db2hmon
INSTANCE: db2bwd NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalReorg, probe:20
START : Automatic reorg evaluation has finished successfully on database BWD

2006-12-12-09.54.01.700210-360 I579368G320 LEVEL: Event
PID : 4305 TID : 2931014576 PROC : db2hmon
INSTANCE: db2bwd NODE : 000
FUNCTION: DB2 UDB, Automatic Table Maintenance, db2HmonEvalStats, probe:100
START : Automatic Runstats: evaluation has started on database BWD


How can I cancel this automatic task??

Just to make sure you don't have any pending changes, try this:

db2 connect to db-name
db2 get db cfg show detail

The OS is Linux RHEL and this is the complete db configuration with show details...

Description Parameter Current Value Delayed Value
---------------------------------------------------------------------------------------------------------------
Database configuration release level = 0x0a00
Database release level = 0x0a00

Database territory = en_US
Database code page = 819
Database code set = ISO8859-1
Database country/region code = 1
Database collating sequence = BINARY BINARY
Alternate collating sequence (ALT_COLLATE) =
Database page size = 4096 4096


Automatic maintenance (AUTO_MAINT) = OFF OFF
Automatic database backup (AUTO_DB_BACKUP) = OFF OFF
Automatic table maintenance (AUTO_TBL_MAINT) = OFF OFF
Automatic runstats (AUTO_RUNSTATS) = OFF OFF
Automatic statistics profiling (AUTO_STATS_PROF) = OFF OFF
Automatic profile updates (AUTO_PROF_UPD) = OFF OFF
Automatic reorganization (AUTO_REORG) = OFF OFF

Well, these tasks aren't actually executing. If you want to switch off evaluation too, "db2 update dbm cfg using health_mon off". Be aware that it will also switch off evaluation of other parameters and disable alert notification.

I would leave it alone because it doesn't do any harm.