MVSFORUMS.com

gavini_vasu · Beginner Joined: 28 Jun 2005 Posts: 2 Topics: 1

Hi All,

I have a table TAB1 in database DataB1. This table is huge ( 2 million rows).
My requirement is to create the same table TAB1 under a different database called DataB after which we intend to drop TAB1 in DataB1.

The strategy I have thought about is to unload TAB1 into a file.
Create TAB1 in database DataB.
Load the table with the data from earlier unload.
Drop old table from DataB1.

Right now, I have a problem with unload. Data is huge, space and window time are constraints.

1. How can I unload data in partitions ? ( I am using DSNTIAUL )
2. It would be great if somebody can help with better alternatives to this job.

Thanks,
Vasu

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

gavini_vasu,
Is the tablespace partitioned? 2 million is not a huge number and do you have tools like Platinium utilities? There are several examples for unloading by partitions. Typcally unloading 2 million rows should not take too long and also check your site specifications for compression (DATACLAS=*******) it would help mitigate space issues. Thanks

raam_narayan · Beginner Joined: 28 Apr 2006 Posts: 12 Topics: 2

Hi Vasu,

I had got ur problem is Extracting the data's from DB2 to Flat file.. It's not a big issue to extract 2 million rows.. what u can do is if ur Shop floor is using FILE-AID RDX u can use that tool or u can simply use FILE-AID DB2 and u can accomplish the process.. The reason why I'm telling is use FILE-AID RDX is because even if u have any kind of Check constraints or if the Base table is having any kind of Dependency / siblings the tool wud take care of that and most important is the Destination File should have the size to hold the 2 Million records..revert back in case of any issue...

Thanks & Regards,
V.Ram NArayan