Informix

About Informix

AlBright is the right choice for your clientele needs, that could meet up your day to day requirements in this global market. We also specialize in providing training services on hardware, networking, database management, security and storage management. We teach students and train them for IT profession. Also, we help re-skilling IT professionals for better job performance.

 

What are the objectives and learning outcomes of this Informix course?

This course will teach the student the basic concepts of data management within IDS. It discusses how to determine correct data types; how to create, manage and maintain tables and indexes; how the IDS optimizer works; how to manage data; and how to utilize the SET EXPLAIN feature to determine query effectiveness. In this course, students will learn to write procedures, functions, and triggers using the Informix stored procedure language. This course has been designed in such a way that it is very easy for you to acquire and expand your IBM Informix skills quickly. So, you can start working in this field once you complete the training successfully.

 

Who should do this Informix course?

IBM Informix is being used by most of the world’s top multinationals. IBM Informix professionals are earning very high salaries when compared with other technologies.With high demand and a number of job opportunities in this field, the following people will get benefited from this course
Database Administrators
Applications Developers

 

What are the prerequisites for this Informix course?

A working knowledge of Structured Query Language (SQL)

 

Why this Informix Course?

Avg. Salary for IBM Informix Developer: $ 79,200 PA.
IBM Informix has a market share of about 1.6%
Used by top industries across various business Verticals. Ex: Porto Seguro, ADT, OpenBet…etc.

 

Scope of Informix:

The Company Our client is a fast paced and demanding sourcing office with global operations. They now have an exciting opportunity for a Product Developer to be based in their Shanghai office, as part of the wovens team . Product Developer – The Role:…Magento Developers Required in Manchester for UK’s Largest multi-channel retailer of DIY and Home Improvements Magento 1 and 2 / MySQL / OOP PHP / CSS / HTML / JavaScript I wondered if I might be able to interest you in a new Permanent opportunity…
What is the future of Informix Database?
The trends suggest that Informix is ranked near the bottom of the RDBMS market. It was acquired by IBM in 2001, but has lost most of its market share since then…

 

Certification:

The certification available for IBM Informix is known as IBM Certified System Administrator – Informix 12.10.

 

Informix Course Outline

IBM Informix Dynamic Server

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
  • 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

Informix Training Reviews

Online Training Reviews given by our students already completed the training with us. Please give your feedback as well if you are a student.