473,322 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Db2 mirror tables

Hi.

I need to mirror a set of my database data, that is create a database
which acts as a buffer in front of the real one.
We have in our DB2 database data which has been created over the last
100 years or so, and is obviously huge amount of data. All normal
operation is done though on data which has been created over the last
30 days or so.

Is it possible to create database which only holds data created over
the last 30 days. Further more all inserts, updates and deletes should
affect both the huge database and also the small one. Any suggestions
would be greatly appriciated.

Jun 27 '06 #1
2 2994
Sprellari wrote:
Hi.

I need to mirror a set of my database data, that is create a database
which acts as a buffer in front of the real one.
We have in our DB2 database data which has been created over the last
100 years or so, and is obviously huge amount of data. All normal
operation is done though on data which has been created over the last
30 days or so.

Is it possible to create database which only holds data created over
the last 30 days. Further more all inserts, updates and deletes should
affect both the huge database and also the small one. Any suggestions
would be greatly appriciated.

Well ... this is not what I would call a mirror. Best way to accommodate
this is to do it within your design schema and your application, IMHO.
There are many other questions, though, that must go into this. For
example, how much data is involved in each? Does the "historical" data
ever need to be accessed after it is inserted to? Does it ever need to
be joined with the "30-day" data?

Larry Edelstein
Jun 27 '06 #2
Ian
Sprellari wrote:
Hi.

I need to mirror a set of my database data, that is create a database
which acts as a buffer in front of the real one.
We have in our DB2 database data which has been created over the last
100 years or so, and is obviously huge amount of data. All normal
operation is done though on data which has been created over the last
30 days or so.

Is it possible to create database which only holds data created over
the last 30 days. Further more all inserts, updates and deletes should
affect both the huge database and also the small one. Any suggestions
would be greatly appriciated.

It *might* be possible to do this using an MQT, although I think there
is probably a better solution:

You could look in to using multi-dimensional clustering (MDC), or (even
better), look into range partitioning that's available in DB2 9.
Jun 27 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Andrew James | last post by:
All, I'd like to be able to use psycopg2's new features for my development work with postgresql, but unfortunately the init.d site seems to be broken and I can't get to the repository there. ...
0
by: barbaros | last post by:
Hi everybody, I am trying to implement a cgi script for mirroring a small part of a large collection of files (the debian distribution). The idea is to mirror only those files which are...
1
by: hikums | last post by:
Can anyone post the procedure to split mirror steps for Veritas or Legato or from any vendor? ,so that I can better it. I understand the suspend i/o and initialization(db2inidb) , but need to...
3
by: Dzemo | last post by:
I need way to have text in label and look like in mirror like "ambulance" so when i look text via mirror it print fine. Not "ecnalubma" but exactly like in mirror. thx
3
by: Eduard Witteveen | last post by:
Hello list, I have code the draw MyDrawingObject information on a System.Drawing.Graphics object. The code is more/less the following: I now want to rotate / mirror the object i draw. I've...
0
by: virtualadepts | last post by:
In Ancient time mirrors were held to be sacred, but they only had pools of water and pieces of metal available to observe their own reflection. The only way to get a clear image of what you looked...
0
by: CoreyWhite | last post by:
In Ancient times mirrors were held to be sacred, but they only had pools of water and pieces of metal available to observe their own reflection. The only way to get a clear image of what you looked...
4
by: Mark A | last post by:
I would like to make a split mirror copy of a HADR standby database. Please note that I do not want to create a standby with a split mirror of the primary, but I want to make a split mirror of the...
1
by: Andy | last post by:
I want to store a key in an ASP.NET session variable that points to an ASP.NET page cache. The page cache contains an XML document that holds a draft of the user's work. After the user is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.