The IBM DB2 external loaders load from a delimited flat file. Verify that the target table columns are wide enough to store all of the data.
For a connection that uses IBM DB2 client authentication, enter the PmNullUser user name and PmNullPasswd when you create the external loader connection. PowerCenter uses IBM DB2 client authentication when the connection user name is PmNullUser and the connection is to an IBM DB2 database.
For a session with multiple partitions, use the round-robin partition type to route data to a single target file.
If you configure multiple targets in the same pipeline to use IBM DB2 external loaders, each loader must load to a different tablespace on the target database.
You must have the correct authority levels and privileges to load data to the database tables.