The Informix Internal Architecture training course is intended for experienced Informix System Administrators interested in advancing their troubleshooting and monitoring skills. In this course, you will learn advanced skills for monitoring and analyzing various structures within an Informix environment. You will be presented with detailed information about the architecture of dbspaces, blobspaces, sbspaces, and their various components down to the page level. You will also learn more about virtual processors and how to monitor thread activity. You will learn more about shared memory components and how memory pools are designed and used. Finally, you will learn more in-depth details about various Informix processes, including checkpoints, physical and logical logging, and fast recovery.
By attending Informix Internal Architecture workshop, delegates will learn to:
- Identify the elements of an Informix Dynamic Server page
- Define the terms that identify the elements of a dbspace
- List and describe the root dbspace reserved pages
- Explain the purpose of the tblspace tblspace and identify the elements of a partition page
- Explain the purpose of Informix Dynamic Server tblspaces
- List and describe the types of index node pages and their components
- Explain the architectural differences between fragmented and non-fragmented tables and indexes
- Describe the components of blobspaces and sbspaces
- Explain how virtual processors and threads are used in a database server
- Describe how data is stored and managed in shared memory
- Explain how the physical and logical log files are used in the fast recovery process
- 3-6 months experience as an Informix Dynamic Server administrator is required.
This Informix Internal Architecture class is for Informix System Administrators.