Import and export of DB2 Databases

Import and export of the DB2 database 1. Open the db2 command line Processor 2. Create a directory (skip this step if it is created)
Db2 catalog tcpip node nodename remote IP server 50000 (cataloguing node) www.2cto.com db2 catalog db dbname as mydb at node nodename (database instance) 3. connect to the database db2 connect dbname user username using password 4. export Database export to [path (example: D:/TABLE1.ixf)] of ixf select [field (example: * or col1, col2, col3)] from TABLE1; export to [path (example: D:/TABLE1.del)] of del select [field (example: * or col1, col2, col3)] from TABLE1; www.2cto.com 5. import Database import from [path (for example: D:/TABLE1.ixf)] of ixf insert into TABLE1; load from [path (for example: D:/TABLE1.ixf)] of ixf insert into TABLE1;