SQL3502N The utility has encountered "XXX" warnin

cherry · Post by **cherry** » Tue Jun 21, 2011 1:51 am

Hi All,

Iam trying to load data from a dataset to DB2 using Bulk load stage.

Iam getting the following error:

SQL3502N The utility has encountered "200" warnings which exceeds the total number of warnings allowed.

Will someone please help, what would be the fix.

Thanks in advance

Regards
Cherry

MT · Post by MT » Tue Jun 21, 2011 2:05 am

Hi cherry

check the message file of the DB2 LOAD utility.
The message file is one of the options you should (always) use
with DB2 data movement utilities in order to get some more details about what went wrong.

Your DBA can assist you as well in any LOAD related problems.

regards
Michael

cherry · Post by **cherry** » Tue Jun 21, 2011 2:17 am

Thanks Michael,

I checked and found the data from imput is not matching to the output dataypes and the data being truncated.

Regards
Cherry