IBM Db2 Web Query for i extends data analytics and reporting with version 2.3.0

IBM United States Software Announcement 220-389
October 6, 2020

Table of contents
OverviewOverviewPublicationsPublications
Key requirementsKey requirementsTechnical informationTechnical information
Planned availability datePlanned availability dateOrdering informationOrdering information
DescriptionDescriptionTerms and conditionsTerms and conditions
Program numberProgram numberPricesPrices


Back to topBack to top

Overview

Top rule

IBM® Db2® Web Query for i is the family of products that provides business intelligence and an analytics platform for companies using IBM i systems.

Db2 Web Query for i 2.3.0 further extends the products' powerful reporting and dashboarding solution with even more data analysis capabilities, such as automated insights, page designer, and data preparation enhancements.



Back to topBack to top

Key requirements

Top rule

  • IBM i 7.3, or later

For additional hardware, software, storage, and other key requirements, see the Planning considerations topic in IBM Knowledge Center.



Back to topBack to top

Planned availability date

Top rule

  • October 6, 2020, for 5733-WQR upgrade feature codes and 5733-NKY supply feature codes
  • December 18, 2020, for 5733-WQX supply feature codes



Back to topBack to top

Description

Top rule

Db2 Web Query for i 2.3.0 continues the evolution of this family of products that provide the business intelligence and analytics platform for companies using IBM Power® Systems with IBM i. From green screen query modernization to end-to-end data warehouse infrastructure, Db2 Web Query for i is the foundation for analytics for companies using IBM i systems and databases.

Db2 Web Query for i 2.3.0 offers an enhanced user interface and additional analytical and data preparation capabilities. Clients can:

  • Gain more valuable insights into data with the Automatic Insights function made simple for the business analyst
  • Simplify building of charts and dashboards through the new page designer
  • Utilize EZ-Report to quickly build a report, and synonym over a file or an SQL statement
  • Simplify the data gathering and transformation process for one-time data extracts through new data preparation facilities

Current Db2 Web Query for i clients with active Software Maintenance can upgrade to version 2.3.0.

Db2 Web Query for i 2.3.0 supports IBM i 7.3, and later, and is available for all Db2 Web Query for i products, including:

  • Express® Edition
  • Scheduler Edition
  • RunTime User Edition
  • Standard Edition
  • DataMigrator ETL Extension


Back to topBack to top

Program number

Top rule

Program number VRM Program name
5733-WQX 2.3.0 IBM Db2 Web Query for i
5733-WQR 2.2.1 IBM Db2 Web Query for i Runtime Edition
5733-NKY 5.2.0 Remove Keys/ePoEs for Transferred Software


Note: The Program number 5733-NKY is associated with Software Announcement 220-306, dated June 23, 2020.

Program number Maintenance 1-year program number Maintenance 3-year program number Maintenance 3-month program number Maintenance after License program number
5733-WQR 5771-WQR 5773-WQR 5774-WQR 5771-WRA


Back to topBack to top

Offering Information

Top rule

Product information is available on the IBM Offering Information website.



Back to topBack to top

Publications

Top rule

None



Back to topBack to top

Services

Top rule

Software Services

IBM Software Services has the breadth, depth, and reach to manage your services needs. You can leverage the deep technical skills of the lab-based software services team and the business consulting, project management, and infrastructure expertise of the IBM Global Services team. Also, IBM extends the reach of IBM Software Services through IBM Business Partners to provide an extensive portfolio of capabilities. IBM provides the global reach, intellectual capital, industry insight, and technology leadership to support a wide range of critical business needs.

To learn more about IBM Software Services, contact your Lab Services Sales or Delivery Leader.



Back to topBack to top

Technical information

Top rule

Specified operating environment

Software requirements

IBM i 7.3, or later

IBM Support

IBM Support is your gateway to technical support tools and resources that are designed to help you save time and simplify support. IBM Support can help you find answers to questions, download fixes, troubleshoot, submit and track problem cases, and build skills. Learn and stay informed about the transformation of IBM Support, including new tools, new processes, and new capabilities, by going to the IBM Support Insider.

Planning information

Packaging

This offering is delivered through the internet. There is no physical media.



Back to topBack to top

Ordering information

Top rule

Consult your IBM representative.


IBM Configurator for e-business (e-config)


New feature numbers

Program number Feature description Supply feature number
5733-WQX Web Query Runtime 2.3.0 5847
5733-WQX Web Query Sched 2.3.0 5837
5733-WQX Web Query Standard 2.3.0 5848
5733-WQX Web Query Express 2.3.0 5838
5733-WQX Web Query DataMigrator 2.3.0 5858

IBM Db2 Web Query for i Runtime Edition (5733-WQR)

Program number Feature description No charge feature number
5733-WQR Upg RT Enblmt Grp User 0022

