DB2 – COPY a table

Different methods of extracting DDL and moving data.  Use according to the situation

1)  Gives you the table CREATE statements

db2look -d  DBNAME -e -t TABNAME

2) Use the DB2 Control Center to copy table and data

3)  Use the CREATE … LIKE   for the table structure

CREATE TABLE    LIKE  

Follow up with 

INSERT INTO TAB1 (SELECT * FROM TAB2)

See Also

db2move to copy data between databases