Hi, I am currently working on an application where the requirement is to write a java batch program that would extract the records (37,000) every week from DB2 on OS390 and then validate a each record against the Oracle table and then insert that record to the other table in Oracle. The Oracle db is in Unix. So this has to be run weekly on Sunday night. Control M is used for trigerring the job. I am trying to work on the solution for the extract and load part.
Would it not be burden on the Db2 to oopen a connection with 37000 records and do validation against each record. I am conceenred of any database locks that might be caused.
It would be really great if any of you can assist me in my requirement. This is a kind of urgent situation..
Thanks in advance.