Can I use DataStage to backup records?

sunitha_cts · Post by **sunitha_cts** » Tue Jul 16, 2013 12:20 am

Hi All,

I need to take a backup of records of 1 year at the end of every seventh year.
How could we implement this scenario .

Thanks
Sunitha

ArndW · Post by **ArndW** » Tue Jul 16, 2013 12:47 am

Are you sure that this is a DataStage question or a systems question? You will need to supply a bit more information so that you can get meaningful responses.

Are you looking for logic to implement in DataStage in order to select the correct records and to write a generic job to process the table(s)?

sunitha_cts · Post by **sunitha_cts** » Tue Jul 16, 2013 1:02 am

I'm looking for the logic to implement in datastage.

Thanks
Sunitha

ray.wurlod · Post by **ray.wurlod** » Tue Jul 16, 2013 4:03 am

DataStage is not really a backup management utility. Prefer the correct tool for the job, and for the job of managing your backup archives (for example IBM InfoSphere Optim Data Growth Solution).

If you really must use DataStage it's just another ETL task - you need to identify a mechanism for determining which records to extract from source, and a mechanism that can trigger once every seven years (this will really need to be a third party scheduler).

chulett · Post by **chulett** » Tue Jul 16, 2013 7:19 am

sunitha_cts wrote:I'm looking for the logic to implement in datastage.

Then as noted you'll need to detail your requirement, right now it's a little too vague. "Backup" means what in this context? Do you actually mean purge? And "one year at the end of every seventh year" needs to be clarified as well.

sunitha_cts · Post by **sunitha_cts** » Thu Jul 25, 2013 4:14 am

Yes it is purge

chulett · Post by **chulett** » Thu Jul 25, 2013 7:11 am

So... one thing clarified, you want to delete records in spite of putting 'data loading' in the subject. Everything else is still vague though, as noted.