IBM Informix Dynamic Server
- Module 1: Overview of IBM Informix Dynamic Server
- IBM Informix Dynamic Server
- System Architecture
- Informix Components
- 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
- 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
- Preparing space for data storage
- Raw Chunks
- Cooked Chunks
- Setting Environment variables
- Sqlhosts file
- Onconfig file
- Server initialization
- Server status
- Server Message Log
- Monitoring Utilities
- SMI
- Sysmaster database
- How SMI works
- Sysmaster tables and Views
- Onstat sysntax
- Onstat Options
- Oncheck syntax
- ISA
- 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
- 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
- Physical Disk Space
- Logical Disk Space
- Database
- DBspace
- Tables
- Extents
- Pages
- Logical Log Files
- Physical Log Files
- 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
- 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
- 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
- Physical Backup Methods
- Logical Backup Methods
- Monitoring User Activity
- Session Information
- SQL Information
- Deadlocks
- Monitoring Locks
- Table Locks
- Row Lock
- Parallel Data Query
- Read-Ahead
- SQL Cache
- ONCONFIG Parameters
- ENV Variables
- Common Problems
- Chunk Permissions and Ownership
- Shared Memory Allocation
- Long Transactions
- Freeing Logs
- Consistency Check errors
Module 2: Preparing for Installation & Configuration
Module 3: Configuring Client-Server connectivity
Module 4: Configuring a Database Server
Module 5: Monitoring Database Server
Module 6: Managing Shared Memory
Module 7: Virtual Processors and Threads
Module 8: Disk Architecture
Module 9: Managing and Monitoring Disk Space
Module 10: Physical and Logical Logging
Module 11: Introduction to Backup and Restore
Module 12:Backup and Restore methods
Module 13: User activity
Module 14: Performance Features
Module 15: Troubleshooting