Visão Geral

No Curso Informix System Administration, você desenvolverá as habilidades necessárias para administrar com sucesso um ou mais servidores de banco de dados Informix. Você aprenderá como configurar e utilizar uma instância de servidor de banco de dados, configurar e testar a conectividade do cliente, configurar e gerenciar o uso de memória e disco, planejar e implementar tarefas de manutenção do sistema e configurar o servidor para processamento ideal de transações on-line (OLTP) ou suporte a decisões ( DS) utilização.

Objetivo

Ao participar do Curso Informix System Administration, os participantes aprenderão a:

• Descrever os componentes de um servidor de banco de dados
• Configurar e inicializar um servidor de banco de dados
• Configure o servidor para permitir conexões locais e remotas
• Use utilitários de servidor dinâmico para monitorar a atividade do servidor
• Descrever os componentes da memória compartilhada e configurar os tamanhos dos componentes
• Liste, descreva e configure as diferentes classes de processadores virtuais
• Identifique os componentes da arquitetura de disco do servidor de banco de dados
• Crie dbspaces, blobspaces e sbspaces e adicione pedaços a esses espaços
• Explicar a finalidade dos logs físicos e lógicos e monitorar a atividade dos logs
• Visualize as transações individuais gravadas nos arquivos de log lógico
• Descreva a importância dos pontos de verificação no servidor
• Descreva a importância da recuperação rápida
• Execute backups do servidor de banco de dados e logs lógicos
• Use métodos diferentes para restaurar um servidor de banco de dados a partir de um backup
• Explique a finalidade dos espaços temporários usados ​​pelo servidor
• Configure o servidor de banco de dados para operar com mais eficiência usando operações paralelas
• Monitore os recursos usados ​​por sessões de usuários individuais
• Configure o servidor para responder a eventos específicos executando um programa de alarme
• Use comandos SQL para executar funções administrativas e agendar tarefas
• Use várias técnicas de solução de problemas para identificar e resolver problemas comuns

Publico Alvo

Esta classe de Administração de Sistema Informix destina-se a Administradores de Sistema Informix, Administradores de Banco de Dados Informix e Desenvolvedores de Aplicativos Informix.

Pre-Requisitos

Os alunos deste curso devem satisfazer os seguintes pré-requisitos:

•  Conhecimento de Linguagem de Consulta Estruturada (SQL)
• Conhecimento de dbaccess
• Experiência no uso de funcionalidades básicas do Linux
• Experiência no uso do editor vi

Materiais

Conteúdo Programatico

Overview of the Informix Database Server

1. • Describe the major components of the Informix Database Server
2. • Define database server terms
3. • Describe major database server events

Preparing for configuration

1. • Review the contents of the release notes
2. • Identify the kernel parameters that must be set
3. • Determine operating system patches that must be applied

Configuring client-server connectivity

1. • List the methods to connect to the database server
2. • Make appropriate entries into the sqlhosts file
3. • Set the environment variables necessary for a client application to connect to the database server

Configuring a database server

1. • Create cooked files or prepare raw devices for server disk storage
2. • Set environment variables necessary to administer a database server
3. • Explain the purpose of the configuration file
4. • Identify basic configuration parameter settings required to bring up a simple database server
5. • Use a text editor to modify the configuration file
6. • Bring the database server online

Monitoring the database server

1. • Describe the use of the SMI (System Monitoring Interface)
2. • Connect to the sysmaster database and run simple SQL queries
3. • Use onstat to monitor information about the database server
4. • Use oncheck to gather information about space usage and the status of indexes and tblspaces

Managing shared memory

1. • List and describe the database server operating modes
2. • Use onmode and oninit to change the operating mode
3. • Describe the shared memory segments used by the database server
4. • Describe the configuration parameters that affect the size of shared memory
5. • Set the RESIDENT parameter to control shared memory residency
6. • Monitor the major components of shared memory

Virtual processors and threads

