Informix

Reading Time: 3 minutes

IBM Informix Dynamic Server

Module 1: Overview of IBM Informix Dynamic Server

IBM Informix Dynamic Server
System Architecture
Informix Components

Module 2: 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

Module 3: 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

Module 4: 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

Module 5: Monitoring Database Server

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

Module 6: 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

Module 7: 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

Module 8: Disk Architecture

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

Module 9: 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

Module 10: 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

Module 11: 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 ontap
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

Module 12:Backup and Restore methods

Physical Backup Methods
Logical Backup Methods

Module 13: User activity

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

Module 14: Performance Features

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

Module 15: Troubleshooting

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