|
If you are knowledgeable with
Informix Dynamic Server Version 7 and are capable of performing the
intermediate to advanced skills required in the day-to-day administration of
Informix databases, you may benefit from this certification
role. Section 1 - Informix Dynamic Server Concepts, Terminology and Disk
Architecture (18%)
Demonstrate an understanding of the major
components of an Infomrix Dynamic Server system including shared memory and
disk components
Demonstrate an understanding of how Informix Dynamic
Server disk components such as extents, pages, blobspaces, blobpages, reserved
pages, chunks, tblspaces, and dbspaces are used in the Informix Dynamic Server
systemSection 2 - Multi-Threaded Architecture (13%)
Demonstrate an
understanding of the multi-threaded architecture including virtual processor
and virtual processor classes
Enable a connnection to Informix Dynamic
Server using appropriate system files and environment variablesSection 3 - Configuring and Monitoring Informix Dynamic Server
(24%)
Demonstrate an understanding of those areas of Informix
Dynamic Server system that should be monitored
Use Informix Dynamic Server
configuration parameters to configure the Informix Dynamic Server system
Use onstat, oncheck, and onperf to monitor the Informix Dynamic Server
systemSection 4 - PDQ (6%)
Demonstrate an understanding of PDQ
operations and the parameters and utilities used to monitor and tune itSection 5 - Mode Management (4%)
Demonstrate an
understanding of the modes of the Informix Dynamic Server system and the
utilities used to manipulate Informix Dynamic Server modesSection 6 - Server Operations (5%)
Demonstrate an
understanding of Informix Dynamic Server operations including how data is read
from and wrtten to disk, the checkpoint process, buffer writes, and LRU
queuesSection 7 - Fault Tolerance (3%)
Demonstrate an
understanding of how fast recovery and mirroring are usedSection 8 - Log Management (11%)
Manage logical and physical
logsSection 9 - Temporary Files, Tables and Dbspaces (4%)
Manage
temporary files, tables and dbspacesSection 10 - Event Alarms (2%)
Demonstrate an understanding
of event alarmsSection 11 - Troubleshooting Informix Dynamic Server (5%)
Troubleshoot common Informix Dynamic Server problems such as insufficient
kernel configuration, insfficient shared memory, incorrect chunk permissions
and ownership, inadequately allocated tomporary space, incorrect sqlhosts file
entries, long transactions, full logical logs, and disk space shortageSection 12 - Archive and Restore Process (4%)
Demonstrate an
understanding of the archive and restore process including incremental archive
levels, methods for backing up logical logs, and warm vs. cold restores
Use the ontape and onlog utilities to manage the archive and restore process
and logical logsSection 13 - Two-Phase Commit Protocol (1%)
Demonstrate an
understanding of the two-phase commit protocol and distributed
transactions
|
