Want to batch copy data from one DB2 tables to another DB2?
Using Withdata software DB Copier, a DB2 data transfer for Windows, MacOS, and Linux, you can copy data from one DB2 tables to another DB2 in a batch, easily and fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
Download DBCopier
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
Batch copy tables data from one DB2 database to another
Login to source and target DB2 -> Select DB2 tables to copy -> Copy data between DB2 databases
Choose source/target DB2 database and logon.
Click “Convert All Tables” at task dialog.
then show the wizard.
1. Select source DB2 tables.
2. List target DB2 tables.
3. Select target DB2 tables to copy data.
4. Copy data between DB2.
Copy DB2 tables in command line
Save “Copy DB2 tables” session, then you can:
- Copy DB2 tables in Windows command line.
- Copy DB2 tables in Linux command line.
- Copy DB2 tables in macOS command line.
Set scheduled tasks for coping DB2 tables
You can schedule and automate this “DB2 Copy” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.