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

IBM Europe Software Announcement ZP22-0374
October 11, 2022

Table of contents
OverviewOverviewTechnical informationTechnical information
Key requirementsKey requirementsOrdering informationOrdering information
Planned availability datePlanned availability dateTerms and conditionsTerms and conditions
DescriptionDescriptionPricesPrices
Program numberProgram numberRegional availabilityRegional availability
PublicationsPublications


Back to topBack to top

Overview

Top rule

The IBM® Db2® Web Query for i family of products provides business intelligence and an analytics platform for companies using IBM i systems. Db2 Web Query for i 2.4.0 further extends this powerful reporting and dashboarding solution with even more data analysis capabilities, including customized portal interfaces, enhancements to the new Designer dashboard and visualization builder, and more.



Back to topBack to top

Key requirements

Top rule

  • IBM i 7.4, or later

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



Back to topBack to top

Planned availability date

Top rule

December 16, 2022

Availability within a country is subject to local legal requirements.



Back to topBack to top

Description

Top rule

Db2 Web Query for i 2.4.0 continues the evolution of the Web Query family of IBM i analytics products. From green screen query modernization, business intelligence reporting to powerful dashboard visualizations, Db2 Web Query for i is the foundation for analytics for companies using IBM i systems and databases.

Db2 Web Query also offers infrastructure components to simplify data consolidation, transformation, replication, and integration with cloud services.

The Db2 Web Query for i 2.4.0 Standard Edition offers the ability to create customized portals, or home pages, for different departments or user communities within your enterprise or for your customers. Simplify navigation to reports and dashboards that any one group uses most often.

Db2 Web Query's DataMigrator ETL component in version 2.4.0 can be used to create an analytics infrastructure to isolate query workloads from production, create a data warehouse, or manage streaming Db2 data into cloud services.

Other 2.4.0 enhancements available across the product line include a new hub-like home page and improvements to the new dashboard/visualization builder called Designer, which was introduced in version 2.3.0. EZ-Report is enhanced to enable report and metadata developers to automate creation of metadata synonyms and reports over tables and files or an SQL statement.

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

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

  • Express, Scheduler, RunTime User, and Standard Editions
  • DataMigrator ETL Extension


Back to topBack to top

Reference information

Top rule

For additional information about Db2 Web Query for i, see Software Announcement ZP20-0481, dated October 6, 2020.



Back to topBack to top

Program number

Top rule

Program number VRM Program name
5733-WQX 2.4.0 IBM Db2 Web Query for i


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

IBM Consulting™

As transformation continues across every industry, businesses need a single partner to map their enterprise-wide business strategy and technology infrastructure. IBM Consulting is the business partner to help accelerate change across an organization. IBM specialists can help businesses succeed through finding collaborative ways of working that forge connections across people, technologies, and partner ecosystems. IBM Consulting brings together the business expertise and an ecosystem of technologies that help solve some of the biggest problems faced by organizations. With methods that get results faster, an integrated approach that is grounded in an open and flexible hybrid cloud architecture, and incorporating technology from IBM Research® and IBM Watson® AI, IBM Consulting enables businesses to lead change with confidence and deliver continuous improvement across a business and its bottom line.

For additional information, see the IBM Consulting website.

IBM Technology Support Services (TSS)

TSS helps organizations plan, deploy, support, operate and refresh the foundation for their hybrid cloud and enterprise IT data centers. Deep expertise in IBM Systems, open source and third-party vendors, streamlined processes and advanced technologies such as AI, enable organizations to protect their infrastructure investment and consistently maintain high availability for mission-critical workloads across the product lifecycle.

IBM Technology Services, formerly known as IBM Systems Lab Services, is part of TSS. Technology Services offers a wide range of infrastructure services for IBM Power® servers, IBM Storage systems, IBM zSystems, IBM LinuxONE, Red Hat® and open source software. Technology Services has a global presence and can deploy consultants online or onsite. Consultants have deep technical expertise, valuable tools, and successful methodologies. Technology Services is designed to help organizations solve business challenges, gain new skills, and apply best practices.

For more information about IBM's infrastructure support and services, see the Technology lifecycle services for your hybrid cloud infrastructure web page.

IBM Expert Labs

Expert Labs can help clients accelerate their projects and optimize value by leveraging their deep technical skills and knowledge. With more than 20 years of industry experience, these specialists know how to overcome the biggest challenges to deliver business results that can have an immediate impact.

Expert Labs' deep alignment with IBM product development allows for a strategic advantage as they are often the first in line to get access to new products, features, and early visibility into roadmaps. This connection with the development enables them to deliver First of a Kind implementations to address unique needs or expand a client's business with a flexible approach that works best for their organization.

For additional information, see the IBM Expert Labs website.

IBM Security® Expert Labs

With extensive consultative expertise on IBM Security software solutions, Security Expert Labs helps clients and partners modernize the security of their applications, data, and workforce. With an extensive portfolio of consulting and learning services, Security Expert Labs provides project-based and premier support service subscriptions.

These services can help clients deploy and integrate IBM Security software, extend their team resources, and help guide and accelerate successful hybrid cloud solutions, including critical strategies such as zero trust. Remote and on-premises software deployment assistance is available for IBM Cloud Pak® for Security, IBM Security QRadar®/QRoC, IBM Security QRadar SOAR, IBM Security Verify, IBM Security Guardium®, and IBM Security MaaS360®.

For more information, contact Security Expert Labs at sel@us.ibm.com.

For additional information, see the IBM Security Expert Labs website.



Back to topBack to top

Technical information

