4. Building the Schema

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