thanks andy for your reply
but i have one more question,MESSAGES <msg file> is used by db2 for writing the error messages right?. and my question is the EXCEPTION TABLE which will be populated by the rejected rows during the load operation.
do we need to create it first or is it created automatically during load operation if we mention it?.
correct me if iam wrong