Introduction
- List topics to be covered in this course
- Describe basic Informix Dynamic Server terminology
- Explain basic processes performed within the server
The Dynamic Server Page
- Describe the basic layout of a Dynamic Server page
- Identify and describe the components of a page header
- Explain the purpose of a slot table
- Use the oncheck utility to view IDS pages
Dbspace Layout
- Describe the layout of a Dynamic Server chunk
- Describe the contents of the reserved pages
- Explain the purpose of a chunk free-list page
- Describe the structure of a partition page
- Identify the elements of a partition number (partnum)
- Describe the structure of physical and logical log pages
Tblspaces
- List and describe the elements of a tblspace
- Explain the purpose of the database tblspace
- Explain the purpose of the bitmap page
- Explain the purpose of rowids
- List and describe various types of tblspace pages
Index Architecture
- Describe the elements of a B-tree
- Describe the elements of an index node page
- Explain how key values are stored on an index page
- Use oncheck commands to view index node pages
Fragmented Tables and Indexes
- Use system catalogs to locate fragment partition numbers
- Display pages from a fragmented index
- Display pages from a fragmented table
Blobspaces
- Describe the layout of a blob chunk
- Identify and describe the elements of a blobpage map page
- Explain the meaning of a blobpage address
- Use oncheck to view a blobpage
- Describe how blobspace blobpages are logged and archived
- Compare the advantages of storing blobs in a blobspace versus storing blobs in a dbspace partition
Sbspaces
- Identify and describe the elements of an sbspace chunk
- Describe the contents of sbspace reserved pages
- List the tables stored in the metadata area and describe the purpose of each
- Explain how smart large objects information is stored on a data page
- Explain the process used to locate a smart LO
- Monitor sbspaces using the oncheck and onstat utilities
Virtual Processors and Threads
- List the components of a thread
- Monitor thread activity using onstat and the sysmaster tables
- Explain how a context switch works
- Explain how mutexes and conditions are used
Shared Memory Architecture
- Describe how a process attaches to shared memory
- Explain the internal structure of Informix Dynamic Server shared memory
- Use onstat to monitor the usage of Informix Dynamic Server shared memory
Communications
- Explain the different methods by which a client can communicate to the database server
- Describe the process used by Informix Dynamic Server utilities to communicate to the server
- Explain how Informix Dynamic Server uses semaphores
- Use onstat to monitor Informix Dynamic Server communications
Physical and Logical Logs
- Describe the purpose and contents of the physical log
- Explain the structure of logical logs and log pages
- Use the onlog utility to examine the contents of your logical logs
Agenda
Day 1
Welcome
Unit 1: Introduction
Exercise 1: Configuring and Initializing a Server
Unit 2: The Dynamic Server Page
Exercise 2: Analyzing Page Content
Unit 3: Dbspace Layout
Exercise 3: Dbspace Layout
Day 2
Unit 4: Tblspaces
Exercise 4: Examining Tblspace Pages
Exercise 5: Examining VARCHAR and BYTE data
Unit 5: Index Architecture
Exercise 6: Analyzing Index Pages
Unit 6: Fragmented Tables and Indexes
Exercise 7: Fragmented Tables
Day 3
Unit 7: Blobspaces
Exercise 8: Examining Blobspace Pages
Unit 8: Sbspaces
Exercise 9: Examining Sbspace Pages
Unit 9: Virtual Processors and Threads
Exercise 10: Monitoring Threads
Day 4
Unit 10: Shared Memory Architecture
Exercise 11: Examining Shared Memory
Unit 11: Communications
Unit 12: Physical and Logical Logging
Exercise 12: Physical and Logical Logging
