TPM and NOPM Not populated

[vijivignesh15112013-crypto]

Hi ,

We run the postgres workload . below are the script and Logs . We are not getting the tpm and nopm values . Any susggestion

Below is the TCL script

#!/bin/tclsh

proc runtimer { seconds } {
    set x 0
    set timerstop 0
    while {!$timerstop} {
        incr x
        after 1000
        if { ![ expr {$x % 60} ] } {
            set y [ expr {$x / 60} ]
            puts "Timer: $y minutes elapsed"
        }
        update
        if { [ vucomplete ] || $x == $seconds } { set timerstop 1 }
    }
    return
}

set tmpdir $::env(TMP)
puts "SETTING CONFIGURATION FOR LOAD TEST"
dbset db pg
dbset bm tproc-c

diset connection pg_host XXXXX
diset connection pg_port XXXX
diset connection pg_sslmode prefer

diset tpcc pg_superuser postgres
diset tpcc pg_superuserpass postgres_tpcc
diset tpcc pg_defaultdbase postgres
diset tpcc pg_count_ware 100
diset tpcc pg_num_vu 8
diset tpcc pg_user tpcc
diset tpcc pg_pass tpcc
diset tpcc pg_dbase benchmarkingdb
diset tpcc pg_oracompat false
diset tpcc pg_cituscompat false
diset tpcc pg_connect_pool false
diset tpcc pg_total_iterations 10000000
diset tpcc pg_raiseerror false
diset tpcc pg_keyandthink false
diset tpcc pg_driver timed
diset tpcc pg_rampup 5
diset tpcc pg_duration 60
diset tpcc pg_allwarehouse false
diset tpcc pg_timeprofile true
diset tpcc pg_async_scale false
diset tpcc pg_async_client 10
diset tpcc pg_async_verbose false
diset tpcc pg_async_delay 1000
diset tpcc pg_storedprocs false
diset tpcc pg_vacuum false
diset tpcc pg_dritasnap false
diset tpcc pg_tspace pg_default
diset tpcc pg_partition false

metset agent_hostname XXXX

vuset vu 8
vuset delay 500
vuset repeat 500
vuset iterations 1
vuset showoutput 1
vuset logtotemp 1
vuset unique 0
vuset nobuff 0
vuset timestamps 0
loadscript
puts "TEST STARTED"
vucreate
metstart
metstatus
tcstart
tcstatus
set jobid [ vurun ]
runtimer 600
vudestroy
after 5000
tcstop
metstop
puts "TEST COMPLETE"
set of [ open $tmpdir/pg_tprocc w ]
puts $of $jobid
puts "jobid is $jobid"
close $of

Below are the output logs:

2025-11-07 16:45:00,969|INFO|benchmarking_automation.hammerdb_executor|104562 PostgreSQL tpm 2025-11-07 16:45:10,980|INFO|benchmarking_automation.hammerdb_executor| 2025-11-07 16:45:10,980|INFO|benchmarking_automation.hammerdb_executor|144258 PostgreSQL tpm 2025-11-07 16:45:20,992|INFO|benchmarking_automation.hammerdb_executor| 2025-11-07 16:45:20,992|INFO|benchmarking_automation.hammerdb_executor|147822 PostgreSQL tpm 2025-11-07 16:45:27,856|INFO|benchmarking_automation.hammerdb_executor| 2025-11-07 16:45:27,856|INFO|benchmarking_automation.hammerdb_executor|Vuser 1:60 ..., 2025-11-07 16:45:27,862|INFO|benchmarking_automation.hammerdb_executor| **2025-11-07 16:45:27,862|INFO|benchmarking_automation.hammerdb_executor|Vuser 1:Test complete, Taking end Transaction Count. 2025-11-07 16:45:29,575|INFO|benchmarking_automation.hammerdb_executor|Task is still running... 2025-11-07 16:45:31,003|INFO|benchmarking_automation.hammerdb_executor|** 2025-11-07 16:45:31,003|INFO|benchmarking_automation.hammerdb_executor|152310 PostgreSQL tpm 2025-11-07 16:45:41,014|INFO|benchmarking_automation.hammerdb_executor| 2025-11-07 16:45:41,015|INFO|benchmarking_automation.hammerdb_executor|163248 PostgreSQL tpm 2025-11-07 16:45:51,026|INFO|benchmarking_automation.hammerdb_executor| 2025-11-07 16:45:51,026|INFO|benchmarking_automation.hammerdb_executor|148932 PostgreSQL tpm

[sm-shaw]

Hi, you don't need the runtimer section
runtimer 600
this was deprecated.
There are a number of example scripts in the scripts directory that you can use as a template.

[vijivignesh15112013-crypto]

Thank you for the response . will change it and run