Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Advantages of Archival Process

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sagarnsydney

New User


Joined: 12 Dec 2008
Posts: 16
Location: sydney

PostPosted: Wed Jul 29, 2009 5:39 am    Post subject: Advantages of Archival Process
Reply with quote

Hi Friends,

DB2 is database used by the application which I am supporting. This database is maintaining data since 1996 onwards.

I want to suggest to archive the data present in the DB2 database.

I want to project this to the client.

May I know need and advantages of archival process ( in terms of dollar value for the business ) to project to the client.

Many many thanks in advance.

Regards,
Sagar
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 29, 2009 7:52 am    Post subject:
Reply with quote

Hello,

Quote:
May I know need and advantages of archival process ( in terms of dollar value for the business ) to project to the client.
Knowing nothing about the environment and how resources are "charged back", i suspect we will not be able to suggest anything about $.

How often is the data in this database used in any process (loading more data, scheduled reporting, ad-hoc queries, etc)?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jul 29, 2009 12:11 pm    Post subject:
Reply with quote

I agree with Dick that without knowing nothing about the environment and how resources are charged back, we won't be able to suggest anything about $.

/Post Script

Once, I ran into a "similar" (may be) problem -- where it was requested by DOJ(US) that we should keep the data in a table for 7-years*. While from Technical point of view we needed to refer the data only for previous month! Then we kept the 3-years of data in table and rest on a tape file with appropriate LABEL (probably, as high sensetive data..) -- this might have save some dollars in terms of storage, but it saved (saves) our a** for sure.

*DOJM (equivalent to JCLM) was coining out in my mind that time... icon_biggrin.gif

/Post Script
Back to top
View user's profile Send private message
sagarnsydney

New User


Joined: 12 Dec 2008
Posts: 16
Location: sydney

PostPosted: Wed Jul 29, 2009 1:16 pm    Post subject:
Reply with quote

Hi Dick and Anuj,

Thanks for the information.

May I know the advantages of archival process not in terms of dollar value...so that I can project to the client.

Regards,
Sagar
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Jul 29, 2009 1:27 pm    Post subject:
Reply with quote

Every appplication is different, and may react well or badly to having data archived.

Only you know what the application is doing, so how can you expect us to tell you what will be gained or lost.

What would you consider a benefit of archival.

There is a lot of investigation and testing to go into an archival procedure for an application.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jul 29, 2009 1:39 pm    Post subject:
Reply with quote

Anuj,
Quote:
Then we kept the 3-years of data in table and rest on a tape file with appropriate LABEL (probably, as high sensetive data.


I didn't quite understand this part of the story, does it mean.....
a) only 3 years of data is in the table, the rest are not in table but backuped as an IC or unload file.
b) only 3 years of data is in the table(disk), the rest of the data is stored in tape but it is in the table.

Sushanth
Back to top
View user's profile Send private message
sreenivasreddyg

New User


Joined: 23 Apr 2005
Posts: 39
Location: delhi

PostPosted: Wed Jul 29, 2009 1:51 pm    Post subject:
Reply with quote

We had a table with millions of rows and so may rows get added each day. So, when the online screen is accessed to view the data, it was taking lot of time to get the rows. So, archival process is introduced to remove the old data (> 13 months from current date) from DB2 table and to keep on tape. Now, the wait time to get the data displayed on screen is reduced. We also have restoring process set up incase we need to get the data onto Db2 table from date when requested.

Thanks.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jul 29, 2009 2:06 pm    Post subject:
Reply with quote

Quote:
Archival process is introduced to remove the old data (> 13 months from current date) from DB2 table and to keep on tape


So Sreenivas, the data older than 13 months are backup'd(IC's) and deleted from the table. Is it like this ?

Sushanth
Back to top
View user's profile Send private message
sreenivasreddyg

New User


Joined: 23 Apr 2005
Posts: 39
Location: delhi

PostPosted: Wed Jul 29, 2009 2:21 pm    Post subject:
Reply with quote

IC- Image Copy? No this is external to DB2. I can tell you if you come to my desk when you have sometime.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jul 29, 2009 2:25 pm    Post subject:
Reply with quote

sreenivasreddyg wrote:
I can tell you if you come to my desk when you have sometime.
ROTFL -- Pune to Delhi, really?
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jul 29, 2009 2:38 pm    Post subject:
Reply with quote

Yes, IC is image copy.

So, the partitions having older data are stored in tape & current ones are stored in disk.

Sushanth.
Back to top
View user's profile Send private message
sreenivasreddyg

New User


Joined: 23 Apr 2005
Posts: 39
Location: delhi

PostPosted: Wed Jul 29, 2009 2:42 pm    Post subject:
Reply with quote

I am in Hyderabad and I think Bobby also.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts How to make REXX process different GDGs? venksiv CLIST & REXX 15 Thu Sep 24, 2015 5:35 pm
No new posts Stop Process when file is empty Roland Brosio DFSORT/ICETOOL 4 Thu Jun 25, 2015 1:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us