Informix

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