Reload Analyzer Manual

Tandem Reload Analyzer Manual Page 15 of 42
Section 1: Tandem Reload Analyzer
Overview
The File Utility Program (FUP) RELOAD command physically reorganizes audited,
key-sequenced Enscribe files, NonStop SQL/MP objects and SQL/MX objects that
have become fragmented or disorganized. Because a FUP RELOAD is not a
procedure that you should use indiscriminately, determining when to reload is difficult.
Tandem Reload Analyzer is a database management tool that helps you determine
whether a key-sequenced Enscribe file or key-sequenced NonStop SQL/MP or
NonStop SQL/MX object needs to be reorganized.
Note. Throughout this manual, the term file refers to any NonStop SQL/MX object
(table or index), NonStop SQL/MP object (table or index) or key-sequenced Enscribe
file. Even though Reload Analyzer runs against any file or NonStop SQL object, FUP
RELOAD will not reorganize a nonaudited Enscribe file or nonaudited NonStop SQL
object.
When you analyze a file with Tandem Reload Analyzer (Reload Analyzer), it provides
various key information. The information includes the total blocks read in the file,
minimum and maximum number of records, average slack in the data blocks, average
percentage of slack, and the space used in the data and index blocks. This information
is the same as the information given by the FUP INFO filename, STAT command.
Reload Analyzer, however, gives the information faster than the FUP INFO filename,
STAT command and one other key piece of information—the number of contiguous
data blocks. When you have all this information about a file, you can easily decide
whether to reload a key-sequenced Enscribe file or key-sequenced NonStop SQL
object.
Features and Benefits
Tandem Reload Analyzer provides the following features:
 Engineered specifically for HP NonStop servers.
 Very efficient low-overhead algorithm.
 Diagnoses poorly organized files.
 Improves performance by a factor of up to 128x.
 Supports all NonStop server file types including: Enscribe, SQL/MP, SQL/MX.
 Supports all index and data block sizes, including 32kb block size tables.
 Performs in-depth data-block chain and fragmentation analysis.
 Determines when files, tables, and indexes are not performing optimally.
 Determines when data block chains are fragmented and not physically adjacent.
 Determines when there's a loss of sequential data-block pre-fetching.
 Can analyze a single file, a single partition, all partitions, or a user specified batch list of
files.