数据库克隆db2move(国外英文资料).docVIP

数据库克隆db2move Roman b. Melnyk has DB2 information development, IBM Canada Ltd. The two DB2 tools, db2move and db2look, in May 2004, can be used to clone databases while not supporting cross-platform backup and restore operations. This article briefly introduces these two tools, and gives a step-by-step example of how to clone a DB2 database using this method. In the previous article (using redirected restore cloning DB2 database), I gradually introduced a database system on cloning to another machine running the same platform (or instance) on the process in detail. The main idea is to perform a redirected restore operation for a full database backup image. However, what if the backup source and the backup target platform are different? In this case, the redirection operation usually is useless, because we are usually not in an operating system on a database backup, and then to restore it to another operating system. Although you can now support some UNIX? There is a cross-platform backup and restore operation between platforms, but what if you want to use DB2? A database from a Windows? What about copying a server to a UNIX server? What about the other way around? DB2 Universal Database? DB2 UDB has a pair of very useful tools that can help you implement this cross-platform backup and recovery capability. The db2move tool takes advantage of DB2s data movement tools (export and import or load) to move the database tables. However, due to the content of the database is more than just the users table, so you need to use other methods in the different database migration between other database objects, such as constraints, triggers, indexes, sequence, table Spaces, buffer pool, etc. This is why the db2look tool appears. Use this tool, you can capture in the source database to define the object using the data definition language (DDL), and use these data definition language in the target database to create the object. Database mobile tool (db2move) Db2move tool can be out