Create a copy of a table within the same database DB2

Try this:

CREATE TABLE SCHEMA.NEW_TB LIKE SCHEMA.OLD_TB;
INSERT INTO SCHEMA.NEW_TB (SELECT * FROM SCHEMA.OLD_TB);

Options that are not copied include:

• Check constraints
• Column default values
• Column comments
• Foreign keys
• Logged and compact option on BLOB columns
• Distinct types