The Following Is a List of Possible Topics and Speakers for Future Sessions

The following is a list of possible topics and speakers for future sessions. If you would come to see this topic and speaker, please put a check next to the topic.

___1) Building Web Sites: Introduction to HTML and Javascript – Melissa Anderson, IBM (award winning speaker)

Looking to get started with web sites or web programming? HTML is your first building block--it's the display language of the web. This session provides examples and tips for using HTML. You'll learn how to format text with HTML and how to design user input forms for web applications.

Client-side JavaScript is a scripting language that you can use to turn static HTML pages into dynamic, interactive web pages.
Not only can JavaScript jazz up your web pages by providing function that HTML can't, it can ease the burden on your server-side applications (such as CGI programs) by validating form input and adding dynamic function at the browser level.
In this session you will learn:
1. What JavaScript is and what it can do.
2. Why JavaScript is a powerful tool for web development.
3. How JavaScript is used in web pages (with code examples), including:
-- Form validation
-- Page redirection
-- Opening windows
-- Writing to the browser
-- Image swapping

___2)Effective Backup and Basic Availability Considerations and OS400 24x7: in Search of the Holy Grail - Al Barsa, Barsa Consulting Group, LLC (award winning speaker)

This session will discuss AS/ 400 considerations for quick backup and availability. The covered topics will range from backup, to journaling, SMAPP, access path journaling, and commitment control. This session, or the equivalent knowledge, is a prerequisite for the following session, Recovery and High Availability Solutions.

More and more large customers look to push their systems for 24x7 availability, yet OS/ 400 was never designed for 24x7. Come hear Al Barsa give you the alternatives for achieving 24x7. (You know that this is going to cost money.) The objective of this high level presentation is that you can go back to management, and justify a solution so that your system's performance is in line with their expectations.

___3)The Science & The Art of Query Optimization – Michael Cain, IBM (Award winning speaker)

What is the distinction between Science and Art, and how does it apply to query optimization? These two sessions will define query optimization and will introduce you to the building blocks and the strategies that help to define the science and art of query optimization for DB2 UDB for iSeries.

___4)Preparing to Get the Best DB2 Performance out of V5R2 & V5R3 – Tom McKinley, IBM (Award winning speaker)

There are significant DB2 enhancements in both V5R2 OS/ 400 and V5R3 i5/ OS. Are you prepared to get the most out them? In this session you will learn about strategies to take advantage of the new database engine and the critical success factors for good performance after upgrading to a new release.

___5) Introduction to iSeries Journaling and Journal Performance - Larry Youngren, IBM (award winning speaker)

Have you always wondered how journaling works and how best to employ this function? Would you like to hear where it's heading in the future? This session provides an introduction to iSeries journaling and its functions.
This provides a good introduction for those who want to attend more in-depth journal sessions later in the week which are part of the Focused Education Roadmap associated with journaling.
We'll introduce you to the objects, talk about Hot Site practices, show you how Journaling can affect your back-up strategy, show you how it can be a useful debugging aid, illustrate the role it plays as "better plumbing" in a High Availability scheme, introduce many of the commands, suggest some optimal hardware choices that tend to be journal-friendly, and finish off with some performance tuning suggestions.
In this session, learn:
1. When and where to use journal functions.
2. The benefits you can expect.
3. What's new.
4. Some of the major factors which affect performance.
5. How to make your applications more journal friendly.

___6) RPG Tips and Techniques – Paul Touhy, ComCon (Award winning Speaker)

A web browser is fast becoming the new interface for iSeries Applications. RPG still has a large part to play in browser based interfaces. But how can an RPG program be called from a browser? What do you need on the iSeries? How can an RPG program communicate with a browser?
In this session learn:
1. How to configure the Apache Server.
2. The basics of CGI (Common Gateway Interface).
3. Some of the "gotchas" when programming for a browser.

___7) How Does RPG Talk to a Browser – Paul Touhy, ComCon (Award winning Speaker)

___8) CGIDEV2 – The Basics – “Printing to the Web”– Paul Touhy, ComCon (Award winning Speaker)

This session will show you how you can convert printed reports to deliver them to your users via the browser. We will also show how easy it is to extend the functionality of these 'reports' to include graphics and links to other applications.
You will learn:
1. The basic HTML required to build simple pages.
2. An easy technique using RPG IV SPECIAL files that allows you to convert a program in next to no time.
3. How to extend the report content through the use of graphics.
4. How to accept parameters from the user to control the report contents.

___9) CGIDEV2 – The Details– Paul Touhy, ComCon (Award winning Speaker)

