2012-02-01 01:58 AM - edited 2015-12-18 12:40 AM
My customer is looking to re-platform their SAP onto FlexPod, and to switch from Oracle to DB2. They use SMSAP today but clearly that's no longer an option once Oracle is out of the picture. I'm fishing to find out how close to SMSAP functionality we can get today, using SnapCreator with relevant plugins (either built-in or community), when using SAP with DB2?
Happy to take your views.
2012-02-01 02:30 AM
You'll miss the automatic cloning capabilities, and right-click
point-in-time automatic restore and recovery that you have in the GUI.
But it's not much of an issue as you can still do all those steps
manually, or even script them and automate them (well I'd stick to the
cloning capabilities here).
What you'll gain in terms of performance, Oracle license costs will
certainly pay off the move
2012-02-01 03:07 AM
Agreed. We want to avoid manual steps and direct execution of scripts because of the potential for human error :-) Fixed scripts, run behind a GUI interface would be fine.
Lower licence costs, and DB2s ability to do in-database compression, are the key reasons for the customer wanting to switch to DB2.
2012-02-01 04:31 AM
Okay.... not ALL human errors. My point was that SnapManager allows customers to manage and automate admin tasks without having to create, maintain or fix command-line scripts.
I'm more interested in discussing what we have for managing SAP on DB2 to give SMSAP functionality around snapshot backup, recovery, and cloning.
2012-02-01 07:46 AM
Snap Creator integrates with DB2 or any SAP database but not with SAP directly. For MaxDB there is additional integration but that is because SAP provides that DB and has some added features to integrate better with SAP.
Where SC differs from SMSAP
1. No BRtools integration
2. SC can restore data but doesnt perform recovery for DB2, recovery is manual...but most people actually prefer this.
3. SC can clone data and mount file systems on same host or a clone host but it wont perform any DB2 related steps. You need to change sid or whatever on your own.
Both 2 and 3 can be automated through the framework, just not handled out-of-box.