Level: Introductory Mark Baldridge , Principal Consultant, North American Lab Services, IBM
22 Dec 2005 IBM® UniVerse® DBA and developers need a tool to help understand how the decisions about database operations and constructs affect performance. This tutorial introduces the UniVerse Profiler for constructing, running, and reporting tests which investigate the performance impact of different program options and system tuning decisions. Future articles will provide examples using the Profiler so you can see the impact on your own system.
Prerequisites
You should have a familiarity with writing and compiling UniVerse BASIC programs.
System requirements
This tutorial requires an installation of UniVerse. You can download a Personal edition of
UniVerse
Application Server Version 6.0.
Duration
2 hours
Formats html, pdf
About this tutorial
Have you ever wondered what would happen if the CIO came to you and demanded you make a routine run 30 percent faster? How would you measure it? How would you measure a new algorithm for doing the same thing?
This is the inaugural tutorial of a series of articles and tutorials on performance tuning a UniVerse database. This tutorial introduces a tool for investigating the performance impact of operations in the UniVerse database environment. We examine the capabilities of the Profiler and build some introductory tests that exercise those capabilities.
| 
