|
Synopsis |
This is an intensive 5-day master-class in Ingres
tuning and configuration, consisting of lectures and supporting labs. Provided
on-site, using Ingres on Unix, Linux, W2K/W2K3, or VMS. Provides in-depth
training in configuring and tuning the Ingres DBMS server, the locking system,
and the logging system. This course is fully up to date, and can be configured
to cover any release from 6.4 to Ingres 2006.
(Course developed by Database Management
Technology Inc.) |
 Customers in the US/Canada should
contact DMT Inc. to schedule this course |
|
Duration and Cost |
5 days, £1,750 / €2,600 per seat, ex VAT |
Price excludes VAT and other applicable local taxes |
|
Location |
London, Manchester, Dublin, and
on-site world-wide |
|
|
Format |
Lecture and labs |
|
Course
Code |
TNC |
|
|
Prerequisites |
A strong knowledge of Ingres system
administration, with at least one year of experience as a DBA or Ingres System
Administrator. The ability to read and understand moderately complex SQL queries
is assumed. Strong operating system skills would be advantageous, but not
essential. This is a master-class and it presumes a high level of Ingres
expertise from the outset. |
|
|
Outline
Day 1 |
| Chapter 1 |
Introduction
|
| |
|
| Chapter 2 |
Ingres
Multi-Server Architecture |
| |
overall
system architecture / OS implementation differences / Ingres II
enhancements / subsystem interaction / Ingres NET
|
| Chapter 3 |
Query Performance |
| |
query
processing system / available storage structures / data compression /
secondary indices / sysmod / optimizedb / statdump
/ server performance constants / query execution
plans / multi-location tables / trace flags
|
|
|
|
Day 2 |
| Chapter 4 |
Ingres
Configuration System |
| |
Configuration-by-Forms (cbf) / configuration repository / derivation
rules / named configurations / parameter types / customizing derivation
rules |
| Chapter 5 |
Concurrency and
Locking |
| |
locking
system architecture / ANSI isolation levels / deadlock and livelock /
locking granularity / row-locking requirements / row-locking
implications / lock modes / measuring and controlling escalation /
configuration parameters / measuring running system / calculating
optimal settings / implementing
configuration changes
|
|
|
|
Day 3 |
| Chapter 6 |
Logging and
Recovery |
| |
logging
system architecture / Ingres II enhancements / physical logging /
physiological logging / recovery server / archiver / transaction log
implementation / consistency points / fast-commit
servers / recovery operations / undo recovery / redo
recovery / configuration parameters / measuring running system /
calculating optimal settings / implementing configuration changes
|
| Chapter 7 |
Server Tuning
|
| |
operating
system environment / multithreaded servers / native thread servers /
utilizing multiprocessor systems / I-O slave implications / multi-server
configurations / custom server classes /
buffer manager organization / variable page sizes / server
log files / generating and analyzing summary reports / troubleshooting
and diagnostics / trace points and measurement tools / configuration
parameters / measuring running system / calculating
optimal settings / implementing configuration changes
|
|
|
|
Day 4 |
|
|
|
Day 5 |
| Chapter 8 |
I/O System Tuning
|
| |
Ingres
locations / space requirements / throughput requirements / measuring
relative disk load / queue length / response time / I-O load balancing
|
| Chapter 9 |
Memory System
Tuning |
| |
memory
system tuning / virtual memory / shared memory / page
faulting / Ingres memory usage / tuning strategies
|
|
Contact us
 |
|
|
Discounts are available for large
blocks of training or training credits bought at once. Contact us for
details. |
|
