On 12/18/2010 2:15 AM, adarsh khanna wrote:
I have a situation where I need to report updated records from an
Hi,
I have a situation where I need to report updated records from an IMS database
everyday.
On the first day, I run an IMS scan utility to report everything on the IMS DB
(around 30 million records).
From second day onwards, I have to scan the IMS DB again and compare it with
the
previous days file to report any updated records.
One solution is to use VSAM i.e. store all the records (30 million) in a VSAM
KSDS file (in the initial run) and compare each record on it everyday with the
scanned file subsequently.
I want to use DFSORT to compare and report only changed records.
My question is will DFSORT solution offer any advantage to VSAM one?
Thanks in advance
Adarsh Khanna
Have you considered using the IMS log to find changed records?
--
Richard
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
