Hi All,
We have a critical problem and I require your inputs on this.

We are in the progress of creating a new data model and we need to do performance testing on the same.

We have about 60 tables with 50 records of sample data in each. Now we need to replicate this to 100 million records in each table with all the constraints and referential integrities. How can we perform this task? Is there any tool that can help in accomplishing this? If not, any type of programming can be done to achieve this? Please help on this.

Regards,
Sach

I suggest to try with db2look and db2move because shipped with the db2 pack