|
This course is for experienced database administrators, programmers,
and technical support personnel who will be setting up, managing,
and tuning IBM Informix IDS 11, 10, 9 or 7 databases. This is a four-day
course covering the topics listed below.
Database Development
- Creating tables, indexes, and databases
- Calculating table and database sizes
- Implementing referential integrity
- Controlling data security
- Using the IBM Informix system tables
IBM Informix OnLine Configuration
- Understanding the OnLine Dynamic Server architecture
- Configuring and initializing OnLine
- Configuring disk space for databases
- Configuring shared memory parameters
- Configuring virtual CPUs
- Configuring network and client/server connections to databases
- Changing OnLine operating modes
- Configuring multiple database servers
IBM Informix OnLine Operations
- Monitoring and operating OnLine
- Backing up OnLine databases
- Recovering OnLine databases
- Managing concurrence control
- Managing transaction logs
- Managing fault tolerance systems
- Using the OnLine utilities
- Using the System Monitoring Interface (sysmaster database)
- Using data load utilities
IBM Informix OnLine Optimization
- Analyzing OnLine performance and system activity
- Using the graphical monitoring tools (Oncockpit and Onperf)
- Understanding the query optimizer
- Optimizing performance with indexes
- Optimizing disk and database space layout
- Managing memory and CPU resources
Prerequisites:
Requires a basic understanding of UNIX and vi commands and SQL
databases.
Costs: $2,000 per person
|
