study overseas chennai +91 - 44 - 42115338
+91 - 9884987719 (Adyar)
+91 - 7550245795 (Velachery)
it training institutes in chennai job openings in chennai
Informix

Informix

Global Certification

:

IBM CERTIFIED 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

:

HB Educational Services, 39/40, 1st Main Road, Gandhi Nagar, Adyar, Chennai-20 HB Educational Services, 2/189, 2nd Floor,100 Feet Road, Vijayanagar, Velachery, Chennai-42

Target Audience

  • Database administrators
  • Database SQL developers
  • Database users

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.

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

Pre-Requisites

:

Graduates (any discipline) /BCA /MCA/ B.E/ Diploma Holders with good communication skills

Participant Fee

:

On Request

Please reach our Adyar Center @ +91-44-42115338, or 91-9884987719 (Whatsapp & Call Support)

Please reach our Velachery Center @ +91-7550245795 (Whatsapp & Call Support)

Live Chat Business

_+

Live Chat Business