IBM - Other Courses

logo

Tailored to Needs

Call Us: 01225 339705 Email: This email address is being protected from spambots. You need JavaScript enabled to view it. Address: Verhoef Training, 11 Kingsmead Square, Bath, BA1 2AB

  • Register


Audience

This intermediate course is for database and system administrators.

Dates (Bath):

3 Apr 2018

8 Oct 2018

Click for details & booking.

Also available on your site, please call for details.

Prerequisites

You should have:

  • Experience with administration of other relational database management systems
  • Experience with UNIX/Linux operating systems


Duration

4 days.


Objectives

In this course, you will use your experience with other relational database management systems as a basis for learning how to administer the Informix database server. You will learn the terminologies used to describe Informix database server objects and processes. You will learn how to configure and start an Informix database server instance, and perform tasks related to the monitoring and maintenance of the instance. You will also learn the terminology and tasks required to design and maintain Informix databases and queries.


Topics

Configure and initialize an Informix database instance
Add and remove spaces and chunks
Manage the operating mode of the database server
Monitor server activity
Create and alter database objects
Explain locking granularity
Explain Informix isolation levels
Use SET EXPLAIN to obtain a query plan
Use UPDATE STATISTICS to better define data distribution
Create simple stored procedures and triggers

S5 Box

Login

Register