Db2

Hey All, 

Currently we are using Commvault to perform all of our Database backup needs.  We are not the owners of the Commvault product, but rather , our Hosting Vendor uses it for all of their database backups for all of their customers (Db2 and SQL server). 

Unfortunately, we have experienced several issues with Commvault, that have been very detrimental to our system.  If Commvault was managed by our team, it would likely be a different song, but it is not, so we are at a bit of a cross-roads with using the product in the future and management wants to get off of Commvault.

That said. . .

I am sure there are different options for creating a Db2 backup solution, and I am curious what others are using and how they feel about what they are doing.  Primarily, we need to take scheduled Full and Incremental backups as well as take care of the Log Archives.  I am sure we can come up with a Scheduled task solution and create our own scripts for doing this, but I am curious to know what others are using, and how they like what they are doing (basically the Pro's and the Con's).

I am going to do my own research, but I really want to hear from the people using the solutions rather than a salesman telling how wonderful their product is.

Hey All, 

Currently we are using Commvault to perform all of our Database backup needs.  We are not the owners of the Commvault product, but rather , our Hosting Vendor uses it for all of their database backups for all of their customers (Db2 and SQL server). 

Unfortunately, we have experienced several issues with Commvault, that have been very detrimental to our system.  If Commvault was managed by our team, it would likely be a different song, but it is not, so we are at a bit of a cross-roads with using the product in the future and management wants to get off of Commvault.

That said. . .

I am sure there are different options for creating a Db2 backup solution, and I am curious what others are using and how they feel about what they are doing.  Primarily, we need to take scheduled Full and Incremental backups as well as take care of the Log Archives.  I am sure we can come up with a Scheduled task solution and create our own scripts for doing this, but I am curious to know what others are using, and how they like what they are doing (basically the Pro's and the Con's).

I am going to do my own research, but I really want to hear from the people using the solutions rather than a salesman telling how wonderful their product is.

Hey All, 

Currently we are using Commvault to perform all of our Database backup needs.  We are not the owners of the Commvault product, but rather , our Hosting Vendor uses it for all of their database backups for all of their customers (Db2 and SQL server). 

Unfortunately, we have experienced several issues with Commvault, that have been very detrimental to our system.  If Commvault was managed by our team, it would likely be a different song, but it is not, so we are at a bit of a cross-roads with using the product in the future and management wants to get off of Commvault.

That said. . .

I am sure there are different options for creating a Db2 backup solution, and I am curious what others are using and how they feel about what they are doing.  Primarily, we need to take scheduled Full and Incremental backups as well as take care of the Log Archives.  I am sure we can come up with a Scheduled task solution and create our own scripts for doing this, but I am curious to know what others are using, and how they like what they are doing (basically the Pro's and the Con's).

I am going to do my own research, but I really want to hear from the people using the solutions rather than a salesman telling how wonderful their product is.

Hey All, 

Currently we are using Commvault to perform all of our Database backup needs.  We are not the owners of the Commvault product, but rather , our Hosting Vendor uses it for all of their database backups for all of their customers (Db2 and SQL server). 

Unfortunately, we have experienced several issues with Commvault, that have been very detrimental to our system.  If Commvault was managed by our team, it would likely be a different song, but it is not, so we are at a bit of a cross-roads with using the product in the future and management wants to get off of Commvault.

That said. . .

I am sure there are different options for creating a Db2 backup solution, and I am curious what others are using and how they feel about what they are doing.  Primarily, we need to take scheduled Full and Incremental backups as well as take care of the Log Archives.  I am sure we can come up with a Scheduled task solution and create our own scripts for doing this, but I am curious to know what others are using, and how they like what they are doing (basically the Pro's and the Con's).

I am going to do my own research, but I really want to hear from the people using the solutions rather than a salesman telling how wonderful their product is.

Hi Edward,

most backup solutions are mostly as bad as their admin is. And configuration of the backup system (push vs pull) is another thing.

Anyway, at one customer Veritas Netbackup is used and TBH it will not become my favorite for Db2. I also had once a customer with Omnibackup from HP.

But my personal favorite is TSM aka Spectrum Protect. It is fully integrated, never had any issues with anything like NetBackup or others. Maybe this was also dependent on the fact that we had an excellent TSM admin who understood the multiple tiers and other details of TSM so well. 
Another benefit is db2adutl, which allows the Db2 admin to interrogate TSM about backups and logs. For the other backup systems are mainly black boxes from the Db2 side.

AWS S3 is for Linux and Cloud only. CommVault using the pull mechanism to suck in the backups from the file system leave a gap in time. TSM can do both. Db2 can write directly into TSM or TSM can pull the data from a Db2 servers file system.

Just my €0.03, YMMV

