Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
Back to discussions
Expand all | Collapse all

AWS EC2 clone Db2 database

  • 1.  AWS EC2 clone Db2 database

    Posted 18 hours ago

    Hello,

    my customer is migrating from Db2 for z/OS 12 to Db2 11.5.9 on Linux running on AWS EC2. The database size is over 15 TB.

    The customer needs to create a clone of the database on a weekly basis. I am considering using storage-level snapshots to create the clone.

    Proposed approach:

    1. Issue SET WRITE SUSPEN on the source database.
    2. Create storage snapshots for all volumes containing the database.
    3. Issue SET WRITE RESUME.
    4. Create new volumes from the snapshots and attach them to the target server.

    Issue db2inidb <database_name> AS SNAPSHOT RELOCATE USING <config_file>

     
    Does anyone have experience with this approach for large Db2 databases on AWS EC2? Are there any known limitations or best practices to consider? Is there any IBM or AWS documentation that describes this procedure and its prerequisites in detail?

    Thanks in advance. Ciao. Roberto.



    ------------------------------
    Roberto Stradella
    ------------------------------


Related Content