Judy,
We use DB2 Replication to replicate data from our DB2 source databases to a
DB2 target database. We currently replicate changes from source db(s) to
target db about every 45 minutes (time interval is adjustable). Customers
can link their query tools to this target db which is used only for Ad Hoc
query and reporting purposes. We can then tune this target database just
for querying. The impact on our source databases is greatly reduced plus
our customers are happy. It is working well for us, but it does require a
little more maintenance work to keep target db and replication
subscriptions up-to-date with source db table alterations, etc.
Hope this was helpful!
Patrick Hans - Database Administration
State of Nebraska Department of Roads
E-mail: [EMAIL PROTECTED]
judith.kibler@
trw.com To: [EMAIL PROTECTED]
Sent by: cc:
owner-db2eug@l Subject: [DB2EUG] Reporting tools
ugwash.org
03/07/2002
12:26 PM
Please respond
to
judith.kibler
Hello all,
We run the Baan ERP application on AIX 4.3.3 and DB2 UDB EE v7.2. Our
customer
has a need to do adhoc reporting against the Baan DB2 database. Our first
cut
at providing a cost-effective solution was to copy the data from a few DB2
tables to corresponding Access tables for them to report against. We
refresh
that data nightly. Over time, our customer's needs have grown, and they
are now
requesting several more tables to be copied to Access, thereby requiring a
much
larger window of time to refresh. We have come to the conclusion that they
soon
will outgrow the original solution, and we are looking at other options.
Our first thought was to allow the users to link directly to the DB2 data,
using
Access links via the DB2 ODBC driver. They could continue to use (with
some
fairly significant modifications) their existing Access macros/queries.
Our
obvious concerns are with the performance of their queries, as well as the
effect their querying will have on Baan application performance.
We are also entertaining the idea of other reporting software, such as
Crystal
Reports.
Any comments, suggestions, warnings, etc. would be welcomed!
Many thanks,
Judy
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** You are subscribed to [EMAIL PROTECTED]
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** You are subscribed to [EMAIL PROTECTED]
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
