Informix Server System Administration Module (CFG-TC02)

about this course

The Informix Dynamic Server System Administration training is a 2 days course which is ideal for those candidates who are responsible in managing the day to day database activities and housekeeping activities.The Informix Dynamic Server System Administration training is a 2 days course which is ideal for those candidates who are responsible in managing the day to day database activities and housekeeping activities.

This course is intended for those of you who are interested in advancing their troubleshooting monitoring and managing their database skills. In this course, you will learn skills for monitoring and analyzing various structures within an Informix Dynamic Server environment.

course objectives

Upon completion of this course of this course you should be able to:

  • Describe the major components of IBM Informix Dynamic Server and define database server terms.Describe the major components of IBM Informix Dynamic Server and define database server terms.Methods to connect to the database server.
  • Perform chunk management for server disk storage and page structure.  Create and drop dbspaces, blobspaces and sbpspaces, change the status of a mirrored dbspaces and monitor dbspaces, blobspaces and sbspaces.
  • Explain the purpose of configuration file.
  • Describe the use of the system monitoring about the database server, space usage and the status of indexes and tblspaces.

target audience

Database Administrator for Century Financials System .

course outline

Day 1

Introduction

Overview of Informix Dynamic Server
System ArchitectureVirtual Processes
Shared Memory Components
Physical & Logical Log Buffers

Managing & Monitoring Disk Space
Dbspace, Tblspaces & Blobspaces
Chunks , Pages & Mirroring
Data Caching
Checkpoints
Creating & Dropping spaces on onspaces
Adding new chunks

Managing Shared Memory
Understanding Server Operating Modes
Changing Server Modes
How to restart and bring up Informix
How to perform startup & shutdown
Understanding Monitoring Utilities
Understanding Shared Memory Segments

Day 2

Managing Physical & Logical Log
Initializing , Adding & Dropping logs
Database Logging Mode Monitoring Logical Log Management
Usage of Logical Log & Logical Log Backup
Monitoring Column Flag Status

Informix Restore & Backup
Backup & Restore Process
Incremental Backup Levels
Warm & Cold Restore
Informix Backup & Restore Utilities

Monitoring User Activities
Benefits of Housekeeping
What sort of housekeeping should be carried out
Monitoring and Managing File space utilization
Frequency of file system backup
Listing out and clearing hanging process

Administrative Details
  • Course Fee
    RM 1,802 / pax (incl. SST)
  • Duration
    2 Days
  • Lunch and refreshment provided

Download Brochure

How can we help you?

Contact us or e-mail us today and we will get in touch with you on your inquiry.

The training was well organized and the trainer presented it very clearly. He was able to explain in simple terms for all the newbies to understand the system

Fazid Ahmad

Interested in Training Programs?