Select Page
Home
5
Training
5
Informix Server System Administration Module (CFG-TC02)

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.

h 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

Database Administrator for Century Financials System

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,590 / pax (incl. SST)

• Duration

2 Days

• Lunch and refreshment provided

How can we help you?

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