IBM DB2 Web Query for i Version 2.1 Implementation Guide

An IBM Redbooks publication

Published 27 January 2014

cover image

ISBN-10: 0738437964
ISBN-13: 9780738437965
IBM Form #: SG24-8063-00
(888 pages)

Authors: Hernando Bedoya, Robert Andrews, Theo Bar, Gene Cobb, Rick Flagler, Kei Fujii, Hector Gongora, Doug Mack, Simona Pacchiarini, Septia Sukariningrum, Yu Yu Wang, Yu Zhe Zhi, Yu Zhu


Business Intelligence (BI) is a broad term relating to applications designed to analyze data for purposes of understanding and acting on the key metrics that drive profitability in an enterprise. Key to analyzing that data is providing fast, easy access to it while delivering it in formats or tools that best fit the needs of the end user.

At the core of any business intelligence solution are end user query and reporting tools that provide intuitive access to data supporting a spectrum of end users from executives to "power users," from spreadsheet aficionados to the external Internet consumer.

IBM® DB2 Web Query for i offers a set of modernized tools for a more robust, extensible, and productive reporting solution than the popular Query for System i tool (also known as Query/400).

IBM DB2 Web Query for i preserves investments in the reports developed with Query/400 by offering a choice of importing definitions into the new technology or continuing to run existing Query/400 reports as-is. But it also offers significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology.

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 161, as stand-alone tutorials for anyone who is developing their own queries.

Table of contents

Part 1. Background, installation, and setup
Chapter 1. Product overview and architecture
Chapter 2. Installation and server operations
Chapter 3. Defining metadata
Chapter 4. Security Center
Part 2. Tutorials for DB2 Web Query
Chapter 5. Getting started with the tutorials
Chapter 6. Security Center: Setting up users
Chapter 7. Creating and editing metadata: Century database
Chapter 8. Assignment #1: Summary reports
Chapter 9. Assignment #2: Implementing various date functions in reports
Chapter 10. Assignment #3: Implementing other report features and formats
Chapter 11. Assignment #4: Charting
Chapter 12. Assignment #5: Adding filters to reports and charts
Chapter 13. Assignment #6: Detail/print reports
Chapter 14. Assignment #7: Implementing OLAP
Chapter 15. Assignment #8: Building documents and dashboards
Chapter 16. Assignment #9: Exploring and comparing other dashboard options
Chapter 17. Assignment #10: Scheduling and distribution of reports
Chapter 18. Assignment #11: Going mobile
Chapter 19. Assignment #12: Stored procedures in action
Chapter 20. Assignment #13: Query/400 modernization
Chapter 21. Assignment #14: Creating JD Edwards reports
Chapter 22. The Century Challenge BI solution: Postmortem
Part 3. Miscellaneous topics
Chapter 23. Performance case study
Chapter 24. Migration considerations
Chapter 25. IBM i Business Intelligence solution
Chapter 26. Adapter for Microsoft SQL Server
Appendix A. Date and time functionality
Appendix B. DB2 Web Query system variables
Appendix C. Change management considerations
Appendix D. Configuring Developer Workbench

Follow IBM Redbooks

Follow IBM Redbooks