IBM DB2 Web Query – Editions, License Terms, and Features
The current release, V2.2.1, of IBM DB2 Web Query, became available to customers running IBM i 7.3 on December 8, 2017. The software is offered in two editions: Express and Standard. The Express edition is an entry-level packaging of the software. The Standard edition is an upgrade from Express. Commonly requested features (see below for details) may require the more costly Standard edition.
DB2 Web Query Express:
- Licenses for $2,800US per core.
- Includes two named users per core.
- Run-time groups are not available for the Express edition.
- The Oracle JD Edwards database adapter is not available for the Express edition.
- The Express edition does not support job scheduling, query execution from CL programs, or integration into business application interfaces.
DB2 Web Query Standard:
- Licenses for $14,000US per core
- Includes two named users per core
- Includes two run-time group licenses per core
- The Oracle JD Edwards database adapter is only available for the Standard edition.
- The Standard edition is required to support report distribution, job scheduling, and integration into business applications.
- Customers pay $400US for each additional named user.
- Customers with more than one core may downgrade their license to fewer cores and combine named users on their remaining cores.
- Additional run-time groups cost $1,000US each.
- The DB2 Web Query Developer Workbench, a Windows client module needed for more advanced report development, can be licensed for the Express or Standard edition by PC for $995US.
- Customers requiring the Oracle JD Edwards database adapter feature must license the V2.2.1 Standard edition and then add this adapter for $2,500US.
Given the numerous variables – cores, users, run-time groups, and modules – you may be asking what DB2 Web Query Express or Standard will cost your company.
Let's say you're a mid-size IBM i customer on a P10 model with 20 users who run queries, automate some queries by using a job scheduling utility, and are interested in integrating DB2 Web Query into your business application software. You would need to license the Standard edition, plus potentially a few Developer Workbench licenses and run-time groups. This configuration of users and features could cost approximately $25,000US, not including IBM SWMA and lab services. Adding the ability to leverage the processing power of a second core would add more than $10,000US to that total.
A smaller customer on a P5 model with just a few query developers and 10 users who occasionally run queries might spend approximately $7,500US to $10,000US for software and SWMA, and more if IBM lab services are required.
The query, reporting, and analytics software market is very competitive. Given the examples above or even if your cost may be moderately lower, you owe it to your organization to look at alternatives and ensure you're getting the best solution and value.
If you wish to continue developing Query/400 queries without licensing DB2 Web Query, you must order the renamed solution, Query for i (5770-QU1). This stand-alone option became available on January 8, 2019. Please note that we believe Query/400 run-time processing remains an integrated feature of the IBM i operating system, so customers ready to stop developing in Query/400 may migrate to a new solution but still run their existing Query/400 queries without licensing any IBM product. Please speak to your IBM Business Partner for more information.
Legal Notice: NGS believes all of the above information is accurate at the time of publication. However, IBM software products and marketing policies are subject to change at any time, without notice. Speak to your IBM or IBM Business Partner representative for current product, pricing, and support information. We welcome your comments.