OD05: DB2 Web Query for Advanced Users, Developers, and Administrators
DURATION: 3 days
SCHEDULED DATES: TBD – Contact Us for more Information
PURPOSE
This course is designed to provide users, developers, and administrators an in-depth look at some of the more advanced features of DB2 Web Query. This course will take users through various conversion techniques to move existing reporting into DB2 Web Query. Besides conversion, the use of advanced techniques including dashboards and automated report distribution will be covered.
Students will review the integration of Microsoft Excel and SQL Server into DB2 Web Query. Finally, students will have a chance to review and correct performance related issues in DB2 Web Query.
AUDIENCE
This course is designed for advanced developers that are tasked to utilize DB2 Web Query for reporting needs.
While some administration tasks are discussed, the focus of the course is report development.
PREREQUISITES
OD04 – DB2 Web Query: Getting Started
Students should have an understanding of IBM i operating system and DB2 on i concepts.
Students should have basic DB2 Web Query InfoAssistant and DB2 Web Query Developer Workbench skills.
Completing chapters 1 – 15 of the DB2 Web Query for i Version 2.1 Implementation Guide Redbooks would provide this foundation.
OBJECTIVES
After completing this course, you should be able to:
• Convert existing Query/400 queries to DB2 Web Query
• Understand the installation and maintenance process
• Use the advanced options of DB2 Web Query
• Understand the companion products for DB2 Web Query
• Analyze performance issues from DB2 Web Query
• Apply advanced techniques to report generation
