We need to know how to manually create indexes, TPC-C index creation failed
The user can create a Replay test to create the indexes they need.
The instructions can be found on BMF Comunity thread below:
http://benchmarkfactory.inside.quest.com/thread.jspa?threadID=3087&tstart=0
You can create a Load Scenario that will only create or delete only the objects you wish. The procedure is below.
a) On the Script tab select the root item and choose Wizards Load Scenario and click Next.
b) Choose Create a custom load scenario from the bottom of the list and click next.
c) Select the Replay radio button and choose next.
d) Click the Add User Scenario button and click next on the User Scenario wizard
e) Choose Create a custom user scenario and click next
f) Click on the Add SQL statement button and click next on the Transaction Wizard
g) Select Import Transaction and click next
h) Select the TPC-C Benchmark in the Benchmark drop down
i) Check the Show creation objects check box at the bottom of the screen
j) You may now select the objects you wish to create. If you wish to create one type only it may be easier if you use the Transaction Type drop down to filter the list. Click next twice and finish the wizard.
k) Now you are back in the User Scenario wizard. Make sure your items are in the correct order and adjust with the arrow buttons if necessary. For example, you will need to create a table before the indexes are created. Click Next
l) Enter a name; click next and finish the User scenario wizard.
m) Use next and finish buttons to finish the Load Scenario wizard and your load scenario will be created.
Attached is a script that will create the TPC-C indexes. The user can delete the creation transactions of the indexes that created successfully.
