db2 9.7 windows auto_db_backup with compress
Posted on 2012-04-02
Is it possible to enable compression in the auto_db_backup wizard?
More specifically, I would like Automatic Maintenance to back up with compression and delete older backup files.
get database config
Shows auto_db_backup is enabled, but does not show any of the sub-settings, including destination, time window, and whether compression is enabled.
I see nothing in the Configure Autonatic Maintenance wizard to enable compression. There is another backup task in the Task Center that also runs a backup with compression enabled. I don't think the same user set up both tasks - seems to be redundant.
I am getting duplicate backups in the destination location, one is compressed, and one that is not. Both jobs are configured to use the same destination.