This session will introduce you to one of IBM's best kept secrets - the CGIDEV2 tools. CGIDEV2 contains tools that can significantly simplify the task of writing RPG IV CGI programs, and best of all, the whole thing is completely free.
We will show you how the tools work together to take the hard work out of CGI programming. We will also introduce you to IBM's Easy400 web site where you can find not only full working examples that use the CGIDEV2 library, but tutorials, downloadable source files and more.
You will learn:
1. How to obtain the CGIDEV2 tools.
2. The components of the tool set and how they work together.
3. How to tap into the additional resources of Easy400.

___10) ILE by Example– Paul Touhy, ComCon (Award winning Speaker)

This session takes a small sample RPG IV application and examines the issues involved in integrating it into an ILE application. This includes decisions on Dynamic Binding, Static Binding, Bind by Copy or Reference, structure of Service Programs, Binder Language, Binding Directories and Activation Groups.
By the end of this session, attendees will be able to:
1. Understand the benefits of ILE.
2. Understand the decision process in using the components of ILE.
Prerequisite: Attendees must have a basic understanding of the components of ILE.

___11)Architecting Modernization – Trevor Perry, Clear Technologies (award winning speaker)

Enterprise Application Modernization, or EAM, will help you make the most of your existing applications by enabling those applications for the on-demand world quickly and with a higher return on investment by reusing existing assets.
The introduction to EAM will present a framework to understand Enterprise Modernization. It will focus on a higher level of IT strategy which addresses customer needs, applications, platforms and direction. A review of some of the current industry and vendor offerings related to Enterprise Modernization is covered.

___12)Trends in Enterprise Modernization– Trevor Perry, Clear Technologies (award winning speaker)

This presentation covers important trends in enterprise modernization from sources such as IBM, Microsoft, Gartner, Giga and others. It addresses hot topics including:
- RPG in a SOA world
- IBM and Microsoft in the midrange - competitive or complementary?
- Can Java and .Net work together?
- Smart, thin and mobile UIs for existing applications
- Composite applications and the iSeries - a perfect match?
By the end of this session, attendees will be able to:
1. Explain how existing RPG assets can be reused in an SOA world.
2. Understand the potential issues and benefits of IBM's and Microsoft's focus on midrange modernization.
3. Describe how multi-channel UIs can improve ROI from existing applications.

___13) iSeries Access for Web Database Access – Janet Weber, IBM

iSeries Access for Web provides web-based access to iSeries resources. This session focuses on how easy it is to access iSeries DB2 UDB from the Web. The session also covers iSeries Access for Web options available to get database query results to an end user.
In this session, learn:
1. How to use the SQL Wizard to build SQL SELECT statements.
2. How to create, store, and run a SQL request.
3. Advanced output options, such as file types, HTML options, and lists.
4. How to use iSeries Access for Web to upload data to the iSeries from a Web browser.
5. How to run a dynamic query using your own web page.
6. How to query information about iSeries objects and resources.

___14) iSeries Access: Use it or Loose out part II – Database and File Systems – Barbara Brown, Alliance Systems & Programming

iSeries Navigator is the most powerful iSeries tool available, and yet I am continually amazed at how many iSeries people are NOT using it! Well, it’s time to change that!!

Come and learn how to use the iSeries Navigator functions. The topic was TOO BIG for one session. Last time we covered the management and configuration functions. This session will address:

Database functions (viewing relationships, attributes, working with SQL, using visual Explain to analyze query performance),
File systems (mapping Windows server shares, managing files, etc)

___15) Problem Determination Techniques for Web Applications – George Weaver, IBM

This session provides a holistic view of problem determination in a WebSphere Application Server (WAS) environment, including the client, network, HTTP server, application server, and enterprise applications and data. Topics include commonly observed problems, usage of logging files and tools, and using the trace facilities within WAS and WebSphere Development Studio client (WDSc) for iSeries.

___16)Web Enabling Database Resources with WDSc – George Weaver, IBM

This session illustrates how you can easily build, test and deploy new, high value Web applications that leverage your investment in DB2 UDB for iSeries resources, with WebSphere Development Studio client (WDSc) for iSeries. It includes a brief overview of Java based techniques for accessing DB2 UDB for iSeries. It includes detailed examples of using
the WDSc data perspective and Web perspective wizards to build Web applications without requiring any Java programming experience. It also covers the WebSphere Application Server configuration steps necessary to deploy these new applications.

___17)Creating the iSeries Linux Desktop – Mark Vanderwiel, IBM

This session will describe how to configure and utilize a Linux desktop to access a variety of iSeries functions. The following topics will be covered: iSeries Access for Linux, iSeries Access for Web, iSeries Navigator for the web, iSeries NetServer, OpenOffice, migrating from and exchanging data with Windows. The session will include a demo of an iSeries Linux desktop.