1. • Define a thread
2. • Describe the multithreaded architecture
3. • Describe how the virtual processors are implemented in Unix
4. • Use onstat to monitor VPs and threads
5. • List and explain the virtual processor classes
6. • Describe how network connections are handled by the server
7. • Set server configuration parameters related to VPs and threads
8. • Dynamically add and remove virtual processors

Disk architecture

1. • Describe the Dynamic Server page and chunk structure
2. • Explain how pages are allocated within extents
3. • Explain the difference between table and index extents
4. • Describe the relationship between chunks and dbspaces
5. • Describe the overhead pages in various types of chunks
6. • Describe the structure of a dbspace, blobspace, and sbspace
7. • Use the oncheck command to display reports about space allocation, tblspace usage, and index usage
8. • Use onstat to display dbspace and chunk information

Managing and monitoring disk space

1. • Create and drop dbspaces, blobspaces, and sbspaces
2. • Change the status of a mirrored dbspace
3. • Monitor dbspaces, blobspaces, and sbspaces
4. • Use the storage pool and the APIs to administer storage spaces

Physical and logical logging

1. • Move the physical log to a plogspace
2. • Add, drop, and modify logical logs
3. • Change the logging mode of a database
4. • Define a long transaction
5. • List and describe configuration parameters related to physical and logical logging
6. • Monitor the physical and logical logs

The shared memory buffer pool

1. • List the steps performed by the server to update a row on disk
2. • Describe the checkpoint process
3. • Describe the differences between a blocking and a nonblocking checkpoint
4. • Properly set the configuration parameters related to checkpoints
5. • Describe what events cause a checkpoint to occur
6. • Monitor checkpoints and buffer writes performed by the server

Fault tolerance

1. • Describe the types of failures that could occur on the server system
2. • Describe the fast recovery process
3. • Examine the status of chunks and dbspaces
4. • Identify the configuration parameters associated with recovery

Introduction to backup and restore

1. • Identify Informix backup and restore utilities
2. • Explain the backup and restore process
3. • Explain the incremental backup levels
4. • Explain the two different methods to backup logical logs
5. • Describe the difference between a warm and cold restart

Backup and restore using ontape

1. • Configure your server to use ontape for backup and restore
2. • Perform a server backup using ontape
3. • Backup logical log files using ontape
4. • Perform a warm restore using ontape

Temporary files and tables

1. • Describe the temporary objects created by the database server
2. • Describe the configuration parameters and environment variables related to temporary objects
3. • Explain the importance of using multiple temporary dbspaces
4. • Explain the purpose of the WITH NO LOG clause when used to create temporary tables
5. • Use onstat and the SMI to monitor the space used to create temporary objects

Performance features

1. • Configure your server to perform read-aheads
2. • Configure your server to use recovery threads
3. • Configure your server to enable or disable the use of OS time
4. • Describe the PDQ operations available in the database server
5. • Describe configuration parameters that control PDQ resources
6. • Configure your server to use the SQL statement cache

Monitoring user activity

1. • Use onstat and the sysmaster database to monitor user activity on the database server
2. • Identify the resources held by a user session
3. • Display the last SQL command run by a user session
4. • Identify which user sessions have created temporary tables
5. • Describe how to identify the type of locks held by user sessions
6. • Identify and terminate a specific user session
7. • Explain the purpose of the dynamic lock manager

Event alarms

1. • Explain how to use the event alarm feature
2. • List the event security codes
3. • List the classes of alarm events in the server environment
4. • Explain the purpose of the system alarm program
5. Unit 19 SQL administrative functions and task scheduler
6. • Use SQL commands to perform system administrative tasks
7. • Use the built-in scheduler to automatically perform routine tasks

Troubleshooting

1. • Identify and respond to common server problems
2. • Run the commands to check for consistency of the disk subsystem
3. • Identify the version and serial number of the database server
4. • Identify permission problems with devices and server files
5. • Describe the information required by Technical Support
6. • Describe the parts of a database version number
7. • Recover from a simple permission or data storage location problem in the server