View previous topic :: View next topic
|
Author |
Message |
sagarnsydney
New User
Joined: 12 Dec 2008 Posts: 16 Location: sydney
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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...
/Post Script |
|
Back to top |
|
|
sagarnsydney
New User
Joined: 12 Dec 2008 Posts: 16 Location: sydney
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
sreenivasreddyg
New User
Joined: 23 Apr 2005 Posts: 39 Location: delhi
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
sreenivasreddyg
New User
Joined: 23 Apr 2005 Posts: 39 Location: delhi
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
sreenivasreddyg wrote: |
I can tell you if you come to my desk when you have sometime. |
ROTFL -- Pune to Delhi, really? |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
sreenivasreddyg
New User
Joined: 23 Apr 2005 Posts: 39 Location: delhi
|
|
|
|
I am in Hyderabad and I think Bobby also. |
|
Back to top |
|
|
|