INFORMIX

Training Overview                          : Understand Teradata’s competitive advantage over other RDBMSs.

Understand Teradata Architecture and Indexing mechanism.

Use SQL to process data stored in Teradata tables.

Use Teradata application utilities to import/export data.

Apply various performance turning techniques to optimize the queries.

Pre-Requisites                                  : Students, Working Professionals and anyone who has basic Computer Knowledge and wants to enter in IT Industry.

Participant Fee                                 : On Request

Global Certification                        : PRINCE INFOTECH APPLICATION DEVELOPER

Exam Code                                         : TEO_556

Training Name                                  : Informix

Description                                        : A relational database management system (DBMS) from IBM that runs on a variety of Unix platforms. Originally developed by Informix Software, Menlo Park, CA, the product was acquired by IBM in 2001. Informix Dynamic Server (IDS) is a venerable database management system that includes a comprehensive variety of application development tools including Informix-4GL and Informix-SQL.

Batch                                                     : Weekdays/Weekends

Training Time                                    :40hrs

Duration                                              : 32hrs

Venue                                                  : No: 96 G.S.T Road Guduvanchery – 603202

 

 

Training 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

we'll one over 5 Years of experience you always the best guidance

GET STARTED