IBM Says It’s Time to Replace Query/400. So, What Are Your Options?

License Terms

DB2 Web Query V2.2 became generally available to customers licensed for IBM i 7.3 on April 15, 2016. IBM sells V2.2 of DB2 Web Query in two editions: Express and Standard. 

DB2 Web Query V2.2 Express edition licenses for $2,800US per core. DB2 Web Query V2.2 Standard edition licenses for $15,795US per core. Core pricing is a new concept IBM introduced in V2.1. In addition to licensing named users, a company who wants to make more than a single processor available to process DB2 Web Query jobs must purchase a license for each processor. Additional named users (query developers) in the Express and Standard editions cost $400US 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. IBM says the feature previously known as “Run-Time Enablement” in V1.2 is included in the Standard edition. However, customers with users who need only run queries and share the same authority must be organized into run only groups for $1,000US per group in the Standard edition. You must license a sufficient number of named users to support your total number of query developers and groups of run-time users. Run-time grouping of users is not available in the Express Edition.

Customers requiring the Oracle JD Edwards database adapter feature must license the V2.2 Standard edition and then add this adapter at a cost of $2,500US. The Oracle JD Edwards database adapter is not available for the DB2 Web Query Express edition.

Query/400 is not available as a stand-alone product, and customers who wish to continue using Query/400 for development must license at least the Express edition of DB2 Web Query. Query/400 run-time processing, however, is provided by the IBM i operating system, so customers ready to stop using Query/400 and migrate to a new solution can still run their existing Query/400 queries even if they do not license DB2 Web Query Express or Standard.


Want to confirm these and other details?

We encourage you to read the DB2 Web Query Redbook.

Learn More About DB2 Web Query.

IBM® DB2® Web Query V1.1 End of Support.

Alternative Solutions Available from NGS.

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.

Request Literature

Discuss Your Needs

Considering IBM Db2 Web Query?

NGS Blog

Follow Us

Privacy Policy

3835 N. Freeway Blvd, Suite 200 Sacramento, CA USA 95834
Office: (916) 920.2200 Sales: (800) 824.1220 Support: (800) 257.2442 Fax: (916) 920.1380

We Use Cookies

Site Map

Copyright & Copy; New Generation Software, Inc. All rights reserved.