Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Posts
    4

    Unanswered: How Can I Cancel Automatic Tasks (autobackup, Autoreorg) ??

    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??

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Just to make sure you don't have any pending changes, try this:

    db2 connect to db-name
    db2 get db cfg show detail
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Mar 2006
    Posts
    4
    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

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •