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