DB2 Bulk Load Stage

[DSFreddie]

Hi,

I am planning to do a Bulk Load to DB2 Tables. Pls suggest me the best way of doing it.

Also, pls let me know whether there are any prerequisites in the DataStage/Table level as well as any other settings that needs to be done to do it.

This is a parallel job.

Thanks
Freddie.

[ray.wurlod]

Use the bulk load option in DB2 Connector or DB2 Enterprise stage.

[DSFreddie]

Hi Ray,

Thanks for your reply.

I am encountering an error message as shown below while using the Db2 Connector Stage. Pls help.

DB2_Connector_11: [IIS-CONN-DB2-000369] Error in environment configuration: The target table has 8 partitions but the environment configuration has 3 node(s) available. Make sure there are at least 8 nodes in your environment configuration. It is required that the number of nodes in the environment configuration be greater than or equal to the number of database table partitions when the partitioner is set to DB2 Connector or when using the bulk load write mode with more than one node in the environment configuration. (CC_DB2Connection::assignPartNumsToEnvironmentNodes, file CC_DB2Connection.cpp, line 2,632)

[ArndW]

You don't have much choice, create a 8 node configuration file and use that for jobs that load to your 8-way partitioned database. It will be quite efficient.