Extract specific rows from Sequential File
Posted: Mon Apr 14, 2008 10:25 am
I used DB2 Load utility to load from a seq. file that is around 10gb file. Utility gave some reject log and showing record number in it which are rejected or partially loaded. I want to see those rows from sequential file. I used a px job with transformer (running sequentially) and filter those record number into another seq file. I used a stage variable with an incremental of 1 to filter the records.
I have started running it but target file is growing around 2gb although i have only 10 records for filteration. Because source file is 9gb so job would take time to finish.
Is this right solution or what other options i do have to pickup those record numebr from sequential file ?
I have started running it but target file is growing around 2gb although i have only 10 records for filteration. Because source file is 9gb so job would take time to finish.
Is this right solution or what other options i do have to pickup those record numebr from sequential file ?