IBM Db2 Web Query for i and IBM Query for i offer more flexible ordering
IBM United States Software Announcement 219-047January 8, 2019
ENUS219-047.PDF| Table of contents | ||||||||||||||||||||||||
| ||||||||||||||||||||||||
Back to top
Overview
IBM® is changing the ordering of IBM Db2® Web Query for i (5733-WQX) and IBM Query for i (5770-QU1), previously known as Query/400. Previously, Query for i was bundled with Db2 Web Query orders. Now Query for i is available to order separately and no longer bundled with Db2 Web Query. This gives you the flexibility to select the products you need.
Back to top
Key requirements
IBM i 7.1, or later.
Back to top
Planned availability date
January 8, 2019
Back to top
Description
In 2007, IBM announced and delivered a package of data analytics tools that included Query for i (5770-QU1, 5761-QU1, and 5722-QU1) and Db2 Web Query for i. Whether a client needed Db2 Web Query for i, or Query for i, or both, the products were included together in one order.
IBM will no longer deliver these data analytics tools together. Query for i will be separately ordered. The characteristics of Query for i as a separately ordered product are:
- There is no charge associated with Query for i when a new entitlement is ordered.
- There is a separate entitlement (electronic Proof of Entitlement or ePoE) created for Query for i.
- Software license keys continue to be required for Query for i.
- Query for i is still available under IBM i Group Software Maintenance (SWMA). See the "IBM i and Selected Products which are included with IBM i Group SWMA" table at the IBM Software Maintenance for IBM i website for details.
Order each product individually:
- For clients who need Query for i, specify 5770-QU1 on the order.
- For clients who need Db2 Web Query for i, specify 5733-WQE (Express Edition) or 5733-WQS (Standard Edition) on the order.
- For clients who need Db2 Web Query DataMigrator ETL, specify 5733-WQM on the order. Note that Data Migrator requires Db2 Web Query Express or Standard.
Query for i and Db2 Web Query for i are transferred individually from machine to machine or upgraded individually using either the IBM configurator for e-business (e-config) or the Entitled System Support (ESS) website. This applies to Query for i 5.4 and later and for all versions of Db2 Web Query (5733-QU2, 5733-WQE, and 5733-WQS).
Back to top
Program number
| Program number | VRM | Program name |
|---|---|---|
| 5770-QU1 | 7.x.x | IBM Query for i |
| 5733-WQX | 2.x.x | IBM Db2 Web Query for i |
| Program number | Maintenance 1-year PID number | Maintenance 3-year PID number |
|---|---|---|
| N/A | N/A | N/A |
Back to top
Offering Information
Product information is available on the IBM Offering Information website.
Back to top
Publications
None
Back to top
Services
Software Services
IBM Software Services has the breadth, depth, and reach to manage your services needs. You can leverage the deep technical skills of our lab-based, software services team and the business consulting, project management, and infrastructure expertise of our IBM Global Services team. Also, we extend our IBM Software Services reach through IBM Business Partners to provide an extensive portfolio of capabilities. Together, we provide 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 top
Technical information
Specified operating environment
Software requirements
IBM i 7.1, or later.
User Group requirements
A strong and passionate worldwide user community focuses on all aspects of i running on Power® servers. The community includes online groups and face-to-face community gatherings. The COMMON organization has branches around the world, including COMMON North America, iSUC in Japan, and COMMON Europe. In addition, there are many smaller local user groups located in various regions in North America and other areas of the world.
IBM continues to recognize key community leaders through the IBM Champions program. The current IBM i Champions have been recognized for their work in the betterment of user groups, social media, and the Academic Initiative. To learn about the IBM Champions program, see the IBM Champions website.
Planning information
Planning statements provide insight into IBM's current plans, directions, and intent, and are subject to change or withdrawal without notice. Any reliance on these planning statements is at the relying party's sole risk and will not create liability or obligation for IBM.
Packaging
This offering is delivered through the internet and as physical media.
Security, auditability, and control
These programs use the security and auditability features of the host hardware or software.
The client is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
Back to top
Ordering information
Consult your IBM representative.
| Program number | Feature description | OTC feature number |
|---|---|---|
| 5770-QU1 | P05 Upg from 5722-QU1 | 2081 |
| 5770-QU1 | P10 Upg from 5722-QU1 | 2082 |
| 5770-QU1 | P20 Upg from 5722-QU1 | 2083 |
| 5770-QU1 | P30 Upg from 5722-QU1 | 2084 |
| 5770-QU1 | P40 Upg from 5722-QU1 | 2085 |
| 5770-QU1 | P50 Upg from 5722-QU1 | 2086 |
| 5770-QU1 | P60 Upg from 5722-QU1 | 2087 |
| 5770-QU1 | P05 Upg from 5761-QU1 | 2088 |
| 5770-QU1 | P10 Upg from 5761-QU1 | 2089 |
| 5770-QU1 | P20 Upg from 5761-QU1 | 2090 |
| 5770-QU1 | P30 Upg from 5761-QU1 | 2091 |
| 5770-QU1 | P40 Upg from 5761-QU1 | 2092 |
| 5770-QU1 | P50 Upg from 5761-QU1 | 2093 |
| 5770-QU1 | P60 Upg from 5761-QU1 | 2094 |
| 5770-QU1 | P05 Upg from 5769-QU1 | 2095 |
| 5770-QU1 | P10 Upg from 5769-QU1 | 2096 |
| 5770-QU1 | P20 Upg from 5769-QU1 | 2097 |
| 5770-QU1 | P30 Upg from 5769-QU1 | 2098 |
| 5770-QU1 | P40 Upg from 5769-QU1 | 2099 |
| 5770-QU1 | P50 Upg from 5769-QU1 | 2100 |
| 5770-QU1 | P60 Upg from 5769-QU1 | 2101 |
| Program number | Feature description | Process option feature number |
|---|---|---|
| 5733-WQX | Registration per Data Migtr Auth User | 6345 |
| 5733-WQX | Registration Dev WB Exp User | 6346 |
| 5733-WQX | Registration Dev WB Std User | 6347 |
| 5733-WQX | Registration per Std Auth User | 6301 |
| 5733-WQX | Registration Dev WB Data Mgtr User | 6348 |
| 5733-WQX | Registration Decrease Exp Cores | 6349 |
| 5733-WQX | Registration per Exp Auth User | 6100 |
| 5733-WQX | Registration Decrease Exp Auth Users | 6665 |
| 5733-WQX | Registration Decrease Exp WB Users | 6670 |
The new Db2 Web Query for i (5733-WQX) 6xxx process options (also called registration feature codes) help you improve the management of Db2 Web Query entitlements. To learn the ordering steps necessary to use the new registration feature codes, see the "Db2 Web Query Registration Feature Codes" file in the "Reference Documentation" section at the IBM i License Topics website.
Charge metric
Not applicable.
Back to top
Terms and conditions
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.
This software license includes Software Subscription and Support (also referred to as Software Maintenance).
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 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
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 Software Support Handbook.
IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).
Program support
Subscription and Support includes telephone assistance, as well as access to updates, releases, and versions of the program as long as support is in effect. You will be notified of discontinuance of support with 12 months' notice.
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
See the License Information documents page on the IBM Software License Agreement website for more information.
Software Subscription and Support applies
Yes. All distributed software licenses include Software Subscription and Support (also referred to as Software Maintenance) for a period of 12 months from the date of acquisition, providing a streamlined way to acquire IBM software and assure technical support coverage for all licenses. Extending coverage for a total of three years from date of acquisition may be elected.
While your Software Subscription and Support is in effect, IBM provides you assistance for your routine, short duration installation and usage (how-to) questions, and code-related questions. IBM provides assistance by telephone and, if available, electronic access, only to your information systems (IS) technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. (This assistance is not available to your end users.) IBM provides Severity 1 assistance 24 hours a day, every day of the year. For additional details, go to the IBM Support Handbooks page.
Software Subscription and Support does not include assistance for the design and development of applications, your use of programs in other than their specified operating environment, or failures caused by products for which IBM is not responsible under this agreement.
IBM Operational Support Services - SoftwareXcel
Yes
System i Software Maintenance applies
Yes
Variable charges apply
No
Educational allowance available
Yes. A 15% education allowance applies to qualified education institution clients.
Back to top
Statement of good security practices
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 top
IBM Electronic Services
Electronic Service Agent™ and the IBM Electronic Support web portal are dedicated to providing fast, exceptional support to organizations that have IBM Systems. The IBM Electronic Service Agent tool is a no-additional-charge tool that proactively monitors and reports hardware events, such as system errors, performance issues, and inventory. The Electronic Service Agent tool can help you stay focused on your company's strategic business initiatives, save time, and spend less effort managing day-to-day IT maintenance issues. Servers enabled with this tool can be monitored remotely around the clock by IBM Support, all at no additional cost to you.
Now integrated into the base operating system of IBM i 7.2 and IBM i 7.3, Electronic Service Agent is designed to automatically and electronically report system failures and utilization issues to IBM, which can result in faster problem resolution and increased availability. System configuration and inventory information collected by the Electronic Service Agent tool also can be viewed on the secure Electronic Support web portal, and used to improve problem determination and resolution by you and the IBM support team. To access the tool main menu, simply type smitty esa_main, and select Configure Electronic Service Agent. In addition, ESA now includes a powerful web user interface, giving the administrator easy access to status, tool settings, problem information, and filters. For more information and documentation on how to configure and use Electronic Service Agent, go to the IBM Electronic Service Agent website.
The IBM Electronic Support portal is a single internet entry point that replaces the multiple entry points traditionally used to access IBM internet services and support. This portal enables you to gain easier access to IBM resources for assistance in resolving technical problems. The My Systems and Premium Search functions make it even easier for organizations that are Electronic Service Agent tool-enabled to track system inventory and find pertinent fixes.
Benefits
Increased uptime: The Electronic Service Agent™ tool is designed to enhance the Warranty or Maintenance Agreement by providing faster hardware error reporting and uploading system information to IBM Support. This can translate to less wasted time monitoring the symptoms, diagnosing the error, and manually calling IBM Support to open a problem record. Its 24 x 7 monitoring and reporting mean human intervention is not required to report errors.
Security: The Electronic Service Agent tool is designed to be secure in monitoring, reporting, and storing the data at IBM. The Electronic Service Agent tool is designed to securely transmit either through the internet (HTTPS or VPN) or modem to provide organizations a single point of exit from their site. Communication is one way. Activating Electronic Service Agent does not enable IBM to call into an organization's system.
For additional information, go to the IBM Electronic Service Agent website.
More accurate reporting: Because system information and error logs are automatically uploaded to the IBM Support Center in conjunction with the service request, you are not required to find and send system information, decreasing the risk of misreported or misdiagnosed errors. Once inside IBM, problem error data is run through a data knowledge management system and knowledge articles are appended to the problem record.
Customized support: Using the IBMid entered during activation, you can view system and support information in the My Systems and Premium Search sections of the IBM Electronic Support page.
My Systems provides valuable reports of installed hardware and software using information collected from the systems by Electronic Service Agent. Reports are available for any system associated with your IBMid. Premium Search combines the function of search and the value of Electronic Service Agent information, providing advanced search of the technical support knowledgebase. Using Premium Search and the Electronic Service Agent information that has been collected from your system, you are able to see search results that apply specifically to your systems.
For more information on how to utilize the power of IBM Electronic Services, contact your IBM Systems Services Representative, or go to the IBM Electronic Support website.
Back to top
Prices
For additional information and current prices, contact your local IBM representative.
Program name: IBM Query for i
Program number: 5770-QU1
| Program number | Feature description | OTC feature number |
|---|---|---|
| 5770-QU1 | P05 Upg from 5722-QU1 | 2081 |
| 5770-QU1 | P10 Upg from 5722-QU1 | 2082 |
| 5770-QU1 | P20 Upg from 5722-QU1 | 2083 |
| 5770-QU1 | P30 Upg from 5722-QU1 | 2084 |
| 5770-QU1 | P40 Upg from 5722-QU1 | 2085 |
| 5770-QU1 | P50 Upg from 5722-QU1 | 2086 |
| 5770-QU1 | P60 Upg from 5722-QU1 | 2087 |
| 5770-QU1 | P05 Upg from 5761-QU1 | 2088 |
| 5770-QU1 | P10 Upg from 5761-QU1 | 2089 |
| 5770-QU1 | P20 Upg from 5761-QU1 | 2090 |
| 5770-QU1 | P30 Upg from 5761-QU1 | 2091 |
| 5770-QU1 | P40 Upg from 5761-QU1 | 2092 |
| 5770-QU1 | P50 Upg from 5761-QU1 | 2093 |
| 5770-QU1 | P60 Upg from 5761-QU1 | 2094 |
| 5770-QU1 | P05 Upg from 5769-QU1 | 2095 |
| 5770-QU1 | P10 Upg from 5769-QU1 | 2096 |
| 5770-QU1 | P20 Upg from 5769-QU1 | 2097 |
| 5770-QU1 | P30 Upg from 5769-QU1 | 2098 |
| 5770-QU1 | P40 Upg from 5769-QU1 | 2099 |
| 5770-QU1 | P50 Upg from 5769-QU1 | 2100 |
| 5770-QU1 | P60 Upg from 5769-QU1 | 2101 |
Back to top
Order now
To order, contact the IBM Digital Sales Center, your local IBM representative, or your IBM Business Partner. To identify your local IBM representative or IBM Business Partner, call 800-IBM-4YOU (426-4968). For more information, contact the IBM Digital Sales Center.
Phone: 800-IBM-CALL (426-2255)
Fax: 800-2IBM-FAX (242-6329)
For IBM representative: askibm@ca.ibm.com
For IBM Business Partner: pwcs@us.ibm.com
IBM Digital Sales Offices
1177 S Belt Line Rd
Coppell, TX 75019-4642, US
The IBM Digital Sales Center, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.
Note: Shipments will begin after the planned availability date.
Trademarks
Electronic Service Agent is a trademark of IBM Corporation in the United States, other countries, or both.
IBM, Db2, Passport Advantage, System i and Power 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
For the most current information regarding IBM products, consult your IBM representative or reseller, or go to the IBM worldwide contacts page