I would to want to clarify that the Trafodion instance can't be considered as idle if there is no transaction in general. There are commands to bypass transactions like load, upsert using load for high performing data ingestion.
For a limited developer use case scenario, it might be ok to just look at the dtmci stats output to detect the idleness of the trafodion instance. Selva -----Original Message----- From: Venkat Muthuswamy [mailto:[email protected]] Sent: Tuesday, August 15, 2017 9:46 AM To: [email protected] Subject: RE: Is there a way to tell if an instance is idle? Hi Dave, One option is to DTMCI to print transaction statistics and parse the output. You can parse the output. Try "dtmci stats" or "dtmci stats -j" (json output) Venkat -----Original Message----- From: Dave Birdsall [mailto:[email protected]] Sent: Tuesday, August 15, 2017 9:13 AM To: [email protected] Subject: Is there a way to tell if an instance is idle? Hi, Is there a way to tell if a Trafodion instance is idle? For example, is there a way to tell if there have been no transactions in the last n minutes? The reason I am asking: It might be handy to have a script that shuts down an instance once it has been idle for a while. This would be useful to reduce load on shared development workstations when running test suites overnight, for example. Dave
