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
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