Ron Thomas wrote: >We have a huge table with around 125 million records and we are unloading >this file in a job based on the current date, there are some instances where >this job gets delayed and runs past 12.00 AM and the records fetched is not >correct. Could some one please let me know in the unload whether we can pass >some parms as we have a cycle file which has the current date stored and by >this way we need not worry whether the job is delayed or not.
and >We are using DB-2 unload utility as the table size is 125 million, the Unload >data is fed to the downstream programs for further processing. You did not answered all of Lizette's questions. My one question is: What is 'unload'? Is it a dump, copy (re-formatted contents or not) , SQL query, etc? Also you asked about 'parms', but you did not said what parms you tried out or against what program you're trying to use parms. I have other questions: What version of DB2 do you have? Is this an once off problem or not? For how long is it that you have that huge table? With what are you 'fetching' the records and storing it somewhere else? Some possible suggestions: Do your work hourly or give your job higher priority or split up your table in smaller chunks. Best solution was given by Ed Gould! Groete / Greetings Elardus Engelbrecht ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN