Overview
| Course code | 1L020 | Skill level | Basic |
|---|---|---|---|
| Duration | 3.0 days | Delivery type | Web Based Training |
| Course type | Public only | ||
| Public price | USD $499.00 plus tax | ||
Note: This is a self-paced online course. This course usually requires 26 hours to complete. Once you receive your access information, you will have 60 days access to this course.
This course provides an introduction to DB2 Everyplace, the data structures, functions, the Remote Query and Stored Procedure Adapter, as well as basic transaction support in DB2 Everyplace. The tutorial will introduce you to the installation components for various devices and platforms, the architecture of the Synch Server and the components of synchronization, as well as synchronization solution administration. Some advanced synchronization Server Topics, information on Connections and Networks, as well as Scalability, Performance, Monitoring, and Troubleshooting are introduced. You will be shown how to set up a Mobile project, how to develop applications using the application development tools and how to migrate from your existing software to DB2 Everyplace V9.1.
This innovative self-paced online format is available from IBM Training and gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours. The course is available 24 hours a day
Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course materials.
Skills taught
At the completion of this course, you should be able to state an overview of the functions and capabilities of DB2 Everyplace.
Course outline
Introduction to DB2 Everyplace
- Describe the architecture, features, and value proposition of DB2 Everyplace
- List the components of the DB2 Everyplace solution
- Explain how you can employ DB2 Everyplace to help IBM customers
- Describe which mobile and handheld devices work with DB2 Everyplace
DB2 Everyplace Database
- Describe the DB2 Everyplace architecture
- Explain how to use tables
- Describe locking tables
- Modify DB2 Everyplace database encryption
- Describe how data is retrieved
- Understand how DB2 Everyplace connects with other databases and devices
Introduction to DB2 Everyplace Installation and Configuration
- Identify the components of the DB2 Everyplace solution
- List the prerequisites for installing DB2 Everyplace
- Identify the steps for installation and configuration
- List the install components for the devices
DB2 Everyplace Synchronization
- Describe the synchronization architecture
- Describe the replication architecture
- List supported devices and platforms
- Describe the Mobile Devices Administration Center (MDAC)
- List the synchronization objects
Synchronization Solution Administration
- Describe the first planning steps
- List the definition steps
- Explain elements of replication and synchronization
- Describe DataPropR, JDBC, upload, custom, and file synchronization scenarios
- Explain the synchronization modes on the mobile devices
Advanced Synchronization Server Topics
- Describe different types of filtering
- Explain where to set filtering
- Modify remote stored procedure call
- Explain how DB2 Everyplace protects data
- Understand conflict resolution
- Describe the functions of the XML scripting tool
Connections and Networks
- Describe the different networks that you can use
- Make an active sync connection
- Use Softick PPP for Palm
- Describe phone connections for Symbian
- Explain how to configure a wireless LAN
Scalability - Performance - Monitoring
- Explain load balancing and high availability
- Prepare a sizing estimate
- Configure the system for peak performance
- Tune your DB2 Everyplace solution
- Monitor the synchronization process
Troubleshooting
- Troubleshoot on DB2 Everyplace
- Describe tools delivered with DB2 Everyplace
Set Up a Mobile Project
- Set up a mobile project with DB2 Everyplace
Application Development
- Explain strategies for moving data from or into devices
- Describe DB2 Everyplace programming environments and tools for different device operating systems
Microsoft Embedded Visual C++ (eMVC) and WebSphere Studio Device Developer (WSDD)
- Develop with Microsoft Embedded Visual C++ (eMVC)
- Explain the basics of WSDD
Migration to Version 9.1
- Explain the purpose of parallel migration to DB2 Everyplace V9.1
- Name the source databases for which parallel migration to DB2 Everyplace V9.1 is supported
- List the major steps involved in a parallel migration to DB2 Everyplace V9.1
- Describe the process of migrating client devices to the DB2 Everyplace V9.1 server
- State the limitations involved in a sequential migration to DB2 Everyplace V9.1
- Identify the major steps involved in the sequential migration process
- Describe the process of exporting the DB2 Everyplace V8.2.x configuration during a sequential migration
- Name the DB2 Everyplace V8.2.x components that need to be removed from the server
- List the required and optional steps for installing DB2 Everyplace V9.1 on the server