Program number Feature description Supply feature number
5733-NKY 5733-WQB Scheduler Edition 2869
5733-NKY 5733-WQR Runtime Edition 2870


Note: The Program number 5733-NKY is associated with announcement 220-306, dated June 23, 2020.

There is no new ordering information in this release.

Charge metric

The charge metrics for this licensed product can be found in the following License Information document:

Program identifier License Information document title License Information document number
5733-WQX IBM Db2 Web Query for i L-LHIH-BS7MFJ

Select your language of choice and scroll down to the Charge Metrics section. Follow-on releases, if any, may have updated terms. See the License Information documents website for more information.



Back to topBack to top

Terms and conditions

Top rule

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage® Agreement, and the IBM Agreement for Acquisition of Software Maintenance.

Licensing

IBM International Program License Agreement including the License Information document and Proof of Entitlement (PoE) govern your use of the program. PoEs are required for all authorized use.

Software Maintenance

The IBM Agreement for Acquisition of Software Maintenance (Z125-6011) applies for Subscription and Support (also referred to as Software Maintenance) and does not require client signatures.

Licenses under the IBM International Program License Agreement (IPLA) provide for support with ongoing access to releases and versions of the program. IBM includes one year of Software Subscription and Support with the initial license acquisition of each program acquired. The initial period of Software Subscription and Support can be extended by the purchase of a renewal option, if available. Two charges apply: a one-time license charge for use of the program and an annual renewable charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours), as well as access to updates, releases, and versions of the program as long as support is in effect.

License Information number

The following License Information document applies to the offering in this announcement:

Program identifier License Information document title License Information document number
5733-WQX IBM Db2 Web Query for i L-LHIH-BS7MFJ

Follow-on releases, if any, may have updated terms. See the License Information documents website for more information.

Limited warranty applies

Yes

Limited warranty

IBM warrants that when the program is used in the specified operating environment, it will conform to its specifications. The warranty applies only to the unmodified portion of the program. IBM does not warrant uninterrupted or error-free operation of the program or that IBM will correct all program defects. You are responsible for the results obtained from the use of the program.

IBM provides you with access to IBM databases containing information on known program defects, defect corrections, restrictions, and bypasses at no additional charge. For further information, see the IBM Support Guide.

IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Money-back guarantee

If for any reason you are dissatisfied with the program and you are the original licensee, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the refund.

For clarification, note that for programs acquired under any of IBM's On/Off Capacity on Demand (On/Off CoD) software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.

Volume orders (IVO)

Yes. Contact your IBM representative.

Passport Advantage applies

No

Software Subscription and Support applies

For operating system software, the revised IBM Operational Support Services - SoftwareXcel offering will provide support for those operating systems and associated products that are not available with the Software Subscription and Support (Software Maintenance) offering.

This will ensure total support coverage for your enterprise needs, including IBM and selected non-IBM products. For complete lists of products supported under both the current and revised offering, go to the Supported product list website.

Variable charges apply

No

Educational allowance available

Yes. A 15% education allowance applies to qualified education institution clients.



Back to topBack to top

Statement of good security practices

Top rule

IT system security involves protecting systems and information through intrusion prevention, detection, and response to improper access from within and outside your enterprise. Improper access can result in information being altered, destroyed, or misappropriated or can result in misuse of your systems to attack others. Without a comprehensive approach to security, no IT system or product should be considered completely secure and no single product or security measure can be completely effective in preventing improper access. IBM systems and products are designed to be part of a regulatory compliant, comprehensive security approach, which will necessarily involve additional operational procedures, and may require other systems, products, or services to be most effective.

Important: IBM does not warrant that any systems, products, or services are immune from, or will make your enterprise immune from, the malicious or illegal conduct of any party.



Back to topBack to top

Prices

Top rule

For additional information and current prices, contact your local IBM representative or IBM Business Partner.

IBM Global Financing

IBM Global Financing offers competitive financing to credit-qualified clients to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, from both IBM and other manufacturers or vendors. Offerings (for all client segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or go to the IBM Global Financing website for more information.

IBM Global Financing offerings are provided through IBM Credit LLC in the United States, and other IBM subsidiaries and divisions worldwide to qualified commercial and government clients. Rates are based on a client's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.

Trademarks

IBM, Db2, Power, Passport Advantage and Express are registered trademarks of IBM Corporation in the United States, other countries, or both.

Other company, product, and service names may be trademarks or service marks of others.

Terms of use

IBM products and services which are announced and available in your country can be ordered under the applicable standard agreements, terms, conditions, and prices in effect at the time. IBM reserves the right to modify or withdraw this announcement at any time without notice. This announcement is provided for your information only. Additional terms of use are located at

Terms of use

For the most current information regarding IBM products, consult your IBM representative or reseller, or go to the IBM worldwide contacts page

IBM United States