DB2 CONNECT TO database USER name USING password
DB2
CREATE SCHEMA new_schema
CREATE TABLE new_schema.tablename LIKE old_schema.tablename
EXPORT TO tablename.IXF OF IXF SELECT * FROM old_schema.tablename
IMPORT FROM tablename.IXF OF IXF REPLACE INTO new_schema.tablename