IBM Data and AI Ideas Portal for Customers


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


Status Not under consideration
Workspace Db2
Created by Guest
Created on Mar 9, 2018

Db2 Houskeeping of combination of Snapshot Backups and TSM Backups

At the moment Db2 supports housekeeping of backups by DB configuration parameters rec_his_retent and num_db_backups. These parameters are used by the customer for years for Db2 TSM backups. Both parameters are set to a value of 8 - ensuring more than one week full backups are available. A full backup is taken Monday to Saturday.

Since some time the customer is using Db2 Snapshot backups (with IBM Flash Copy Manager (FCM)) as well. Now, the implemented automatic deletion of full Db2 database backups does not work (like intended) anymore. In theory it could work, if MAX_VERSIONS / MAX_SNAPSHOT_VERSIONS of acs_profile could be set to a value of 8 as well. But this is highly impractical.


Let's consider a very easy example. Snapshot backups are done on weekdays, on Saturdays a TSM Backup. We assume just one Device Class with 5 targets. MAX_VERSIONS is configured to 5 (acs_profile). Intention is to have 5 snapshot backups available.

Example:

Sat 12/30 TSM Backup
Mon 1/01 Snapshot Backup
Tue 1/02 Snapshot Backup
Wed 1/03 Snapshot Backup
Thu 1/04 Snapshot Backup
Fri 1/05 Snapshot Backup
Sat 1/06 TSM Backup
Mon 1/08 Snapshot Backup
Tue 1/09 Snapshot Backup
Wed 1/10 Snapshot Backup
Thu 1/11 Snapshot Backup
Fri 1/12 Snapshot Backup
Sat 1/13 TSM Backup
Mon 1/15 Snapshot Backup


Using a configuration of

REC_HIS_RETENT 8
NUM_DB_BACKUPS 8
and
MAX_VERSIONS 5 (acs_profile)

The first 5 Snapshot backups use the 5 available targets.
Snapshot backup of 1/08 'overwrites' the snapshot of 1/01. This is the 6th snapshot backup, 8th backup.
Snapshot backup of 1/09 'overwrites' the snapshot of 1/02 (7th snapshot, 9th backup).

Now, following the backup, Db2 history is purged, and TSM Backup of 12/30 will be marked expired (and the appropriate logs).
Since the snapshot backups of 1/01 and 1/02 were 'overwritten' (although still in Db2 history) the oldest restore point in time would be 1/03, thus the intended service level of being able to restore the database 8 days backwards will be missed.

As a workaround the customer marks 'overwritten' snapshot backups manually as deleted (D) using UPDATE HISTORY ... to avoid loosing necessary backups.


We would ask if it would be possible to handle the combination of Snapshot- and TSM-Backups (and file system backups) appropriately. Db2 should be able use the configuration of MAX_VERSIONS etc. (acs_profile)

This shouldn't be impossible, because Db2 has all the necessary knowledge, ACS configuration and the backups performed. And using a mixture of filesystem and TSM backups works like expected.


The manual Db2 history updates of snapshot backups works in the current environment, but if more and more Db2 systems will use snapshot backups in the future with changing configuration and infrastructure for snapshot backups the manual correction of the Db2 history is getting more and more complicated and error-prone - nearly impossible.