|
Synopsis |
A 2-day class in Ingres operations and system administration.
Includes a review of the architecture of Ingres, installation issues, disk
planning, and management of the Ingres environment. |
 Customers in the US/Canada should
contact KB
Computer Associates to schedule this course |
|
Ingres Version |
All versions (6.x, OI 1.x, OI 2.x, II, r4, 2006,
9.2) |
|
|
Duration and Cost |
2 day, £700 / $1,030USD / €760, 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 |
ISA |
|
|
Prerequisites |
Some familiarity with database concepts and an
operating system such as Linux, Unix, W2K/W2K3, or OpenVMS. Some previous experience
in the role of a DBA would be beneficial, but not essential.
This course should typically be taken before the
3-day Ingres Database Administration course. |
|
|
Outline
Day 1 |
| Chapter 1 |
Ingres
Architecture |
| |
server
processes / client-server architecture / directory structure / name
server / archiver / recovery server / star / starting & stopping an
Ingres installation / iinamu / starting processes individually / the
locking system / lock resources / logging system / log records & log
buffers / group commit / transaction log file / fast commit /
consistency points / journaling |
| Chapter 2 |
Installing Ingres |
| |
an Ingres
installation / installation identifiers / database installations /
client installations / cluster installations / STAR installations /
installation planning / ANSI/ISO SQL92 compliance / disk usage / Ingres
areas / traffic patterns / reliability / disk space / recommended disk
configurations / installing on Unix, W2K/W2K3 and OpenVMS / installing
upgrades and patches / reversing patches |
| Chapter 3 |
Ingres System
Maintenance |
| |
starting and
stopping Ingres processes / system
backups / checking processes / IVM / file sizes / error logs / archiver
exit script / error messages explained / directory structure /
creating new areas and locations / extending a database / auxiliary work
locations / relocating databases / the master database / re-initializing
the transaction log |
|
|
|
Day 2 |
| Chapter 4 |
Configuration |
| |
configuration repository / configuration parameters / configuration
editors / configuration rules / tuneable parameters listing: DBMS server
- DMF cache - locking - logging |
| Chapter 5 |
Monitoring Ingres |
| |
iinamu /
iinamu commands / manually registering a server / iimonitor / iimonitor
commands / logstat / lockstat / ipm / rpcstat / VDBA / using VDBA
|
| Chapter 6 |
Ingres Management
Architecture (IMA) |
| |
IMA
/ MIB objects /imadb database / IMA tables / monitoring cache
utilization / diagnosing blocked lock requests / monitoring trends /
using IMA to write utilities |
|
Contact us
 |
|
|
Discounts are available for large
blocks of training or training credits bought at once. Contact us for
details. |
|
