DB2 data archival, Db2 data purge and retrieval question.

RDBMS from IBM.

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

DB2 data archival, Db2 data purge and retrieval question.

Postby 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



Online

enrico-sorichetti
Global Moderator
Global Moderator
Posts: 811
Joined: Wed Sep 11, 2013 3:57 pm
Been thanked: 68 times

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

Postby 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: 529
Joined: Wed Apr 23, 2014 8:45 pm
Been thanked: 11 times

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

Postby 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: 2381
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Has thanked: 149 times
Been thanked: 65 times

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

Postby 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


Return to “IBM DB2.”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests