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.
DB2 Bulk Load Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Issues while using DB2 COnnector
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)
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)
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>