IICT provides 100% real-time, practical and placement focused Informix Training in thirumazhisai. Our Informix course concentrates from basic level training to advanced level training. Our Informix Training in completely focused to get placement in MNC in thirumazhisai and certification on Informix after completion of our course. Our team of Informix trainers are Informix certified professionals with more real-time experience in live projects. Our Informix Course syllabus is enough for anyone who wants to get Informix certification which meets industry expectations. In our course plan, you will learn Overview of IBM Informix Dynamic Server, Preparing for Installation & Configuration, Configuring Client-Server connectivity, Configuring a Database Server, Monitoring Database Server, Managing Shared Memory, Virtual Processors and Threads, Disk Architecture, Managing and Monitoring Disk Space, Physical and Logical Logging, Introduction to Backup and Restore, Backup and Restore methods,User activity, Performance Features, Troubleshooting, HDR Concepts (Database replication) with live examples in practical manner.
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 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
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