|
Dave Prescott
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. |
|
SATURDAY SEMINAR: All You Need To Know About SQL in Six Hours
SQL has become the industry standard for moving data between platforms in a network centric computing environment, and working with data in a relational database. In today’s IT environment of mixed hardware and software platforms you have to know SQL to survive. This six hour seminar will serve as an excellent introduction to SQL on the IBM i, System i, and the iSeries for those people who may not be familiar with it, or it will be an excellent review for those who need a refresher course. Via the internet, live demonstrations will be used to illustrate SQL concepts and functions.
After attending this seminar, you will have an understanding of SQL basic concepts and theory, and will be able to create and execute simple SQL statements using SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP. You will understand the four groups of SQL statements and how they are used, the various SQL interfaces and what they are used for, and how to embed and compile SQL statements in a high level language program like RPG or Cobol. You will also understand how to use SQL in place of DDS and the native interface to create and manage database objects.
Morning:
The morning part of this seminar will be spent building a firm SQL foundation. It will start with a discussion of SQL basic theory and terminology, and progress to SQL statement format and structure and the more frequently used SQL statements: SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP. It will show you how to use SQL functions such as MIN, MAX, AVG, SUM, COUNT, AS, and Subselect to query and analyze data.
After covering these basics, the seminar will move on to some intermediate level topics. First it will look at the SQL software support that is available in Version 5 of OS/400 and i5/OS so you can understand which part is included with OS/400 and which part is a separate licensed product. Next it will show you the groups of SQL statements used to query and work with data, to define and manage data base objects, and used for miscellaneous functions. The morning will end with a discussion of the various SQL interfaces available on the IBM i, System i, and the iSeries.
Afternoon:
The afternoon part of this seminar will take you on a detailed exploration of some more advanced SQL topics that include: Interactive SQL, the SQL Statement Processor (RUNSQLSTM command), the SQL Script Center in iSeries Navigator, Embedding SQL in a High Level Language program (RPG, COBOL, C), and Dynamic SQL. The seminar will conclude with a detailed discussion of how you can use SQL, in place of DDS and the native interface, to create and manage your database objects. |
Introduction to 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. |
Achieving High Availability with MIMIX
This session assumes a basic understanding of journaling as covered in the session “Introduction to Journaling on iSeries, System i, and POWER6 Systems”.
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.
Come to this session to understand MIMIX. Learn the concepts of replicating data from one system to another using journaling. Learn how to set up, implement, and manage a MIMIX environment. After attending this session you should feel comfortable working with MIMIX. |
Understanding LPAR on a System i or POWER6 System
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 OS/400, allowing for example running the current OS/400 release in a production partition, and testing the next OS/400 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. |
LPAR: Implementing Partitions on a System i or Power System
This session assumes a basic level of LPAR knowledge as covered in the session “Understanding LPAR on iSeries, System i, and Power Systems”.
The hardware Management Console, or HMC, is key to creating and managing partitions on a System I or Power system. Learn about the HMC and all its LPAR functions. Learn how to configure a partition by assigning memory, processor, and I/O resources. Learn how to decide whether processors should be assigned as dedicated or shared, as capped or uncapped. Learn about virtual processors. Learn how to use Dynamic LPAR to change the resources in a partition. If you want to really understand how to create and manage partitions on a System I or Power System, then this session is for you. |
Upgrade 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, including the issues involved in skipping a release (for example upgrading directly from V5R2 to V5R4). After this session you should be fully prepared to perform your own version and release upgrades. |
Implementing BRMS on the iSeries, System i and POWER6 Systems
Backup Recovery and Media Services (BRMS) is IBM’s strategic backup management product. BRMS helps implement your backup strategies, track your media, and automate your recoveries. BRMS also supports data archiving in a hierarchical storage management (HSM) environment, allowing dynamic data retrieval from your backup. BRMS even saves your spool files.
Come to this session to understand BRMS. Learn how to install and set up BRMS to perform save and restore operations. Learn how to review the BRMS reports. After attending this session you should feel comfortable installing and implementing your backup and recovery requirements with BRMS. |
|
