ASF Past Speakers
Past Speakers:
Speaker: Debbie Saugen
Topic: BRMS Overview: What Does It Do and How Do I Implement It?
iSeries and i5 systems management is critical to the smooth operation and success of your business. Backup, Recovery and Media Services (BRMS) is IBM’s strategic product for managing the save/restore and data archive aspects of good systems management to ensure the safety of your data. BRMS helps track your media, implement your backup strategies, and automate your recoveries. BRMS will allow backup to tape devices, automated media library devices and save files. BRMS is also the premiere HSM solution for the iSeries and i5, allowing data archive and dynamic retrieval to and from tape. This overview will cover installing the product, setting up simple BRMS operations included in the BRMS product, and how to review the BRMS reports to ensure all saves ran successfully.
Debbie Saugen is the technical owner of iSeries and i5 Backup and Recovery in IBM’s Rochester, Minnesota, Development Lab. She is also a senior recovery architect/consultant with IBM Business Continuity and Recovery Services. Debbie enjoys sharing her knowledge by speaking at COMMON, iSeries and i5 Technical Conferences, and Business Continuity and Recovery Services Conferences, and writing for various iSeries and i5 magazines and Web sites.
Speaker: Daniel Cruikshank
Topic: Database Transformation – Reverse Engineering DDS to SQL DDL
SQL Data Definition Language (DDL) has become the industry standard for defining RDMS databases. DDL statements consist of CREATE statements for defining database objects, ALTER statements for customizing existing objects (for example adding a constraint) and GRANT statements for authorizing the access or permissions to database objects.
In V5R1 of OS/400, IBM introduced the ability to reverse engineer databases created via DDS to SQL DDL schema. There are several reasons behind this enhancement some of which are:
provide access to database enhancements which are being made available to SQL created databases only,
provide portability capabilities to PC based data modeling tools which only support SQL,
provide compatibility with other IBM DB2 UDB products and strategic across platform application development tools such as WebSphere Developer Studio Client.
Dan’s presentation will be on Database Transformation-Reverse Engineering DDS to
DDL. This process involves a staged approach to DDS migration and SQL implementation. The presentation will be broken into the following topic areas:
Background
Reverse Engineering DDS to DDL- things to consider
Developing I/O modules to access DB2 data using SQL or RLA-Record Level Access (the iSeries gives you a choice).
Database Design issues-Referential Integrity, Identity columns, Sequencing objects, etc.
Implementing advanced database functions – functions, user defined types, check constraints, etc.
The presentation will consist of discussion and demonstrations of advanced tools including iSeries Navigator, WDSc, QMF and others. In addition, customer examples of good, bad and ugly techniques will be discussed (names will be changed to protect the guilty).
Mr. Cruikshank has been an IT Professional since 1972. He has served in several capacities, both operations and programming. He has been a consultant on a number of different project areas since 1988. Since 1993, Mr. Cruikshank has been focused primarily on resolving iSeries (AS/400) application and system performance issues at several IBM customer accounts.
Mr. Cruikshank has been teaching the IBM DB2 UDB for iSeries SQL Optimization Workshop since 1999. This class is taught in Rochester (or at customer locations) to Data Base Analysts new to the iSeries, iSeries professionals who are new to SQL, DB2 UDB for iSeries developers and IBM Rochester DB2 UDB for iSeries Level 2 support personnel.
More recently Mr. Cruikshank has taken on architectural and advisory roles within several major projects. These include a three tier architecture project where the iSeries was both the application server using CICS and the database server using DB2 UDB for iSeries; another project involving the modernization of COBOL legacy code to DB2 UDB for iSeries utilizing WebSphere and SQL, and an application assessment project involving RPG applications.
Mr. Cruikshank is frequently called upon by the IBM Rochester Project office to assist in customer critical situations involving SQL and DB2 UDB for iSeries. In the last year he resolved issues with customers located in South Korea, Brazil, Japan and China.
Speaker: Gottfried Schimunek
Topic: iSeries Sizing and Capacity Planning
Analytical tools for performance capacity planning were available as part of the performance tools LP on iSeries (and before on AS/ 400) for many years and were based on real time measurements of transactions and corresponding resource usage. Extrapolations done with these tools are extremely precise since measured data are directly fed into the extrapolation model. Also real application code pathlength and speeds and feeds of hardware and operating system code is used to determine resource utilizations and response time ratings. This presentation will demonstrate yet another capacity planning and sizing tool called the Workload Estimator – WLE. We will demonstrate how to use this web based tool for the iSeries which operates directly on the web or as a download, but is much quicker, easier to use and produces better and more attractive charts and graphs then previous tools. We will go through “what if” scenarios and demonstrate the impact of various hard and software options to throughput and resource utilizations.
By the end of this session, attendees will be able to:
- Model and extrapolate various workload data on IBM iSeries
- Understand the differences between sizing and capacity planning
- Explore the impact of various HW/ SW options to performance
- Use Workload Estimator to size new workloads such as Domino, WebSphere, WebFacing or Linux.
Gottfried Schimunek is a Consulting Information Technology Architect with IBM and has been taking a lead role in application and product development projects for over 25 years. Currently he is the Program Manager for the Technical Review Board (TRB) for PartnerWorld for Developers in Rochester, Minnesota. His primary interests are performance measurement, analysis and capacity planning of applications. Gottfried is a frequent presenter at customer, user group, and technical conferences around the world. He helps IBM Business Partners and Independent Software Vendors (ISVs) understand how to bring the power of e-business to build a secure, trusted set of applications to improve their revenue, avoid costs, and improve customer services. His particular emphasis is on utilization of existing application systems in an e-business environment.
Speaker: Dan Moravec
Topic: Extending the reach of your iSeries to the Internet
Come learn how to better leverage your iSeries machine in a connected world! We will look at the web application architecture, and go
into specific details on how to extend your existing programs & data to the web.
Dan Moravec is a Senior Software Engineer for IBM in Rochester, MN. His assignments at IBM have covered a number of different areas of operating systems and middleware development. Most recently, Dan lead a team responsible for web-enabling Systems Management components for the iSeries. Dan is a frequent speaker at COMMON and many other users groups.
Speaker: Carole Miner Senior Software Engineer for IBM
Topic: iSeries Access for Web: The browser alternative!
By using this product you will be able to logon to your iSeries(AS/400) from a web browser . This product (5722XH2) is already included in the iSeries access for web software CD. Many of today’s iSeries customers are looking for a fast, zero-admin way to connect to their servers through a simple web browser interface. iSeries access for web is that solution! It has been built specifically for the needs of iSeries customers.
Come to this session to learn how this client can enhance end user productivity and simplify your pc network administration.
At the end of this session, attendees will be able to:
See how 5250 emulation, database and IFS access can be used from a browser.
See how an iSeries administrator can setup front pages for different group of users.
See how users can work with printers, print jobs, etc. on the server.
Learn about additional functions being provided.
Carole Miner is a Senior Software Engineer in the iSeries client integration area at IBM Rochester Laboratory. She is an internationally known speaker, author and iSeries authority. She is a frequent COMMON speaker and she has spoken worldwide at many iSeries users groups, & Technical Conferences.
Carole has a strong grounding in programming, planning and leadership including the Original PC support and integrated xSeries Server. Carole’s current focus is client Integration technologies and support for iSeries access products.
Speaker: Troy Bleeker of IBM, Rochester MN.
Topic: “PDAs – ” Tools or Toys, How iSeries Users Can Benefit”Ever ask yourself, ‘Those palm computers look fun but what good are they for business use?’ Wow, there are so many different ways to use PDAs: some simple, some complex, many free, some not-so-free. Come pick through a smorgasbord of software that may be useful to you, your business, or your customer. All the products discussed do not communicate directly with the iSeries, but we will show the iSeries as the host for everything from green screen applications to Web serving. And we’ll try not to leave out the fun stuff.
Speaker: Doug Fulmer, IBM iSeries World Wide Sales Executive for e-business Infrastructure.
Topic: ” WHICH WEBTOOL TO USE ? A CRITICAL COMPARISION OF WEBTOOLS FOR I-SERIES,” May 20, 2003.
Many iSeries shops are trying to move toward refacing their existing applications. Moving them to the Web. Putting them in a GUI. But while there never seemed to be any tools in the past, now there seem to be so many. They are confused and bewildered. Should I use HATS or WebFacing? Client Access or Host Publisher? Host Integration or Host on Demand? And that’s before they even consider the various partner solutions like Seagull and Jacada and Look Software. This session will take an objective view of all of these tools side by side and spell out the pros and cons of the tools, helping you boil the list down to the best tool for your situation.
Speaker: Roy Goldstein, Director of Technical Services with Capricorn Information Systems, a Westchester consulting Firm Topic: “VisualAge RPG: What’s it all about.” March 18, 2003. Many of you have heard of VARPG but what do you know about it? Did you know that it’s available for free with your software subscription as part of Websphere Development Studio? Did you know that you can develop Windows graphical user interfaces and access iSeries data and programs using your current RPG skills? Did you know that you can interface with desktop and NT applications like MS/Access and Excel? Did you know that it takes only a few minutes to setup connectivity to the iSeries?
Speaker: Ken Goetz – Sr. Consultant, KeyLink Systems, Solon, Ohio, January 21, 2003.
Topic: “Using Internet Resources to answer your IBM iSeries questions”, January 21, 2003. Every have problems navigating through the complex IBM maze trying to determine solutions to your everyday problems and issues? This presentation is designed to assist individuals in “finding the answer yourself” to Support line, Maintenance, ConsultLine, Software Subscription issues and a lot more.
Speaker: Dan Wallace, AAA Carolinas, November 19th, 2002.
Topic: Delivering Information to Decision Makers: First Steps Toward BI/EIS.
Mary Anne Rayfield, CIO, AAA Carolinas and Doug Livesay, Senior Consultant, Brio Technology
Brio Technology offers integrated enterprise reporting and portals.
AAA Carolinas is an organization that provides services to AAA members as well as Travel Agency, Insurance and Financial Services to customers across North and South Carolina.
Topic Description: AAA Carolinas recently implemented the Brio Enterprise software to provide Data Warehousing Capabilities.