Table Partitioning in DB2 Viper – Details Part 2

(Chris Eaton) Let’s now look at rolling in new data. Assume you have a partitioned table where each partition is a month worth of data and you want to add a new month. The first step is to create a table that will hold the new month’s worth of data CREATE TABLE FACT_NEW_MONTH LIKE FACT_TABLE

Read More - Register for Free Membership