Reload Analyzer Manual

Tandem Reload Analyzer Manual Page 26 of 42
directed to the home terminal. If you use the NOWAIT option with Reload Analyzer and
direct the output from another program to the home terminal, that program’s output and
the status indicator will be interspersed on the home terminal. This makes it hard to
distinguish the output. For more information about the TACL command-line options, see
the Tandem Advanced Command Language (TACL) Reference Manual.
Reloading the Database
When you specify fupin, THRESHOLD value, or both in the Run command, Reload
Analyzer automatically creates a FUP obey file containing the FUP RELOAD
commands for files with a fragmentation ratio less than the specified or default
threshold value. The fragmentation ratio is the percentage of total blocks in the
average chain, which is found by dividing the average number of blocks in a chain by
the total number of blocks in the file.
When Reload Analyzer is finished running, enter RUN FUP/IN fupin/ to reload the
database. Example 2-1 shows a sample file containing FUP RELOAD commands.
Example 2-1. Sample FUP RELOAD Command File
-- Tandem Reload Analyzer - T9516H01-AAF (31MAR2010)Start time - 18:36:48
-- This file contains the FUP RELOAD commands for the files that meet
-- the criteria you specified. Use this information and your knowledge
-- of your systems and applications to help decide whether a file
-- should be reloaded. Remember that an online reload causes performance
-- degradation and creates a large amount of audit trail information for
-- TMF-audited files or tables.
--
-- Review the FUP RELOAD commands for accuracy before running them.
--
-- TRA used the THRESHOLD value of 25 while generating this file.
-- \scube.$data.insurnc.salesdb
-- Total blocks read 303
-- Number of chains 203
-- Avg blocks/chain 1
-- % of total blks in avg chain < 1%
RELOAD \scube.$data.insurnc.salesdb, RATE 40
Interrupting Reload Analyzer
To interrupt the Reload Analyzer process, press the Break key. Pressing Break returns
control to the command interpreter. However, the process continues to execute in the
background. Interrupting the process is safe and will not damage the file being
analyzed.
If you execute another program before Reload Analyzer finishes, Reload Analyzer and
the other program will both try to write to the home terminal. Because both programs
are writing output to the home terminal, you can have trouble distinguishing the Reload
Analyzer’s output from the other program’s output.