Cloning a DB2 Database Server

You may also like...

2 Responses

  1. Sathy Sannasi says:

    Thanks for sharing this. That is a very useful post, as always.

    As you say, it is not advisable to clone when you the database is in use.

    An alternate to shutting down the database is to use SET WRITE SUSPEND command before cloning and then on the cloned database, using db2inidb (with relocate using option, if required).
    If your underlying system clone runs only for a few seconds, then you may be able to get away with your website users not even noticing the “downtime”.

    Thanks

    Sathy
    uk.linkedin.com/in/sathyaram

    • Ember Crooks says:

      Great, thanks for this. Most of the cloning I tend to do is spinning off additional development environments so I forget nifty commands like set write suspend.

Leave a Reply

Your email address will not be published. Required fields are marked *