+91 8142000093 info@tanviinfo.com

Informix

TIS_Informix

Informix

Course Duration : 40 Hours
Course Delivery : Classroom, Online, Weekends

Course Content

Overview of IBM Informix Dynamic Server
• IBM Informix Dynamic Server
• System Architecture
• Informix Components
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
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
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
Monitoring Database Server
• Monitoring Utilities
• SMI
• Sysmaster database
• How SMI works
• Sysmaster tables and Views

• Onstat sysntax
• Onstat Options
• Oncheck syntax
• ISA
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
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
Disk Architecture
• Physical Disk Space
• Logical Disk Space
• Database
• DBspace
• Tables
• Extents
• Pages
• Logical Log Files
• Physical Log Files
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
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
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

Backup and Restore methods
• Physical Backup Methods
• Logical Backup Methods
User activity
• Monitoring User Activity
• Session Information
• SQL Information
• Deadlocks
• Monitoring Locks
• Table Locks
• Row Lock
Performance Features
• Parallel Data Query
• Read-Ahead
• SQL Cache
• ONCONFIG Parameters
• ENV Variables
Troubleshooting
• Common Problems
• Chunk Permissions and Ownership
• Shared Memory Allocation
• Long Transactions
• Freeing Logs
• Consistency Check errors
HDR Concepts (Database replication)
Case Studies