IBM INFORMIX DBA ONLINE TRAINING

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