How to create a copy of a DB2 database table

Question: I’m making a change to DB2 LUW database table – and would like to first backup the table – before I make the change. What is a method for backing up a table and data? Answer: This method will create the table LIKE the source table , and then the INSERT statement will take all the data from the source table and INSERT into the target table. CREATE TABLE MYSCHEMA.A_NEW_TBL LIKE MYSCHEMA.AN_OLD_TBL; INSERT INTO MYSCHEMA.A_NEW_TBL (SELECT * FROM MYSCHEMA.AN_OLD_TBL); Note: Using this method will not copy across all objects associated with this table. The LIKE method copies the implicit... Read more →