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