IBM 000-912 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | PERFORMANCE TUNING: INFORMIX DYNAMIC SERVER V7 |
| Exam Number: | 000-912 |
| Exam Price: | Retired, no longer available |
| Exam Duration: | 90 minutes |
| Available Languages: | English |
| Passing Score: | 70% |
| Certificate Validity Period: | No expiration (legacy certification) |
| Real Exam Qty: | 90-105 |
| Related Certifications: | 000-910 Managing & Optimizing Informix Dynamic Server Databases 000-911 System Administration for Informix Dynamic Server V7 IBM Certified Specialist - Informix Dynamic Server V7 |
| Exam Format: | Multiple Select, Multiple Choice |
| Recommended Training: | IBM Informix Performance Guide |
| Exam Way: | Originally delivered via Prometric test centers; retired and no longer offered |
| Pre Condition: | Recommended: 000-911 System Administration for Informix Dynamic Server V7 or equivalent experience |
IBM 000-912 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Shared Memory Tuning | 20% | - Memory usage for sessions and transactions - Virtual segment and memory allocation - Buffer pool configuration (BUFFERS, LRU queues) |
| I/O and Disk Configuration | 20% | - Checkpoint and I/O manager tuning - Dbspace and chunk layout - Table and index fragmentation |
| ONCONFIG Parameter Tuning | 8% | - Key configuration parameters - Parameter impact on server performance |
| Query Optimization | 25% | - Cost-based optimizer behavior - SET EXPLAIN and execution plan analysis - Index design and selection - PDQ (Parallel Database Query) settings |
| Concurrency and Transaction Tuning | 12% | - Lock management and contention resolution - Transaction logging and buffer tuning |
| Performance Tuning Fundamentals | 15% | - System architecture and resource utilization - Workload characterization (OLTP vs DSS) - Performance monitoring and measurement tools |

We're so confident of our products that we provide no hassle product exchange.


By Eugene


