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: 876
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: 580
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: 2497
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

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

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.

User avatar

Hollisey
New Member
Posts: 1
Joined: Thu Oct 19, 2017 1:18 pm

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

Post by Hollisey » Fri Oct 27, 2017 12:08 pm

Great resources. Thanks for sharing those articles Anuj.



Previous topicNext topic

Return to “IBM DB2.”