Kursen har inget datum. Ring vår kursbokning 077 186 10 37 för information om en privat utbildning.
Översikt
| Kurskod | 3N230SE | Leveranstyp | Instructor Led - Online Training
(Hands-on labs) |
|---|---|---|---|
| Kurslängd | 5.0 dagar | Kurstyp | |
| Listpris |
SEK 25 500,00 exkl moms
SEK 31 875,00 inkl moms |
If you do not see this in your country, search the global scheduIe for offerings in other countries.
This course will run five hours per day for five days. This is the FLEX Instructor Led Online version of classroom course DA230. See also Course 3A230.
This is an online course. 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 audio, video and remote labs.
This course is designed to instruct you on the reasons and methods used to install, configure, use, and troubleshoot the IBM solidDB Universal Cache.
This course will be taught as 5 half-day sessions within one week with hands-on lab homework time required outside of the online classroom sessions.
Målgrupp
The audience for this course may include:
- Relational database DBAs
- Relation database designers
- Database application programmers
- Application systems designers
Förkunskaper
Members of the course should be adept in the use of the Windows and Linux operating system environments. Students should also be well-versed in relational database design and usage, including knowledge of common SQL statements.
Mål
- Explain the IBM solidDB Universal Cache architecture and design principles
- Describe the IBM solidDB Universal Cache features
- Install the IBM solidDB Universal Cache product
- Configure and start IBM solidDB Universal Cache
- Review performance issues
- Identify and fix IBM solidDB Universal Cache failures
Nyckelområden
IBM solidDB Fundamentals and Features
- Realize the need for Relational, In-Memory, database technologies for extreme speeds
- Describe the IBM solidDB Product Family
- Describe the overall view of IBM solidDB Universal Cache
- Explain how data synchronization works at a high level
- Describe schema mapping and data transforms
- Explain how IBM solidDB Universal Cache scales horizontally and vertically
- Discuss an overview of IBM solidDB Universal Cache: High Availability
IBM solidDB Installation and Configuration
- Perform a solidDB installation
- Perform basic solidDB configuration
- Manipulate the state of the solidDB server: Startup, Shutdown
- Use some of the data management tools
- Perform administrative tasks, such as: Monitoring the server, Backup and Restore, Compacting, and Encrypting
Introduction to IBM solidDB Architecture
- Explain the solidDB architecture
- Review the programming interfaces available
- Describe the SQL engine and the Optimizer
- Review the HotStandby principle for the database engine
- Explain the Checkpoint methods
- Describe the IBM solidDB In-Memory database
- Compare and contrast In-Memory and disk-based engines
- Use Admin commands and operating system commands to Monitor memory consumption
IBM solidDB In-Memory Engine
- Describe optimizing In-Memory data access
- Explain the limitations of In-Memory tables
- Review the solidDB In-Memory database table types
- Specify table location
- Use In-Memory database parameters
IBM solidDB Universal Cache Architecture and Configuration
- Review the IBM solidDB platform support, back-end database support, and back-end platform support
- Explain the IBM solidDB packaging
- Explain the InfoSphere CDC (Change Data Capture) technology
- Review the solidDB Universal Cache architecture
- Perform solidDB Universal Cache configuration
- Review some typical In-Memory caching examples
- Describe the Universal Cache data synchronization functionality
IBM solidDB and High Availability
- Describe the HotStandby principle
- Explain 1-safe and 2-safe Replication
- Review IBM solidDB HotStandby concepts
- Describe the HotStandby server states
- Compare and contrast Switchover versus Failover
- Diagnose Primary and Secondary server symptoms
- Describe load balancing behavior
- Explain the Watchdog application
- Explain the HA Controller
- Change HotStandby parameters
- Review Universal Cache and High Availability
IBM solidDB HotStandBy and Applications
- Describe load balancing behavior
- Explain the Watchdog application
- Explain the HA Controller
- Change HotStandby parameters
- Review Universal Cache and High Availability
IBM solidDB Performance
- Explain database and application performance
- Optimize write and read operations
- Use Optimizer Hints to help performance
- Know when and how to index columns
- Use the EXPLAIN PLAN FOR utility
- Describe factors impacting InfoSphere CDC (Change Data Capture) performance
Diagnostics and Troubleshooting for IBM solidDB
- Diagnosing different types of performance problems
- Use tools for diagnosing performance problems: ADMIN COMMANDs
- Review error messages
- Use pmon counters
- Review read and write intensive operations
- Review file system and CPU intensive operations
- Collect user information
- Work with the solidDB Facilities available for diagnostics
- Handle failures in InfoSphere CDC
Application Updates for DB2 and IDS Users
- Work with solidDB SQL to create or modify Stored Procedures, Triggers, Events, and Sequences
- Work with several other programming languages, such as C and C++, and Java
- Execute SQL statements in SPs
- Work with cursors
- Describe error and exception handling
- Explain the processing of SQL statements
- Convert from DB2 or IDS to solidDB
IBM solidDB Linked Libraries
- Work with the solidDB Linked Library Access
- Use concurrent remote connections with Linked Libraries
- Use dual-mode applications with Linked Libraries
- Describe solidDB interfaces: ODBC, JDBC, solidDB SA API, and SSC API
- Link local and remote applications
- Review Static versus Dynamic issues
- Describe some implementation issues