IBM Informix Course Details

IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings. The Informix products were originally developed by Informix Corporation, whose Informix Software subsidiary was acquired by IBM in 2001.

Syllabus:

Overview of IBM Informix Dynamic Server
IBM Informix Dynamic Server
System Architecture
Informix Components

Preparing for Installation & Configuration
Configuring the Operating System
Configuring Windows Memory
Modifying UNIX Kernel Parameters
Allocating Disk Space
Creating Chunk Files on UNIX
Raw or Unbuffered Disk Access
Cooked Files
Setting Permissions, Ownership, and Group
Creating Standard Device Names
Setting Environment Variables
Setting Environment Variables on UNIX
Setting Environment Variables on Windows
Configuring Connectivity
The sqlhosts File on UNIX
Network-Configuration Files
Network-Security Files
The sqlhosts Registry on Windows
Configuring Connectivity Using ISA

Configuring Client-Server connectivity
Client/Server Architecture
Network Protocol
Network Programming Interface
Connections That the Database Server Supports
Local Connections
Shared-Memory Connections
Connectivity Files
Network-Configuration Files
TCP/IP Connectivity Files
Multiple TCP/IP Ports

Configuring a Database Server
Preparing space for data storage
Raw Chunks
Cooked Chunks
Setting Environment variables
Sqlhosts file
Onconfig file
Server initialization
Server status
Server Message Log

Monitoring Database Server
Monitoring Utilities
SMI
Sysmaster database
How SMI works
Sysmaster tables and Views
Onstat sysntax
Onstat Options
Oncheck syntax
ISA

Managing Shared Memory
Server Operating Modes
Normal Server Processes
Setting Database Server Shared-Memory Parameters
Setting Parameters for Resident
Setting Parameters for Virtual Shared
Setting Parameters for Shared-
Setting Shared-Memory Parameters
Setting Shared-Memory Parameters
Setting Shared-Memory Parameters
Reinitializing Shared Memory
Changing Server Modes
UNIX Level Shared Memory

Virtual Processors and Threads
What Is a Virtual Processor?
What Is a Thread?
What Is a User Thread?
Types of Virtual Processors
Advantages of Virtual Processors
Sharing Processing
Saving Memory and Resources
Processing in Parallel
Adding and Dropping Virtual Processors
On-Line Mode
Binding Virtual Processors to CPUs

Disk Architecture
Physical Disk Space
Logical Disk Space
Database
DBspace
Tables
Extents
Pages
Logical Log Files
Physical Log Files

Managing and Monitoring Disk Space
Creating a Dbspace with onspaces
Creating a Blobspace with onspaces
Dropping Spaces with onspaces
Adding a chunk to dbspace
Dropping a chunk from dbspace
Renaming Dbspace
Managing Spaces with ISA

Physical and Logical Logging
Log Initialization
Changing the Physical Log
Adding a Logical Log
Dropping a Logical Log
Switching Logical Log
Changing Database Logging Modes
Monitoring Logs
Long Transactions
Dynamic Allocation of Locks

Introduction to Backup and Restore
What Is a Recovery System?
What Is a Backup?
What Is a Logical-Log Backup?
When You Do Not Use Logging . . . . . . . . .
What Are Manual and Continuous Logical-Log Backups?
What Is a Log Salvage?
Why You Need to Save Logical-Log Backups
What Is a Restore?
What Are Warm, Cold, and Mixed Restores?
What Are Physical and Logical Restores?
Comparing ON-Bar and ontape
Planning a Recovery Strategy
What Types of Data Loss Can Occur?
Scheduling Backups
Planning a Backup System for a Production Database Server
Evaluating Hardware and Memory Resources
Evaluating Backup and Restore Time

Backup and Restore methods
Physical Backup Methods
Logical Backup Methods

User activity
Monitoring User Activity
Session Information
SQL Information
Deadlocks
Monitoring Locks
Table Locks
Row Lock

Performance Features
Parallel Data Query
Read-Ahead
SQL Cache
ONCONFIG Parameters
ENV Variables

Troubleshooting
Common Problems
Chunk Permissions and Ownership
Shared Memory Allocation
Long Transactions
Freeing Logs
Consistency Check errors

Last modified: Wednesday, 10 August 2016, 4:00 AM