Getting Started with DB2 Web Query for i

An IBM Redbooks publication


The DB2® Web Query for i product is a Web-based query and report writing product that offers enhanced capabilities over the IBM® Query for iSeries® product (also commonly known as Query/400). IBM DB2 Web Query for i includes Query for iSeries technology to assist customers in their transition to DB2 Web Query. It offers a more modernized, Java™-based solution for a more robust, extensible, and productive reporting solution. DB2 Web Query provides three main components: Report Assistant, Graph Assistant, and Power Painter with the base product. Using these tools, customers can modernize existing Query for iSeries reports while providing a foundation for building more complex business intelligence applications, such as online analytical processing (OLAP), data mining, dash boarding, or data warehouse implementations.

DB2 Web Query provides capabilities to query or build reports against data that is stored in DB2 call-level interface (CLI) databases through the latest browser-based user interface technologies. It enables you to build new reports with ease through the Power Painter or Report Assistant and Graph Assistant components. It simplifies the management of reports by allowing you to leverage parameterized reporting. It delivers data to users in many different formats, including spreadsheets, PDF, HTML, or through browser support of the Java-based thin client interface.

DB2 Web Query offers features to import Query/400 definitions and enhance their look and functionality with Power Painter or Graph Assistant. It enables you to add OLAP-like slicing and dicing to the reports or to view reports in disconnected mode for users on the go. It provides an interface to all data in IBM i5/OS® through either DB2 or Open Query File native adapters that automatically identify the files to be accessed and import the metadata into DB2 Web Query.

This IBM Redbooks® publication provides a broad understanding of the new DB2 Web Query product. It entails a group of self-explanatory tutorials to help you get up to speed quickly. Overall, this book is designed for IT users. You can use Part 2, "Tutorials for DB2 Web Query" on page 89, and Part 3, "Tutorials for DB2 Web Query optional features" on page 231, as stand-alone tutorials for anyone who is developing their own queries. Much of Chapter 8, "Active Reports" on page 233, is appropriate for those who work disconnected from the System i® environment. In addition, you can use much of Chapter 10, "Online analytical processing" on page 261, if you will simply be running OLAP-enabled reports.

For additional resources on DB2 Web Query for i:
DB2 Web Query InfoAssist Supplemental Tutorial
DB2 Web Query Documentation
DB2 Web Query Forum

Table of contents

Part 1. Background, installation, and setup
Chapter 1. Product architecture and overview
Chapter 2. Installation and server operations
Chapter 3. DB2 Web Query fundamentals
Part 2. Tutorials for DB2 Web Query
Chapter 4. Getting started with the tutorials
Chapter 5. Report Assistant
Chapter 6. Graph Assistant
Chapter 7. Power Painter
Part 3. Tutorials for DB2 Web Query optional features
Chapter 8. Active Reports
Chapter 9. Developer Workbench
Chapter 10. Online analytical processing
Chapter 11. HTML Composer
Chapter 12. Additional features of Developer Workbench
Chapter 13. DB2 Web Query Spreadsheet Client
Chapter 14. Adapter for Microsoft SQL Server
Part 4. Companion products
Chapter 15. Report Broker
Chapter 16. Software Development Kit
Part 5. Miscellaneous and additional topics
Chapter 17. Using DB2 Web Query to run existing Query/400 reports
Chapter 18. Performance considerations
Chapter 19. Frequently asked questions
Appendix A. Metadata in the integrated file system
Appendix B. Date and time functionality
Appendix C. Processing differences between the define and compute fields
Appendix D. Change Management considerations
Appendix E. Additional material


Publish Date
03 February 2010

(based on 4 reviews)




IBM Form Number

Number of pages