Re: BI / Reporting tools -- MIDRANGE-L

Hi Kathy,

Thanks for responding. This info is good to know. I can check the final quote and if it's still an issue I'll refer him to your post.

-mark

On 4/18/2016 9:52 AM, Kathryn Steinbrink wrote:

Hi Mark,

It would be best to look at your config/quote to understand that. Is it
possible to send that to QU2@xxxxxxxxxx? The cost for SW Maintenance one
core of Express Edition (what you got at no charge if you upgraded from
previous versions or Query/400) is less than $900 annually. So if your
quote was for more than that, then either your business partner configured
multiple cores (probably erroneously) or upgraded you into Standard
Edition. Where we have seen misquotes is when whomever is doing the
config perhaps doesn't understand that CORE based pricing is also
subcapacity pricing - in other words, an assumption is made that if you
have 4 cores on your system you need 4 cores of DB2 Web Query, and this is
simply not the case. You can license to a core. But this is speculation
until we see your config to tell you exactly what happened.

Thank you.

Regards,
Kathy Steinbrink

From: mlazarus<mlazarus@xxxxxxxx>
To: Midrange Systems Technical Discussion<midrange-l@xxxxxxxxxxxx>
Date: 04/17/2016 10:02 AM
Subject: Re: BI / Reporting tools
Sent by: "MIDRANGE-L"<midrange-l-bounces@xxxxxxxxxxxx>

Kathy,

I recently got a quote for a new (replacement) system. It included a
"free"copy of Web Query. The yearly maintenance costs seems to be
disproportionately high, as compared to other software products. Can
you comment on that?

-mark

On 4/15/2016 11:13 PM, Kathryn Steinbrink wrote:

Your comments here are a bit misleading.

a) DDS defined files are still relational files. Its very possible that
you don't have things like referential integrity (relationships and
constraints) defined in "legacy" databases, but that implies the tool

(or

preferably in meta data) you build those relationships. If you do it in
Meta data, every report can leverage that without having to understand

the

relationships at the report authoring level. That's the beauty of a true
Business Intelligence tool with a meta data layer like DB2 Web Query. It
is not a difficult process to set up join definitions over your data -

as

you are probably having to do this in every report today anyway (and if
you do it in meta data, you do it ONCE, not in every report).

b) Why do you say its too expensive? IBM has made at least 1 core

licenses

(sometimes more than 1 core) of DB2 Web Query Express Edition available

to

EVERY customer who owns Query/400 (which is just about EVERY customer)

AT

NO CHARGE. Yes, this is a license with minimal users, but all the web
based report authoring capabilities, security center, all the output

types

(PDF, Excel, Auto Drill down, etc.) are included in that Express

Edition.

I don't know where you're getting your information but I would encourage
Jamal to download the DB2 Web Query redbook from IBM's wiki
http://ibm.co/db2wqwiki to get a feel for the product.

Regards,
Kathy Steinbrink