Top rule

Specified operating environment

Software requirements

IBM i 7.4, or later, is required.

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.

Additional IBM support

IBM Client Engineering for Systems

Client Engineering for Systems is a framework for accelerating digital transformation. It helps you generate innovative ideas and equips you with the practices, technologies, and expertise to turn those ideas into business value in weeks. When you work with Client Engineering for Systems, you bring pain points into focus. You empower your team to take manageable risks, adopt leading technologies, speed up solution development, and measure the value of everything you do. Client Engineering for Systems has experts and services to address a broad array of use cases, including capabilities for business transformation, hybrid cloud, analytics and AI, infrastructure systems, security, and more. Contact Client Engineering for Systems at sysgarage@ibm.com.

Planning information

Packaging

Packaging information

This program, when downloaded from a website, contains the applicable IBM license agreement and License Information, if appropriate, which will be presented for acceptance at the time of installation of the program. For future reference, the license and License Information will be stored in a directory such as LICENSE.TXT.



Back to topBack to top

Ordering information

Top rule

Consult your IBM representative or IBM Business Partner.


IBM Configurator for e-business (e-config)


New feature numbers

IBM Db2 Web Query for i 2.4.0 introduces the following feature numbers:

Program number Feature description Supply Feature number
5733-WQX DB2® WEB QUERY SCHEDULER V2.4 5857
5733-WQX DB2 WEB QUERY EXPRESS V2.4 5868
5733-WQX DB2 WEB QUERY RUNTIME V2.4 5867
5733-WQX DB2 WEB QUERY STANDARD V2.4 5878
5733-WQX DATAMIGRATOR FOR i V2.4 5888

Charge metric

Charge metric information can be found in the corresponding License Information document.

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

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

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

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

Usage restrictions

Yes

For usage restrictions, see the License Information documents listed in this Terms and conditions section.

Software Subscription and Support applies

For operating system software, the revised IBM Technology Support Services - Support Line for IBM Z® offering provides usage and how-to support for those operating systems and associated products that are not available with the Software Subscription and Support offering.

This can 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, see the Supported Product list website.

System i Software Maintenance applies

No

Variable charges apply

Yes

Educational allowance available

Yes. When ordering through the program number process, a 15% education allowance applies to qualified education institution clients.

Education Software Allowance Program applies when ordering through the program number process.

ESAP available

Yes, to qualified 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 all local charges, contact your IBM representative.

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 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.



Back to topBack to top

Regional availability

Top rule

Europe: Aland Islands, Albania, Andorra, Armenia, Austria, Azerbaijan, Belarus, Belgium, Bosnia and Herzegovina, Bouvet Island, British Indian Ocean Territory, Bulgaria, Union of the Comoros, Croatia, Cyprus, Czech Republic, Denmark, Estonia, Falkland Islands (Malvinas), Faroe Islands, Finland, France, French Guiana, French Polynesia, French Southern Territories, Georgia, Germany, Gibraltar, Greece, Greenland, Guadeloupe, Guernsey, Holy See (Vatican City State), Hungary, Iceland, Ireland, Isle of Man, Israel, Italy, Jersey, Kazakhstan, Kyrgyzstan, Latvia, Liechtenstein, Lithuania, Luxembourg, Malta, Martinique, Mayotte, Republic of Moldova, Monaco, Montenegro, Netherlands, New Caledonia, Republic of North Macedonia, Norway, Pitcairn, Poland, Portugal, Reunion, Romania, Saint Barthelemy, Saint Helena Ascension and Tristan da Cunha, Saint Martin, Saint Pierre and Miquelon, San Marino, Serbia, Slovakia, Slovenia, South Georgia and the South Sandwich Islands, Spain, Svalbard and Jan Mayen, Sweden, Switzerland, Tajikistan, Turkmenistan, Ukraine, United Kingdom, Uzbekistan, Vanuatu, and Wallis and Futuna

Middle East and Africa: Afghanistan, Algeria, Angola, Bahrain, Benin, Botswana, Burkina Faso, Burundi, Republic of Cabo Verde, Cameroon, Central African Republic, Chad, Democratic Republic of the Congo, Republic of the Congo, Republic of Côte d'Ivoire, Djibouti, Egypt, Equatorial Guinea, Eritrea, Kingdom of Eswatini, Ethiopia, Gabon, Gambia, Ghana, Guinea, Guinea-Bissau, Iraq, Jordan, Kenya, Kuwait, Lebanon, Lesotho, Liberia, Libya, Madagascar, Malawi, Mali, Mauritania, Mauritius, Morocco, Mozambique, Namibia, Niger, Nigeria, Oman, Pakistan, State of Palestine, Qatar, Rwanda, Sao Tome and Principe, Saudi Arabia, Senegal, Seychelles, Sierra Leone, Somalia, South Africa, South Sudan, Sudan, United Republic of Tanzania, Togo, Tunisia, Turkey, Uganda, United Arab Emirates, Western Sahara, Yemen, Zambia, and Zimbabwe

Trademarks

IBM Consulting is a trademark of IBM Corporation in the United States, other countries, or both.

IBM, Db2, Power, IBM Z, Passport Advantage, IBM Research, IBM Watson, IBM Security, IBM Cloud Pak, QRadar, Guardium, MaaS360 and DB2 are registered trademarks of IBM Corporation in the United States, other countries, or both.

Red Hat is a registered trademark of Red Hat Inc. in the U.S. and other countries.

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. Reference to other products in this announcement does not necessarily imply those products are announced, or intend to be announced, in your country. 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 Directory of worldwide contacts