I am using db2 load with a huge ixf file (around 50 lac records). There is 1 record rejected due to the assignment of a null value to a not null column. I want to collect that rejected record in a file/table. I used db2 load with exception clause but the rejected record is not getting loaded into the exception table. Any idea how to get this rejected record.