DB2 data archival, Db2 data purge and retrieval question.

RDBMS from IBM.
Previous topicNext topic

Topic author
Shankar Vijay
New Member
Posts: 3
Joined: Mon Jun 06, 2016 7:31 pm

DB2 data archival, Db2 data purge and retrieval question.

Post by Shankar Vijay » Sun Apr 30, 2017 9:32 am

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




enrico-sorichetti
Global Moderator
Global Moderator
Posts: 836
Joined: Wed Sep 11, 2013 3:57 pm

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

Post by enrico-sorichetti » Sun Apr 30, 2017 12:20 pm

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


cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort 8-)


nicc
Global Moderator
Global Moderator
Posts: 548
Joined: Wed Apr 23, 2014 8:45 pm

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

Post by nicc » Sun Apr 30, 2017 4:37 pm

The owner of the data should specify time-frames for archival and dispos\l. It is their data after all.


Regards
Nic

User avatar

Anuj Dhawan
Founder
Posts: 2418
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India

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

Post by Anuj Dhawan » Tue May 02, 2017 2:18 pm

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.


Thanks,
Anuj

Previous topicNext topic

Return to “IBM DB2.”