Exporting and importing data from specific tables

You export data from specific table/s using the command -

db2 export to filename of ixf select * from table 

where ixf is the file-type

You import into specific tables using the command -

db2 import from filename of fileformat import_mode into table


where there are 3 import modes. The commonly used one, for backing up and versio - ning is-

REPLACE - to keep table structures and indexes, and replace data