2. Generate the Dataset with the CLI

Data Generation can also be run from the command line with the commands dgset, print datagen and datagenrun.

Copyright © HammerDB Ltd hosted by tpc.org 2019-2025
Type "help" for a list of commands
Initialized Jobs on-disk database C:/temp/hammer.DB using existing tables (630,784 bytes)
hammerdb>print datagen
Data Generation set to build a TPC-H schema for MSSQLServer with 1 scale factor with 1 virtual users in C:\temp

hammerdb>dgset scale_fact 10

hammerdb>dgset vu 20
Set virtual users to 20 for data generation

hammerdb>dgset directory C:/temp/TPCHDATA

hammerdb>print datagen
Data Generation set to build a TPC-H schema for MSSQLServer with 10 scale factor with 20 virtual users in C:/temp/TPCHDATA

hammerdb>datagenrun
Ready to generate the data for a 10 Scale Factor MSSQLServer TPROC-H schema
in directory C:/temp/TPCHDATA ?
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 6 created - WAIT IDLE
Vuser 7 created - WAIT IDLE
Vuser 8 created - WAIT IDLE
Vuser 9 created - WAIT IDLE
Vuser 10 created - WAIT IDLE
Vuser 11 created - WAIT IDLE
Vuser 12 created - WAIT IDLE
Vuser 13 created - WAIT IDLE
Vuser 14 created - WAIT IDLE
Vuser 15 created - WAIT IDLE
Vuser 16 created - WAIT IDLE
Vuser 17 created - WAIT IDLE
Vuser 18 created - WAIT IDLE
Vuser 19 created - WAIT IDLE
Vuser 20 created - WAIT IDLE
Vuser 21 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:Monitor Thread
Vuser 1:Generating REGION...
Vuser 1:Opened File C:/temp/TPCHDATA/region_1.tbl
Vuser 1:Generating REGION COMPLETE
Vuser 1:Generating NATION...
Vuser 1:Opened File C:/temp/TPCHDATA/nation_1.tbl
Vuser 1:Generating NATION COMPLETE
Vuser 1:Monitoring Workers...
Vuser 2:RUNNING
Vuser 2:Worker Thread
Vuser 2:Waiting for Monitor Thread...
Vuser 2:Generating SUPPLIER...
Vuser 2:Opened File C:/temp/TPCHDATA/supplier_1.tbl
Vuser 2:SUPPLIER Done Rows 1..5000
Vuser 2:Generating CUSTOMER...
Vuser 2:Opened File C:/temp/TPCHDATA/customer_1.tbl
Vuser 3:RUNNING
Vuser 3:Worker Thread
Vuser 3:Waiting for Monitor Thread...
Vuser 3:Generating SUPPLIER...
Vuser 3:Opened File C:/temp/TPCHDATA/supplier_2.tbl
Vuser 3:Generating SUPPLIER...10000
Vuser 3:SUPPLIER Done Rows 5001..10000
Vuser 3:Generating CUSTOMER...
Vuser 3:Opened File C:/temp/TPCHDATA/customer_2.tbl
Vuser 4:RUNNING
Vuser 4:Worker Thread
Vuser 4:Waiting for Monitor Thread...
Vuser 4:Generating SUPPLIER...
Vuser 4:Opened File C:/temp/TPCHDATA/supplier_3.tbl
Vuser 4:SUPPLIER Done Rows 10001..15000
Vuser 4:Generating CUSTOMER...
Vuser 4:Opened File C:/temp/TPCHDATA/customer_3.tbl
Vuser 5:RUNNING
Vuser 5:Worker Thread
Vuser 5:Waiting for Monitor Thread...
Vuser 5:Generating SUPPLIER...
Vuser 5:Opened File C:/temp/TPCHDATA/supplier_4.tbl
Vuser 5:Generating SUPPLIER...20000
Vuser 5:SUPPLIER Done Rows 15001..20000
Vuser 5:Generating CUSTOMER...
Vuser 5:Opened File C:/temp/TPCHDATA/customer_4.tbl
Vuser 6:RUNNING
Vuser 6:Worker Thread
Vuser 6:Waiting for Monitor Thread...
Vuser 6:Generating SUPPLIER...
Vuser 6:Opened File C:/temp/TPCHDATA/supplier_5.tbl
Vuser 3:Generating CUSTOMER...100000
Vuser 6:SUPPLIER Done Rows 20001..25000
Vuser 6:Generating CUSTOMER...
...