This article mainly describes how to copy and migrate data from IBM DB2. The methods in this article are tested in the Environment IBM x346, 3.2G × 2, 4G, RAID 1, in DB2 V8.2.4, Win2000 Adv Server, and DMS tablespaces, the data load speed is about 60-entries/min.
Background: You need to change the tablespace of the database, or migrate data from all tables in the database to a new database.
Steps:
1. Select all tables in the source database through the db2 Console (db2cc) and export them as DDL scripts;
2. Make necessary modifications to the script as needed, such as changing the tablespace to GATHER;
3. Create a database and create a DMS tablespace: GATHER;
4. Run the DDL script in this database;
5. write code to query all tables in the source database and generate an export script automatically;
6. write code to query all tables in the source database and generate an import script automatically;
7. Connect to the source database and execute the export script;
8. connect to the target database and execute the import script;
Appendix 1: Sample Code for generating an export Script :/**
Create an export script
- * @ Param conn
- * @ Param creator: Table creator
- * @ Param filePath
- */
- Public void createExportFile (Connection conn, String creator, String filePath) throws Exception {
- DBBase dbBase = new DBBase (conn );
- String selectTableSql = "select name from sysibm. Variables Ables where creator = '" + creator + "' and type = 'T '";
- Try {
- DbBase.exe cuteQuery (selectTableSql );
- } Catch (Exception ex ){
- Throw ex;
- } Finally {
- DbBase. close ();
- }
- DBResult result = dbBase. getSelectDBResult ();
- List list = new ArrayList ();
- While (result. next ()){
- String table = result. getString (1 );
- List. add (table );
- }
- StringBuffer sb = new StringBuffer ();
- String enterFlag = "\ r \ n ";
- For (int I = 0; I <list. size (); I ++ ){
- String tableName = (String) list. get (I );
- Sb. append ("db2 \" export to aa "+ String. valueOf (I + 1) +". ixf of ixf select * from "+ tableName + "\"");
- Sb. append (enterFlag );
- }
- String str = sb. toString ();
- FileUtility. saveStringToFile (filePath, str, false );
- }
The above content is an introduction to the data replication and migration methods of IBM DB2. I hope you will find some gains.