Hide Notes 

Slide 1: COMMON Webinar: DB2 Web Query Presented by Gene Cobb, IBM Wednesdays – February 3, 10, 17 and 24, 2010 12:00pm - 1:15pm CDT Are you Using Query/ 400 and want to modernize the reports generated? Are you looking to do more advanced reporting? Do you have lots of different reporting needs from different end users? IBM DB2 Web Query for i is IBM's strategic replacement for the Query/ 400 product and may be just the tool to solve your needs. Come to this workshop to get a jumpstart on this robust, extensible, and productive reporting solution. In this four part Webinar series, you will learn how to: 1. 2. 3. 4. 5. 6. 7. Use the administrative tools to set up your DB2 Web Query environment Create metadata and define all your joins in the metadata layer. Easily build new reports and graphs using DB2 Web Query development tools Import Query/ 400 queries into DB2 Web Query and "Web enable" the output. Create jaw dropping dashboards that will impress your management. Set up OLAP reports to analyze, drill down, and slice & dice data. Create Active Reports to access and analyze your data without requiring access to DB2 Web Query or even your IBM i system. 8. Implement techniques to secure your reports and data. 9. Use the advanced report development capabilities available in the Developer Workbench client. 10. Maximize Web Query performance Registration includes access to the four webcasts listed below, handouts for each webcast, and access to a collaborative website on iSociety for discussion and offline support. • • • • Session 1: "DB2 Web Query Overview and Demo" February 3, 2010 - 12:00 - 1:15pm Session 2: "DB2 Web Query: The Fundamentals" February 10, 2010 - 12:00 - 1:15pm Session 3: "Leveraging the Full Power of IBM DB2 Web Query for i" February 17, 2010 - 12:00 - 1:15pm Session 4: "IBM DB2 Web Query for i: The Things You Need to Know!" February 24, 2010 - 12:00 - 1:15pm About the Presenter – Gene Cobb: Gene Cobb is a DB2 for i technology specialist in the IBM Systems Software DB2 for i Development team. He joined IBM in 1988 and spent over 10 years as an application consultant in the IBM STG Lab Services group, formerly the Client Technology Center (CTC) in Rochester, Minnesota. His current responsibilities include the promotion, education, enablement, and technical support of IBM DB2 Web Query, the strategic query and reporting solution for the IBM i platform. He speaks and writes regularly about DB2 for i and DB2 Web Query topics, and was a co-author of the IBM Rebook “Getting Started with DB2 Web Query for System i.” He can be reached at cobbg@us.ibm.com.
Slide 2: Complete Session Abstracts Session 1: "DB2 Web Query Overview and Demo" IBM DB2 Web Query for i is IBM's strategic replacement for the Query/ 400 product. It is a robust, extensible, and productive reporting solution. Delve down into this more robust and extensible reporting solution, which leverages the latest reporting and graphing development tools available in DB2 for i. Are you interested in a query and reporting solution with any of these features: • Report output sent to a PDF file or Microsoft Excel? • Reports formatted as graphs and charts? • Ability to improve the look and functionality of your existing Query/ 400 reports and display the output to the web browser? • Implement an OLAP solution to analyze, drill down, and slice & dice your data? • Access your data and analytical tools without requiring access to DB2 Web Query or even your IBM i system? • A reporting tool that can populate new and existing Excel templates, dashboards, scorecards, and pivot tables? If so, attend this webinar to see a live demonstrations of these features and more! Session 2: "DB2 Web Query: The Fundamentals" If you have seen a demo DB2 Web Query and like what you've seen, you may be ready to order the product and give it a try. Before you install the product, there are some additional topics that you will want to have an understanding of. These topics will help you gain a better comprehension of the product and help make your implementation of DB2 Web Query a success. This session focuses on those topics which include: • DB2 Web Query architecture and installation • Understanding the licensing options available to you • Domains and metadata and how to set them up. • The WRKWEBQRY command to register users • Options to secure your environment • Understanding the available data adapters • Change Management • The RUNWEBQRY command - what is it and how can I use it? • Querying DB2 for i data on remote systems and partitions Session 3: "Leveraging the Full Power of IBM DB2 Web Query for i" Business Intelligence features such as metadata, OLAP, dashboards, and automated distribution are hot topics these days. In this session, learn how to use DB2 Web Query to leverage these technologies in your environment. This session will cover advanced DB2 Web Query features that extend the BASE product into a full blown Business Intelligence solution for the masses! Demonstrations of the HTML Composer, OLAP Dimension Builder, Advanced Synonym Editor, and Report Broker will be covered. Session 4: "IBM DB2 Web Query for i: The Things You Need to Know!" DB2 Web Query is IBM's strategic replacement for the Query/400 product, and offers a very robust and powerful alternative to its predecessor. To get the MOST out of DB2 Web Query there are several tips, techniques, and best practices that you should be aware of. When implemented, they can improve query performance and make the overall DB2 Web Query experience more enjoyable for developers and end users alike. In this session, you will learn about the most important techniques to help make your implementation a successful one!