Session : 1 – Overview of IBM Informix Dynamic Server
- IBM Informix Dynamic Server
- System Architecture
- Informix Components
Session : 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
Session : 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
Session : 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
Session : 5 – Monitoring Database Server
- Monitoring Utilities
- SMI
- Sysmaster database
- How SMI works
- Sysmaster tables and Views
- Onstat sysntax
- Onstat Options
- Oncheck syntax
- ISA
Session : 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
Session : 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
Session : 8 – Disk Architecture
- Physical Disk Space
- Logical Disk Space
- Database
- DBspace
- Tables
- Extents
- Pages
- Logical Log Files
- Physical Log Files
Session : 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
Session : 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
Session : 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 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
Session : 12 – Backup and Restore methods
- Physical Backup Methods
- Logical Backup Methods
Session : 13 – User activity
- Monitoring User Activity
- Session Information
- SQL Information
- Deadlocks
- Monitoring Locks
- Table Locks
- Row Lock
Session : 14 – Performance Features
- Parallel Data Query
- Read-Ahead
- SQL Cache
- ONCONFIG Parameters
- ENV Variables
Session : 15 – Troubleshooting
- Common Problems
- Chunk Permissions and Ownership
- Shared Memory Allocation
- Long Transactions
- Freeing Logs
- Consistency Check errors
Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.