DB2 Import and Export database data

Export data in a database

Build a library script under the Db2cmd command (-Z to specify the schema name)

db2look-d bbs-z db2admin-u db2admin-e-o bbs.sql

Export data under the Db2cmd command

Db2move BBS export-sn db2admin-u db2admin-p db2admin

Import data to a database

1. Use the specified CSV format data file and generate the log file

Import from "D:/tmp/qm_east_info.csv" of DEL Messages "D:/tmp/msg.out" INSERT into Qm_east_info;

2. Create a database table under the Db2cmd command

DB2-TVF Mtp.sql-l Log.txt

Import data

Under the db2cmd command db2move BBS import-io replace-u db2admin-p db2admin

DB2 Import and Export database data