IBM

Informix System Administration

Course Code: 846SW (Also known as: 846SWGB)      Days: 4
Show all IBM Courses
Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.

Course Overview

In this course you will develop the skills necessary to administer one or more database servers. You will learn how to configure and initialise a database server instance, configure and test client connectivity, configure and manage memory and disk usage, pland and implment system maintenance tasks and configure the server for optimal Online Transaction Processing (OLTP) or Decision Support.

Prerequisites

  • Use of Unix file system and vi editor - basic vi commands only are necessary or Windows file sytem
  • Knowledge of Unix administration would also be useful.
  • We recommend that you attend the following course or have the equivalent knowledge, but the Informix Database Administration course is not mandatory:
  • Informix Relational Database Design (611)
  • Informix SQL Part 1 (613)
  • Informix Database Administration - UPDATED to include V10 (848)

Course Outline

  • System architecture
  • Preparing for configuration
  • Configuring client-server connectivity
  • Configuring a database server
  • Monitoring the dynamic server
  • Mangaging shared memory
  • Virtual processors and threads
  • Disk architecture
  • Managing and monitoring disk
  • Physical and logical logging
  • Shared memory buffer pool
  • Fault tolerance
  • Introduction to backup and restore
  • Using ontape
  • Temporary files and tables
  • Performance features
  • Monitoring user activity
  • Event Alarms
  • Troubleshooting


How to make a booking for the 846SW course

 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership