DB2 Estimator for Windows provides estimates of DB2 application capacity requirements for DB2 for z/OS, Version 8 and DB2 for z/OS and OS/390 Version 7, and is the easiest way to estimate the performance of alternative table structures, SQL coding, and DB2 application capacity requirements.
DB2 Estimator can help you to answer the following questions:
What is the elapsed time for an SQL statement that fetches a specified number of rows?
How much processor resource is used during an N-way join?
What is the impact of adding and dropping an index from a table?
What is the impact of normalizing or de-normalizing a table?
Can my system support an anticipated increase in workload?
If I double the amount of processor resource, what is the effect on transaction response time?
How much storage do I need for the new table and its indexes?
What is the effect on performance if my table doubles in size?
What is the effect of compression?
What is the Server cost of a distributed SQL?
What is the effect of Data Sharing?
Can my application complete within the batch window?
How long will my utility job take?
What effect does a particular trigger have on an SQL?
Can I use stored procedures effectively?
DB2 Estimator enables you to:
Get accurate estimates
of DB2 application capacity requirements
Estimate performance of alternative table structures and SQL coding.
DB2 application capacity requirements
View costs instantly online,
and print or export files to spreadsheet applications
Easily obtain DASD size calculations by table, index and application.
Download table, index, view, and SQL
definitions via flat files
Additional benefits of DB2 estimator:
Provides online help and an easy-to-use
graphical user interface
Can be used without a connection
to a DB2 subsystem
Can be used as a training and learning tool
DB2 Estimator Version 8
DB2 Estimator has been updated for capacity planning in DB2 for z/OS, Version 8. The current support provides Capacity planning and Cost considerations with added features in DB2 for z/OS Version 8 pathlength, and covers limited new functionality of DB2 for z/OS, Version 8, and it continues to provide full support for DB2 version 7 applications.
On the download page click the Download using HTTP tab.
Click Download now. When prompted, specify a download directory.
When the download finishes, open the directory that you specified, and locate the file named stvm8.EXE. The stvm8.EXE file is a compressed file with a built-in extraction program.
Double click stvm8.EXE to run the PKSFX® extraction program.
In the Extract to field, enter a directory for the extracted files. When the extraction completes, the directory that you specified contains the following files:
setup.exe
SETUP.LST
V8stma1.CAB
V8stma2.CAB
V8stma3.CAB
V8stma4.CAB
V8stma5.CAB
Double click setup.exe to launch the installation wizard for DB2 Estimator.
Click Start > All Programs > DB2 Estimator V8 (8.0.1) > DB2 Esimator V8 to start DB2 Estimator.
How to use DB2 Estimator
DB2 Estimator can be used
during all phases of the life cycle of a relational database application.
A tutorial program is provided with DB2 Estimator. To start the tutorial, click Start > All Programs > DB2 Estimator V8 (8.0.1) > Tutorial Program
During the initial design phase
In the initial design phase, the
detailed specifications of the tables, indexes, and SQL statements used
by your application might not be available. Using DB2 Estimator,
you can quickly and easily determine whether your proposed design is feasible
and optimal.
For example, when you define a table
in DB2 Estimator, you need only specify the column names and significant
attributes of the table, such as the primary and foreign key columns. Creating
an index is as simple as choosing from the columns you have defined. From
these table and index definitions, you can immediately view the DASD space
requirements.
You can then define or download
SQL statements which approximate those you intend to use in your application,
and view the cost and performance of running those statements in terms of
CPU and I/O capacity. You can group these SQL statements to model DB2
transactions and view the costs at the transaction level.
Finally, you can model DB2
applications by grouping these transactions and specifying a rate for each
transaction type. DB2 Estimator estimates the amount of CPU and I/O
capacity needed to run the application in your environment as well as the
average elapsed time for each transaction type. You can model
standalone DB2 systems, or distrubuted DB2 Server Systems and include Data-Sharing.
You can also select from several
predefined utilities and determine the costs of running them.
DB2 Estimator allows you
to easily change your definitions to help you evaluate alternative designs.
By comparing the cost and performance of these designs, you can determine
which design provides the optimum cost/performance ratio before you invest
valuable time and resources coding your application or creating a real database.
While developing your application
and database objects
When you are ready to create real
database objects, you can use the models you specified in DB2 Estimator
as a guide for naming columns and specifying attribute values.
As you design and code application
modules or individual programs, you can use DB2 Estimator to get
a quick estimate of the expected performance without the need for creating
real database objects. These estimates can alert you to problems that are
easiest to fix at this early stage.
As you complete the application
code and database design, you can use DB2 Estimator to ensure that
performance is still optimal.
You can enhance the accuracy of
these estimates by inputting data to DB2 Estimator from the DB2
EXPLAIN statement, or from such tools as DB2 PM.
When your application is in production
Performance monitoring tools such
as DB2PM are commonly used to detect application performance problems
during production. Common solutions to these performance problems include
changes in index and SQL design.
By using DB2 Estimator, you
can easily evaluate alternative SQL designs and evaluate the resulting effects
on system performance before having to modify any production database objects.
DB2 Estimator also helps you determine the impact resulting from
hardware and workload changes.
Summary of features
Environment scope:
DBMS, SQL statements for DB2 UDB for OS/390 for
versions 5, 6, 7, and 8
Analysis approach:
Analytic and queueing models
User interface:
Graphical (Windows), multiple
levels of detail, and "What if?" analysis
Performance estimates:
CPU and I/O capacity, elapsed time,
DASD space, parallel queries and Data Sharing
DB2 for z/OS Version 8, and DB2 for z/OS and OS/390, Version 7
Operating environments:
Windows 95, Windows 98, Windows NT
Minimum machine requirements
IBM or compatible personal computer
with a Pentium processor or better
32 MB RAM
3.5-inch diskette drive, CD drive, or Internet connection
12 MB hard drive space, plus 15 MB during installation
VGA or better display
IBM PS/2 or Microsoft-compatible mouse
DB2 Estimator Version 7
Note: Support for DB2 for z/OS and OS/390, Version 7 ended on June 30, 2008.
DB2 Estimator is an easy-to-use, stand-alone tool for estimating
the performance of DB2 for z/OS™ & OS/390® Version 7 applications. Run it on your
desktop personal computer, or take it with you on your laptop.
Whether you want a simple table sizing or a detailed performance analysis
of an entire DB2 application, DB2 Estimator is ready
when you are, helping you to save time, lower costs, get new applications into production,
or enhance and modify your existing applications.
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
