MidAtlantic Midrange is proud to offer the next in our continuing education seminars, bringing you the best education and educators available in the iSeries world, and to do so at User Group Rates.

System Management on System i and POWER6 Systems with V6R1 Update
With Dave Prescott

This one-day seminar explores issues and techniques that will help you manage your iSeries, System i, and POWER6 Systems more effectively. As we progress through the day, we will highlight new features of V6R1 pertaining to System Management.

We start the day out with Upgrading your iSeries or System i to V5R4 or V6R1. This session covers the detailed planning and preparation steps that must be performed before a release upgrade can be attempted. This is followed by a detailed explanation of what actually happens during a release upgrade, and then a discussion of the activities that must be performed after the release upgrade has completed. We will focus on release upgrades to V5R4 and V6R1, including the issues involved in skipping a release (for example upgrading directly from V5R3 to V6R1). After this session you should be fully prepared to perform your own version and release upgrades.

We then move on to discuss SQL on iSeries, System i, and POWER6 Systems. This session is an introduction to the very powerful query language, SQL. SQL is the strategic query product for the iSeries and System i, supporting the DRDA (Distributed Relational Database Architecture) functions of retrieving data and updating data on both local and remote systems. We will discuss SQL operations and the SQL language syntax, and then show how to create interactive queries with SQL. We will conclude by showing how to use SQL in RPG and COBOL programs

Next we'll discuss Journaling on iSeries, System i, and POWER6 Systems. Journaling provides the means to record updates to your database and the ability to recover those updates. The functions of journaling are integrated into i5/OS and IBM i, and are therefore available to all iSeries, System i, and POWER6 systems. Journaling is an integral part of a strong and flexible system recovery plan. With journaling you can go back to your last backup and restore your database up to the point of failure or to the point of database corruption. With journaling you can also back out erroneous updates to your database. Journaling also provides capability beyond database recovery: with journaling you can see how and when each record in your database was updated, and you can even journal objects other than physical and logical files. If you have large logical file access paths, you are likely already using journaling. New functions in V6R1 will be highlighted. After this presentation you should have a solid understanding of how to implement and manage journaling.

We then go into Achieving High Availability with MIMIX. MIMIX is a high availability solution designed by Vision Solutions, Inc., formerly Lakeview Technology, Inc., which replicates data changes from one system to another in real time. If the production system has a planned or an unplanned outage, the backup system is immediately ready to take over for the production system until such time as the production system is back online.

MIMIX uses native system journaling functions. MIMIX supports replicating not only changes to file data, but also changes to other objects like data areas, data queues, user profiles, and IFS directories and stream files.

Learn the concepts of replicating data from one system to another using journaling. Learn how to set up, implement, and manage a MIMIX environment.

Finally we'll take a glimpse at how partitioning (LPAR) might fit into your future. We finish the day by spending some time Understanding LPAR on iSeries, System i, and POWER6 Systems. Logical Partitioning (LPAR) provides a powerful capability for consolidating multiple AS/400, iSeries, and System i systems onto a single system. Each partition of a partitioned system can have its own copy of i5/OS, allowing for example running the current i5/OS release in a production partition, and testing the next i5/OS release in a different partition. Sizes of system resources in each partition can be changed dynamically and shifted from one partition to another to adapt to changing requirements. This session begins with the concepts of partitioning, including environments best suited to partitioning. This is followed by a discussion on hardware and software considerations for partitioning, highlighting how to begin planning for a partitioned environment. This session should provide you a good understanding of how LPAR could fit into your future.

Dave Prescott has been an AS/400 specialist since 1987 and was an IBM Rochester Lab Consultant and participant in the AS/400 National Technical Advocate Program. His special interests include iSeries and AS/400 performance tuning and capacity planning, system operations, and system management. Since retiring from IBM, Dave, co-owner of Systems Management Associates, Inc., has provided system management and performance expertise in a large installation with multiple iSeries and AS/400s.

This seminar starts at 8:30 AM and ends at 5:00 PM and will be held on:

September 18, 2008 at the College Park Holiday Inn in College Park, MD (Beltway and US-1).

The course fee is $285 for non-user group members and $250 for user group members. This fee offering is a special arrangement between Washington Area Midrange Users Group and MidAtlantic Midrange. Members of other AS/400 User groups may also apply under the user group rate.

Name: _____________________________________________________

Company:___________________________________________________

Address:____________________________________________________

City: _________________________________ State: _____ Zip: ________

Office Phone: _______________________ Fax: ______________________

Email address: _________________________________________________

Please circle the date of the session you plan on attending.

Please mail completed form with check to: MidAtlantic Midrange, Conference Services,

12023 Blackberry Terrace
North Potomac, MD 20878.

For any further questions or reservations, contact K.B. Soni at 301-590-7121 or by email.