Partitions in DataStage - DB2UDB

kaps · Post by **kaps** » Thu Jan 25, 2007 1:19 pm

Hi

Source is Sequential file
Target is DB2UDB table
AIX server

We have to insert huge amount of records(70 millions) as part of the initial load into a table. If the Target table is partitioned is there any way to route the records using DataStage to particular partition in DB2UDB database. Target table is what they call hash partitioned. As far as I understood I think this acts on a high cardinality field to figure out which partition to go to. There is an API in DB2 called sqlugrpn to determine the parition number. Is anyone used this API in DataStage ?
If so can you shed some light on how to use it ?

Thanks

DSguru2B · Post by **DSguru2B** » Thu Jan 25, 2007 1:26 pm

You can use the DB2Load Stage. It has options to load partitioned database.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 25, 2007 3:23 pm

Another possibility, if you have it, is to use a parallel job, in which the DB2/UDB Enterprise stage is intimately cognizant of the DB2 partitioning algorithm.