Roland

Hey All, 

Currently we are using Commvault to perform all of our Database backup needs.  We are not the owners of the Commvault product, but rather , our Hosting Vendor uses it for all of their database backups for all of their customers (Db2 and SQL server). 

Unfortunately, we have experienced several issues with Commvault, that have been very detrimental to our system.  If Commvault was managed by our team, it would likely be a different song, but it is not, so we are at a bit of a cross-roads with using the product in the future and management wants to get off of Commvault.

That said. . .

I am sure there are different options for creating a Db2 backup solution, and I am curious what others are using and how they feel about what they are doing.  Primarily, we need to take scheduled Full and Incremental backups as well as take care of the Log Archives.  I am sure we can come up with a Scheduled task solution and create our own scripts for doing this, but I am curious to know what others are using, and how they like what they are doing (basically the Pro's and the Con's).

I am going to do my own research, but I really want to hear from the people using the solutions rather than a salesman telling how wonderful their product is.

Hi Edward,

most backup solutions are mostly as bad as their admin is. And configuration of the backup system (push vs pull) is another thing.

Anyway, at one customer Veritas Netbackup is used and TBH it will not become my favorite for Db2. I also had once a customer with Omnibackup from HP.

But my personal favorite is TSM aka Spectrum Protect. It is fully integrated, never had any issues with anything like NetBackup or others. Maybe this was also dependent on the fact that we had an excellent TSM admin who understood the multiple tiers and other details of TSM so well. 
Another benefit is db2adutl, which allows the Db2 admin to interrogate TSM about backups and logs. For the other backup systems are mainly black boxes from the Db2 side.

AWS S3 is for Linux and Cloud only. CommVault using the pull mechanism to suck in the backups from the file system leave a gap in time. TSM can do both. Db2 can write directly into TSM or TSM can pull the data from a Db2 servers file system.

Just my €0.03, YMMV

Roland

Hey All, 

Currently we are using Commvault to perform all of our Database backup needs.  We are not the owners of the Commvault product, but rather , our Hosting Vendor uses it for all of their database backups for all of their customers (Db2 and SQL server). 

Unfortunately, we have experienced several issues with Commvault, that have been very detrimental to our system.  If Commvault was managed by our team, it would likely be a different song, but it is not, so we are at a bit of a cross-roads with using the product in the future and management wants to get off of Commvault.

That said. . .

I am sure there are different options for creating a Db2 backup solution, and I am curious what others are using and how they feel about what they are doing.  Primarily, we need to take scheduled Full and Incremental backups as well as take care of the Log Archives.  I am sure we can come up with a Scheduled task solution and create our own scripts for doing this, but I am curious to know what others are using, and how they like what they are doing (basically the Pro's and the Con's).

I am going to do my own research, but I really want to hear from the people using the solutions rather than a salesman telling how wonderful their product is.

Hi Edward,

most backup solutions are mostly as bad as their admin is. And configuration of the backup system (push vs pull) is another thing.

Anyway, at one customer Veritas Netbackup is used and TBH it will not become my favorite for Db2. I also had once a customer with Omnibackup from HP.

But my personal favorite is TSM aka Spectrum Protect. It is fully integrated, never had any issues with anything like NetBackup or others. Maybe this was also dependent on the fact that we had an excellent TSM admin who understood the multiple tiers and other details of TSM so well. 
Another benefit is db2adutl, which allows the Db2 admin to interrogate TSM about backups and logs. For the other backup systems are mainly black boxes from the Db2 side.

AWS S3 is for Linux and Cloud only. CommVault using the pull mechanism to suck in the backups from the file system leave a gap in time. TSM can do both. Db2 can write directly into TSM or TSM can pull the data from a Db2 servers file system.

Just my €0.03, YMMV

Roland

Hey All, 

Currently we are using Commvault to perform all of our Database backup needs.  We are not the owners of the Commvault product, but rather , our Hosting Vendor uses it for all of their database backups for all of their customers (Db2 and SQL server). 

Unfortunately, we have experienced several issues with Commvault, that have been very detrimental to our system.  If Commvault was managed by our team, it would likely be a different song, but it is not, so we are at a bit of a cross-roads with using the product in the future and management wants to get off of Commvault.

That said. . .

I am sure there are different options for creating a Db2 backup solution, and I am curious what others are using and how they feel about what they are doing.  Primarily, we need to take scheduled Full and Incremental backups as well as take care of the Log Archives.  I am sure we can come up with a Scheduled task solution and create our own scripts for doing this, but I am curious to know what others are using, and how they like what they are doing (basically the Pro's and the Con's).

I am going to do my own research, but I really want to hear from the people using the solutions rather than a salesman telling how wonderful their product is.