___18)Office2003 Integration with XML on iSeries – Vincent VanderLinden, Invenso

In this session we will give an overview of the XML features inside Office2003 professional edition. Based on practical examples, we will explain how to convert excel data to XML and how to import XML into an excel sheet. Within Word2003 we will show how to create and use smart documents. Additionally, we will demonstrate how to address Excel2003 and Word2003 from within our traditional iSeries applications. In this presentation we also overview the abilities of the new Infopath application to replace your 5250 applications using forms and webservices.
By the end of this session, attendees will be able to:
1. Understand the Office2003 XML capabilities.
2. Understand new concepts to generate documents from within your iSeries applications.
3. How to use this in combination with other applications like openoffice.

___19)iSeries Problem Management & PTF/Change Management Using iSeries Internet Web Site – Marshall Tweed, IBM

Find easy ways to use the Web to manage problems and fixes.
In this session, learn:
1. How to open, view, change and close an incident (PMR) working directly with the SupportCenter using the Web.
2. About the PTF Cover Letter database on the Web and how to identify which fixes to order.
3. How to place an order and have the fix delivered to your system.
4. Enhancements and improvements to iPTF.

___20)Make ManagingPTFs a Snap! – Marshall Tweed, IBM

Though each customer may use different processes, the tools and techniques for managing fixes (PTFs) for a network of iSeries have many things in common. This session will discuss the challenges, benefits and methods of ensuring a consistent software base through practical scenarios. If you manage iSeries systems, come get a glimpse of some tips and techniques to improve management of fixes.
By the end of this session, attendees will be able to:
1. Order a Fix from IBM.
2. Locate the fix via iSeries Navigator interface.
3. Send and install the fix on other iSeries or Partitions.

___21)MS Office and iSeries Access Integration: Setup and Overview – Frank Thomas, Berbee

This is the introduction to the MS OfficeiSeries Access data integration Roadmap.
In this session you will learn how to:
1. Set up MS Office and Client Access.
2. Move data to MS Office applications.
3. Use ODBC and File Transfer.
4. The role of SQL.

___22)MS Office and iSeries Access Integration: Basic Functions – Frank Thomas, Berbee

In this Session you will learn how to:
1. Create labels using iSeries data.
2. Create merged letters, price list and How to Documents.
3. Make a "pretty" report using the Magic Button.
4. Create a pivot table (the poor man's Data Warehouse).
5. Create an automatic prompted query from iSeries data .

___23)MS Office and iSeries Access Integration: More Functions – Frank Thomas, Berbee

Some of functions you will learn session are how to:
1. Integrated with MS Access.
2. Running Commands almost automatically.
3. Transferring data to the iSeries.
4. Using crystal reports forreporting.
5. Using office as a development and documentation tool.

___24)Using DB2 Monitors to Analyze and Improve SQL & Query Performance – Linda Swan, IBM

Have you ever tried to solve a query or SQL performance problem with someone else's program and not known where to start? One of the tools that can help is the iSeries most overlooked performance monitors, the database performance monitors. The data collected by the integrated DB2 monitors during runtime can be used to identify which database requests are causing the biggest performance issues.
By the end of this session, attendees will be able to:
1. Collect database performance monitor data.
2. Understand the data that's collected and how it's organized.
3. How to use the data to identify & fix performance problems.

___25)DB2 UDB: SQL Stored Procedures – Linda Swan, IBM

Stored Procedures are a valuable tool for improving performance in distributed and networked environments. In addition, they can also be used to improve the flexibility and design of your applications. SQL Stored Procedures offer a procedure language that is comparable with stored procedure languages of other DB Servers such as Oracle & SQL Server.
By the end of this session, attendees will be able to:
1. How to create and invoke an SQL Stored Procedure.
2. Understand error handling techniques in SQL Procedures.
3. How to move an SQL stored procedure into production.

___26)InfoPrint Designer for iSeries – Bill Shaffer, IBM

Infoprint Designer for iSeries is the integrated, comprehensive design platform for iSeries application output. Creating sophisticated, electronic documents and reports is essential with today's business and e-business-driven processes. Infoprint Designer provides a tightly integrated design front-end to the iSeries print and output subsystem, enabling you to reengineering existing output into fully electronic pages without any change to the underlying application program. It provides professional, fully graphical image and overlay design. More importantly, it integrates those elements and your application data into the final document or report, and positions you for "downstream" output functions such as PDF or "e-delivery" electronic distribution (see Infoprint Server sessions). Infoprint Designer is supported on V4R5 and later releases.