Point-in-timecopiesofDB2with详解.PDFVIP

Point-in-time copies of DB2 with HPE 3PAR StoreServ Virtual Copy Technical white paper Technical white paper Contents Executive summary 3 Target audience3 Introduction3 Point-in-time copy creation mechanisms3 General approach to point-in-time copy creation 3 Solution architecture4 Platform details 4 Architecture 4 Tested configuration5 HPE 3PAR StoreServ snapshot configuration 6 Primary database setup7 Taking point-in-time snapshots of DB2 database8 Refresh or resync the snapshot database with primary database 11 Conclusion14 Appendix 14 Appendix A—set up certificate-based SSH authentication 14 Technical white paper Page 3 Executive summary Point-in-time copies of a database are required on numerous occasions such as backup, development, database testing, and more. In order to take consistent point-in-time snapshots of data volumes used for databases, the storage array and the database software have to work in tandem. This white paper describes how point-in-time copies with an IBM DB2 database can be created using the features available on HPE 3PAR StoreServ Storage arrays along with DB2 hosted on the AIX operating system. It shows how a single host can be used to take point-in-time copies of DB2 database and make it available as another instance on the same host without disrupting the activities on the primary database. Target audience This white paper is written for IT professionals who would like to implement point-in-time copies of IBM DB2 database hosted on AIX operating system and using an HPE 3PAR StoreServ Storage array. It covers all the steps involved in the procedure in detail. Introduction Point-in-time copy creation mechanisms There are different mechanisms to take point-in-time copies of databases. These can be classified