IBM INFORMIX DBA ONLINE TRAINING
ENROLL NOW

Pre-requisites

Basic knowledge on Structured Query Language (SQL).
Introduction to Informix Dynamic Server (IDS) Terminology

  • Define basic Informix Dynamic Server terms
  • Query the sysmaster database for information about the server

 

IDS Installation & Setup

  • Identify the right product
  • Extract & Install the IDS product
  • Setup raw chunks for space
  • Setup Environment
  • ONCONFIG parameter changes
  • SQLHOSTS file changes
  • Instance creation
  • Bounce Informix Server Instance
  • Switching between server modes

 

Managing disk space

  • Physical Units
  • Logical Units

 

Shared memory

  • Resident portion
  • Virtual portion
  • Message portion

 

Monitoring Message log file
Managing configuration parameter file
SMI Tables
Monitor/Manage Database Server activity using tools

  • onstat
  • onmode
  • oncheck
  • onparams
  • onmonitor
  • oninit
  • ondblog
  • onspaces

 

Backing up data and logical log files (ontape, onbar) Data migration tools

  • load/unload
  • dbexport/dbimport
  • onunload/onload
  • dbschema

 

Checkpoints
finder utility Update statistics SET EXPLAIN Database Logging

  • Physical Logging
  • Logical Logging

 

Lock Management Session Management IDS Isolation Levels IDS Data Types

  • Identify the Informix data types
  • Choose the appropriate data type for a data column

 

Creating Databases and Tables

  • Create databases and tables
  • Determine database logging and storage requirements
  • Locate where the database server stores a table on disk
  • Create temporary tables
  • Locate where the database server stores temporary tables
  • Use the system catalog tables to gather information
  • Use the dbschema utility

 

Altering and Deleting Databases and Tables

  • Drop a database
  • Drop a table
  • Alter a table
  • Convert a simple large object to a smart large object

 

Create, Alter, and Drop Indexes

  • Build an index
  • Alter, drop, and rename an index
  • Identify the four index characteristics
  • Managing and Maintaining Indexes
  • Explain the benefits of indexing
  • Evaluate the costs involved when indexing
  • Explain the maintenance necessary with indexes
  • Describe effective management of indexes
  • Enable or disable indexes

 

Table and Index Partitioning

  • List the ways to fragment a table
  • Create a fragmented table
  • Create a detached fragmented index
  • Describe temporary fragmented table and index usage

 

Maintaining Table and Index Partitioning

  • Alter a fragmented table
  • Alter a fragmented index
  • Explain how to skip inaccessible fragments

 

Data Security

  • Use the database, table, and column level privileges
  • Use the GRANT and REVOKE statements
  • Use role-based authorization

 

Views

  • Create views
  • Use views to present derived and aggregate data
  • Use views to hide joins from users

 

Introduction to Stored Procedures

  • Explain the purpose of stored procedures
  • Explain advantages of using stored procedures

 

Triggers

  • Create and execute a trigger
  • Drop a trigger
  • Use the system catalogs to access trigger information

 

 

If you want to know more about IBM INFORMIX DBA ONLINE TRAINING do not hesitate to call +91-7774892805 or mail us on contact@intelogik.com

ENROLL NOW