Rubrik Anyone

I hope I am not breaking any IBM rule asking this question but we are evaluating Rubrik as a replacement for TSM. I would appreciate any insight from anyone involved in that process. From what I saw, I am not sure it is the right tool for Informix yet or even for DB2. Thanks Walter ------------------------------ Walter Milan ------------------------------ #Informix

It is not something that is known to Informix development I would venture. Use the Informix Primary Storage Manager, which has an unlimited number of threads to backup dbspaces in parallel. It is free and comes with the product. Works with onbar but not ontape as ontape does not need a storage manager. Fully in support. Scott Pickett IBM Informix WW Technical Sales IBM Informix WW Cloud Technical Sales IBM Informix WW Cloud Technical Sales ICIAE IBM Informix WW Informix Warehouse Accelerator Sales Boston, Massachusetts USA spickett@us.ibm.com 617-899-7549 33 Years Informix User The current Informix Roadshow presentations are here: https://community.ibm.com/community/user/hybriddatamanagement/viewdocument/informix-1410xc2-features?CommunityKey=cf5a1f39-c21f-4bc4-9ec2-7ca108f0a365&tab=librarydocuments All presentations and the agenda used by the Roadshow can be found there. Website for Internet Of Things https://www.ibm.com/internet-of-things/ Website for Informix https://www.ibm.com/analytics/us/en/technology/informix/

Rubrik doesn't have a real API for Informix but you can use the managed volume option. As Scott mentioned, you will need to use Informix PSM and write to NFS. One option would be to embed your backup script with API calls to mount the managed volume and then unmount it, or you could simply write to NFS directly using Informix PSM and let Rubrik backup the managed volume using their standard file system backup. There is the problem that the PSM catalog does not correlate to a Rubrik catalog. You would have to export the PSM catalog and let Rubrik back it up as well. If a restore is needed, you'd need to restore the PSM catalog and import it. Hugo Tellez ------------------------------ Hugo Tellez ------------------------------

We are adopting Rubrik for another RDBMS we support where it offers an API. The PSM/onbar, NFS and Rubrik combination offered by Hugo is interesting. With API support, Rubrik has the potential to offer much faster restores than are possible with a level 0 onbar restore. I am not sure you would see this benefit if Rubrik is actually restoring to a filesystem presented by NFS which then needs a PSM/onbar restore. It's perhaps worth evaluating which backup solution vendors directly support Informix. Most sell a complete storage solution. * Veritas Netbackup, although development ceased in 2013 and the latest GUI manager does not support Informix. * Commvault, don't know much about this one. * Tivoli. * PSM of course. Any others? ------------------------------ Benjamin Thompson ------------------------------

Dell EMC NetWorker ? Regards Rainer

Hi, Veritas Netbackup is still under development: https://www.veritas.com/content/support/en_US/downloads/detail.REL283803 Release date: 2021-06-07 https://www.veritas.com/protection/netbackup/whats-new Key Features in NetBackup 9.0 – GA Release: January 4, 2021 Regards, David. ------------------------------ David Williams ------------------------------

Sorry if my post was unclear and maybe misleading. I was referring only to the Informix component, not the whole Netbackup product. ------------------------------ Benjamin Thompson ------------------------------

I have had the chance to migrate to Rubrik as a backup solution and found using PSM with local storage to be easy. The overall setup was easy to understand and didn't require the DBA to know the backup solution. In the end, we got it down to only a few pages if/then documentation to cover even the worse case recovers we could dream up. Before supporting more than one backup solution, it would be best to explore what a PSM process would look like (I believe Tom Bebee has a good PSM Webcast). I have seen Informix deployments move to use PSM even when an API is available to avoid storage manager issues. Using PSM with local or NFS storage allows the DBA to drop the backup in a folder and move on. With that said, do your other DB's teams want to deal with an API call? For example, many of the MS SQL teams I have worked with would prefer to use a share with folders for backups as they are easier to see what is available and restore much quicker. Each method has its own pro/con and may make it easier to have your teams all on the same page. It's been a few years since I last checked in on the Rubrik Informix API, at which time it was on the roadmap for release in 2020. Worth asking the rep to understand where it is on the roadmap, if at all. ------------------------------ ~~~~~~~~~ Eric Rowell ------------------------------