Page 1 of 1

DB2 data archival, Db2 data purge and retrieval question.

Posted: Sun Apr 30, 2017 9:32 am
by Shankar Vijay
Hi,

For a new batch process I need to develop a logic for DB2 data archival, Db2 data purge and retrieval system. If someone of you have some ideas on this, if yes then please provide me a guidance idea on this

Regards

Re: DB2 data archival, Db2 data purge and retrieval question.

Posted: Sun Apr 30, 2017 12:20 pm
by enrico-sorichetti
these kind of processes have been in place since the beginning of the IT era
why not ask inside Your organisation to find out about the standards being used ?
too many functions are involved for a solution based on forum replies

Re: DB2 data archival, Db2 data purge and retrieval question.

Posted: Sun Apr 30, 2017 4:37 pm
by nicc
The owner of the data should specify time-frames for archival and dispos\l. It is their data after all.

Re: DB2 data archival, Db2 data purge and retrieval question.

Posted: Tue May 02, 2017 2:18 pm
by Anuj Dhawan
This is pretty broad question and can have a very long answer, which seems beyond the scope of the Forum. And as has been mentioned, such procedure should already be in practice at your shop. But if you are fairly new to this concept, suggest you do some reading using the below articles and you might get an initial understanding to proceed further with your original quest:

Archive-enabled tables and archive tables
5 Things to Know About DB2 for z/OS Archive Transparency

Hope this helps.

Re: DB2 data archival, Db2 data purge and retrieval question.

Posted: Fri Oct 27, 2017 12:08 pm
by Hollisey
Great resources. Thanks for sharing those articles Anuj.