4. 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.


hammerdb>buildschema
Script cleared
Building 10 Warehouses with 5 Virtual Users, 4 active + 1 Monitor VU(dict value redis_num_vu is set to 4)
Ready to create a 10 Warehouse Redis TPC-C schema
in host 127.0.0.1:6379 in namespace 1?
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
RUNNING - TPC-C creation
Vuser 1:RUNNING
Vuser 1:Monitor Thread
Vuser 1:CREATING REDIS SCHEMA IN NAMESPACE 1
Vuser 1:Connection made to Redis at 127.0.0.1:6379
Vuser 1:Selecting Namespace 1
Vuser 1:Loading Item
Vuser 2:RUNNING
Vuser 2:Worker Thread
Vuser 2:Waiting for Monitor Thread...
Vuser 2:Connection made to Redis at 127.0.0.1:6379
Vuser 2:Selecting Namespace 1
Vuser 2:Loading 2 Warehouses start:1 end:2
Vuser 2:Start:Mon Apr 09 11:20:43 BST 2018
Vuser 2:Loading Warehouse
Vuser 2:Loading Stock Wid=1
Vuser 3:RUNNING
Vuser 3:Worker Thread
Vuser 3:Waiting for Monitor Thread...
Vuser 3:Connection made to Redis at 127.0.0.1:6379
Vuser 3:Selecting Namespace 1
Vuser 3:Loading 2 Warehouses start:3 end:4
Vuser 3:Start:Mon Apr 09 11:20:44 BST 2018
Vuser 3:Loading Warehouse
Vuser 3:Loading Stock Wid=3
Vuser 4:RUNNING
Vuser 4:Worker Thread
Vuser 4:Waiting for Monitor Thread...
Vuser 4:Connection made to Redis at 127.0.0.1:6379
Vuser 4:Selecting Namespace 1
Vuser 4:Loading 2 Warehouses start:5 end:6
Vuser 4:Start:Mon Apr 09 11:20:44 BST 2018
Vuser 4:Loading Warehouse
Vuser 4:Loading Stock Wid=5
Vuser 5:RUNNING
Vuser 5:Worker Thread
Vuser 5:Waiting for Monitor Thread...
Vuser 5:Connection made to Redis at 127.0.0.1:6379
Vuser 5:Selecting Namespace 1
Vuser 5:Loading 2 Warehouses start:7 end:10
Vuser 5:Start:Mon Apr 09 11:20:45 BST 2018
Vuser 5:Loading Warehouse
Vuser 5:Loading Stock Wid=7

.....

Vuser 5:End:Mon Apr 09 11:27:13 BST 2018
Vuser 5:FINISHED SUCCESS
Vuser 1:Workers: 0 Active 4 Done
Vuser 1:REDIS SCHEMA COMPLETE
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE

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