5. Building the Schema

Run the buildschema command and the build will commence without prompting using your configuration and if successful report the status at the end of the build. Note that exactly as the GUI the build is multithreaded with Virtual Users running simultaneously.

hammerdb>buildschema
Script cleared
Building 10 Warehouses with 5 Virtual Users, 4 active + 1 Monitor VU(dict value mssqls_num_vu is set to 4)
Ready to create a 10 Warehouse MS SQL Server TPROC-C schema
in host (LOCAL) in database TPCC?
Enter yes or no: replied yes
Vuser 1 created - WAIT IDLE
Vuser 2 created - WAIT IDLE
Vuser 3 created - WAIT IDLE
Vuser 4 created - WAIT IDLE
Vuser 5 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:Monitor Thread
Vuser 1:CREATING TPCC SCHEMA
Vuser 1:CHECKING IF DATABASE tpcc EXISTS
Vuser 1:CREATING DATABASE tpcc
Vuser 2:RUNNING
Vuser 2:Worker Thread
Vuser 1:CREATING TPCC TABLES
Vuser 2:Waiting for Monitor Thread...
Vuser 1:Loading Item
Vuser 2:Loading 2 Warehouses start:1 end:2
Vuser 2:Start:Mon Apr 14 16:07:19 BST 2025
Vuser 2:Loading Warehouse
Vuser 2:Loading Stock Wid=1 Mon Apr 14 16:07:19 BST 2025
Vuser 3:RUNNING
Vuser 3:Worker Thread
Vuser 3:Waiting for Monitor Thread...
Vuser 3:Loading 2 Warehouses start:3 end:4
Vuser 3:Start:Mon Apr 14 16:07:19 BST 2025
Vuser 3:Loading Warehouse
Vuser 3:Loading Stock Wid=3 Mon Apr 14 16:07:19 BST 2025
Vuser 2:Loading Stock - 20000
Vuser 4:RUNNING
Vuser 4:Worker Thread
Vuser 4:Waiting for Monitor Thread...
Vuser 4:Loading 2 Warehouses start:5 end:6
Vuser 4:Start:Mon Apr 14 16:07:20 BST 2025
Vuser 4:Loading Warehouse
Vuser 4:Loading Stock Wid=5 Mon Apr 14 16:07:20 BST 2025
Vuser 3:Loading Stock - 20000
Vuser 5:RUNNING
Vuser 5:Worker Thread
Vuser 5:Waiting for Monitor Thread...
Vuser 5:Loading 2 Warehouses start:7 end:10
Vuser 5:Start:Mon Apr 14 16:07:20 BST 2025
Vuser 5:Loading Warehouse
Vuser 5:Loading Stock Wid=7 Mon Apr 14 16:07:20 BST 2025
…
Vuser 5:Loading Orders for W=10 Mon Apr 14 16:07:55 BST 2025
Vuser 5:End:Mon Apr 14 16:07:57 BST 2025
Vuser 5:FINISHED SUCCESS
Vuser 1:Workers: 0 Active 4 Done
Vuser 1:CREATING TPCC INDEXES
Vuser 1:CREATING TPCC STORED PROCEDURES
Vuser 1:UPDATING SCHEMA STATISTICS
Vuser 1:TPCC SCHEMA COMPLETE
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE
Schema Build jobid=67FD24A6FDB403E253438393

The vustatus command can confirm the status of each Virtual User.

hammerdb>vustatus
1 = FINISH SUCCESS
2 = FINISH SUCCESS
3 = FINISH SUCCESS
4 = FINISH SUCCESS
5 = FINISH SUCCESS

When the build is complete destroy the Virtual Users and confirm the status.

hammerdb>vudestroy
Destroying Virtual Users
Virtual Users Destroyed

hammerdb>vustatus
No Virtual Users found