Post by RhinoI know of The Cloud but I haven't had to write code that works with the
cloud yet. Is it possible to back up a DB2 database (using 10.5.0 for
Windows) to the cloud? If so, how does one write the command to do so?
I'm not sure what the syntax should look like.
If it is not possible to do a backup directly to the cloud, how could I
do it indirectly?
Well, DB2 uses API to backup and restore data. Here is
what I have been able to find about that library:
http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.api.doc/doc/r0001908.html
That library is not an open source library, so you will
probably have to buy the specification from IBM. When you
implement that library, you will need to use vendor backup,
like this:
DB2 BACKUP DATABASE SAMPLE LOAD '/my/backup/library.so';
That is the same procedure as the one used by backup vendors
like Commvault, EMC or Veritas. Those vendors already have the
ability to backup to the cloud, but if you want to write your
own backup library, that's OK, too.
Another method would be to backup to your local directory and
replicate the file to the cloud. For that, you would only need
a "sync", probably based on rsync. The problem with that approach
is that it doesn't work very well with large databases. You would
need to copy a few TB from the cloud to the local directory and
then use restore and rollforward to get back your DB. With few TB,
that process is far from being instantaneous.
Also, cheap services like Glacier are much faster with putting the
data in than with getting the data out.
Regards
--
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com