|
|
|
 |
IN403Performance Tuning: Informix Dynamic Server (UNIX)
In course practical questions of increase in productivity of your INFORMIX-OnLine Dynamic Server environment are studied. Monitoring and the analysis of activity of system is considered. The question of creation of the distributed data for improvement of statistics of the optimizer is considered. Strategies of a fragmentation and application of hints are studied. In course you learn to carry out optimization and resource management PDQ of the environment. Also loading of the data and indexing is considered.
After learning course you can
- To carry out the analysis of productivity
- To use utilities of monitoring INFORMIX-OnLine Dynamic Server
- To arrange the data
- To define optimal strategies of a fragmentation
- To optimize and control resources for PDQ
- To define strategies of loading of the data and indexings
- To control resources of memory and the central processing unit
Contents of course
- Introduction in tincture of server IDS for rise of productivity
- Resources of monitoring
- Optimization of productivity of loading of the data
- Optimization of construction of indexes
- Questions of productivity in an OLTP-environment
- Strategies of a fragmentation
- Customization of client-server processing and operation with the distributed databases
- the Backup and restoring of the big systems
- Strategies of improvement of productivity for a database
- Additional instructions on customization
Preliminary preparation
Learning of courses In611 " Designing of Relational Databases ", IN613 " the Structured query language - SQL ", In388 " System Administration of Server INFORMIX-Dynamic Server ", In756 " Handle and Optimization of Databases INFORMIX-Dynamic Server " or equivalent knowledge, and also sufficient experience in administration Unix of systems, knowledge of the editor vi, Operation with INFORMIX-OnLine Dynamic Server at least in течениие 6 months.
This course will help you to prepare for the next tests:
660-212 Informix Performance Tuning for IDS 7.x
666-412 Performance Tuning/Backup and Restore Strategies Exam
Given cource inserted in next comlex programs:
ADM-IDS-7 Complex programm
Education coast on cource - USD 520
Cource duration (days) - 4
|
|
