DB2 data archival, Db2 data purge and retrieval question.

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
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 »

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: 825
Joined: Wed Sep 11, 2013 3:57 pm

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

Post 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
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: 691
Joined: Wed Apr 23, 2014 8:45 pm

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

Post by nicc »

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: 2799
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

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

Post 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.
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 »

Great resources. Thanks for sharing those articles Anuj.
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”