Tandem Capacity Model (TCM) Manual

NOTE: TCM enables you to modify specific cells in the WA workbook. TCM returns an error "To
modify a protected cell, first remove protection using the Unprotect Sheet command (Review tab,
Changes group)" when you try to edit any of the values in protected cells of the WA model
workbook. Only TCM administrators are able to unprotect and edit admin cells. To edit the protected
cells:
1. Change the Authorization level to "super" using the Options->Change Authorization Level
button.
2. Enable the Excel default tabs using the Options-->Enter Excel button. After changing the
authorization level to "super" the "Enter Excel" choice is enabled (Options is grayed out for
non-super authorization levels).
3. Enter your changes: TCM now allows you to edit the protected cells in the WA model.
4. Return to the TCM custom ribbon using the Home->Enter TCM button. This takes you back into
TCM and the Excel default tab is hidden again.
You can create a Transaction Count file instead of using the counts in the Transaction Count table.
This feature is useful if you know how many transactions your application processes. For example,
you might be able to create a simple program to parse your application’s statistics or log file to
determine the number of transactions that your application processes. Alternately, you can use
Measure user-defined counters to determine the number of transactions processed by your
application. You can create the file on the NonStop host system and download the file to the custom
folder, or you can create the file directly on the PC.
When TCM loads a CSV file, it checks to see if the corresponding Transaction Count file exists. If
the Transaction Count file exists, TCM uses the Transaction Count file for the transaction counts
and uses the Transaction Count table if any transaction counts are missing in the Transaction Count
file. Thus, you can use both a Transaction Count table and Transaction Count files. If you use both,
the values in the Transaction Count files supersede any values in the Transaction Count table.
For example, suppose your application has 20 transactions, and you have counts for 8 of the
transactions. You can use Transaction Count files to indicate the counts for these 8 transactions.
You should not put blanks in the Transaction Count files. For the 12 transactions not listed in the
Transaction Count files, TCM uses the Transaction Count table for the counts.
Transaction Count File Naming Convention
Transaction Count file names are patterned after the CSV file name. The Transaction Count file
has the same name as the CSV file except the extension is .TCF instead of .CSV. For example, the
CSV file EXAMPLE1.CSV would be EXAMPLE1.TCF. The Workload Apportionment model uses the
counts in the Transaction Count file instead of its generated formulas to calculate the number of
transactions. When you load category data, TCM automatically detects if you have a Transaction
Count file and loads it.
Transaction Count File Format
The Transaction Count file has the following format:
TXNCNT
txn-name-1, txn-cnt-1, comment text
txn-name-2, txn-cnt-2, comment
For example, the following Transaction Count file is valid:
TXNCNT
BIG, 500, You have 500 transactions of type BIG
ST1, 10, You have 10 ST1 transactions
Blank lines are not allowed in the file. To enter comments, enter a comma following the transaction
count number and type the comment.
If a Transaction Count file exists in the custom model folder, TCM uses the Transaction Count file.
If no .TCF file exists, TCM uses the Transaction Count table.
74 Creating a WA Model