If you're looking for a reason to upgrade to V5R3 or if you're wondering how to get more out of the latest release, then look no further than the new Index Evaluator. This new function makes it easier to analyze which indexes (and keyed logical files) are helping your SQL and query performance and which indexes are not pulling their weight.
For each index defined over the table, the evaluator returns data about the last time an index was used in the implementation of a query and/or used to provide statistics about the table data to the query optimizer. In addition, it returns a count for the number of times the query optimizer used an index object.
Below, you see the output of the Index Evaluator, which is initiated by right-clicking on a table object in iSeries Navigator and selecting the Indexes task.
(Click image to enlarge.)
This new capability requires iSeries Access for Windows V5R3 Service Pack 2 on the client and the following PTFs installed on the server: SI12938 and SI12873. The index usage information will not contain any data on queries run before these PTFs are applied, so don't make a decision on the value of an index before letting the majority of your reports and queries run.
Kent Milligan is a DB2 UDB Technology Specialist on IBM's eServer Solutions Enablement team. He spent the first seven years at IBM as a member of the DB2 development team in Rochester. He can be reached at
TechTip: New Tool for Analyzing DB2 Performance
Typography
- Smaller Small Medium Big Bigger
- Default Helvetica Segoe Georgia Times
- Reading Mode
Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:
LATEST COMMENTS
MC Press Online