ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Informix Internal Architecture  (IX911)

Format: Formation en classe avec formateur
Autres formats:
 
 

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

The course is updated for version 11.50 of Informix, but is suitable for those still running previous versions of IDS. This is the Classroom version of Instructor-Led Online course Informix Internal Architecture - Instructor Led Online (3X911) and Self-Paced Virtual course Informix Internal Architecture (Web) (2X911).
 
This Course is Certified By IBM   Flex Training Savings
 

Compétences acquises
 
  • 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

Qui peut en profiter
 

This advanced course is for Informix System Administrators. It is appropriate for students using Informix Growth Edition, Informix Ultimate Edition, Informix Innovator-C Edition, or Informix Ultimate-C Edition.

Préalables
 

You should complete:

  • Informix Dynamic Server Administration (L1846) or (IX810).
  • Having a minimum 3 months experience as an Informix Dynamic Server administrator is required; 6 months of experience is preferred.

Abstract
 

IBM Education Advantage Program Eligibility:

  • Yes - IBM Education Pack - online account
 
Enroll For This Class
Enroll For This Class
DB2 Lotus Tivoli Training Class Ce cours est donné par des formateurs certifiés IBM.

À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.

Il y a une différence. Découvrez-la
Training Class Enrollment Ask A Question About This Training
Code: IX911
Format: Formation en classe avec formateur
Durée: 4 days
Certifié par: IBM
Frais d’inscription (CAD): $contact
TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
No Course Dates Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date.
   
demander la date/l’emplacement demander de la formation sur place
 

Informix Internal Architecture  (IX911) Contenu détaillé
 
 
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


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.		  
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

 Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI