473,385 Members | 1,324 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,385 software developers and data experts.

DB2 Live Database Replica for Reports

Hi Everybody,
I am new to DB2 and I am not a core Database admin. I use database for reports purposes with Business Objects. Following is the problem i am facing and expect a solution here.

Requirement:
1) We have a Transaction DB2 database
2) We need to create another database(a replica) of the above mentioned database and it should hold Live/Almost live data. This database will be used for Reporting. We thought of this approach because the reports selection(read only) will not cause any performance issues to the front end or to the database itself.
3) Initially we thought MQT will be a better option. Refresh Deferred will populate the staging table as and when the transaction database gets updated and we thought of using a trigger on the staging table. i.e. as and when the staging table gets updated, we refresh the target database. Not sure if this will work. Please comment on this. Also we came to know that using additional commands we can say that the transaction tables are not locked when we read for MQTs.

Is there a better way to create a seperate ODS for reporting? Which is live?

We planned to use Business Objects as the reporting tool and found that Business objects generated query can use "WITH UR" function so that the transaction database is not locked when the reports are reading directly to the transaction database.

Is it advisible for application and reports running directly on the transaction database? Will this also affect the performance?
Jul 24 '08 #1
0 1498

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Michael Teare | last post by:
I have a database that I need to create a replicated copy of. The database app. is 2 mdb files one of which contains the forms, reports, queries etc the other contains only the tables. Do I...
7
by: nydiroth | last post by:
Our servers went down for over 6 hours yesterday and I was asked if there was a way to store the database on the server and a local station at the same time. My datbase is split and the tables...
1
by: MAILTONRK | last post by:
Hi, I am a Mainframe guy. I am working with MS access(maintaining a application) for the last 2 weeks. I had one master database and four replicas. One of my replica had trouble in...
10
by: Janelle.Dunlap | last post by:
In the database that I am creating I need to be able to rename the file with a name that the user specifies using the Save As Dialog window (I already have the code that brings up this window). In...
18
by: Asif | last post by:
Hi all, I am working on portal which is using MS Access 2003 database. The problem that I am facing is that once I received data from vendors I have to upload whole Access Database file to...
2
by: chris_huh | last post by:
I am doing a project on beetle diversity and need to calculate a few diversity indices for a load of data i have collected. I thought that maybe i could make a program in php to do that for, and...
30
by: iheartvba | last post by:
Hi, I already have 3 Databases running: A. they all have the same tables and the same structure B. There is no 1 Master table they are all separate tables What I want to do is to merge them...
3
by: MRileyDE | last post by:
I am working on an replica Access database with VB Coding that is used by multiple computers. On some computers, when one opens the database - a db1.mdb will appear as if it's copying itself. For...
3
by: kgudgel | last post by:
I am relatively new to the replication process in Access. My issue is that I have a Design Master and one replica. End users have been using the replica and adding data to the tables. I recently...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.