Goals
- Perform any schemas and queries on Informix
- Describe the multi-tasking architecture IBM Informix Dynamic Server
- Install, maintain, administer and optimize an IDS server
Program
History, versions and licenses
Choice of platform (Windows / Unix or other)
Internal architecture of an Informix server
Installation Configuration
parameters
Configure an IBM Informix Dynamic Server database
Instance modes
Access principles
Configure Client-Server connectivity
Virtual Processors
Shared memory
Disks, chunks and tablespaces
Tables, views, indexes and schemas
SQL language; Informix standards and features
Multiple joins, stored procedures
Storage structures (raw device)
Management of dbspaces
Handling of chunks
Tables and temporary files
Users and security: authentication modes, accounts, roles, permissions
Various automation of administration tasks
Physical Logging
Logging activity
Logging logical
structure and logical log backup
utility onlog
Backup planning
Restoration strategy
Available tools:
* Ontape: configuration, backup, restore
* Onbar: configuration, verification, backup, restore
Manage and optimize index constructions and sorting space
Monitoring user activity
Event alarms
Incident management (Troubleshooting)
Duration
5 days
Price
£ 2435
Audience
Database administrators
Prerequisites
System administration concepts
Reference
BAS100548-F
Sessions
Contact us for more informations about session date