Long SQTRACE runtime

Posted in 2016

MARK SCRANTON — Fri, 12 Feb 2016 17:40:45 — source: IIUG Forums & Mailing Lists

AIX 7.1 IDS 11.5.FC8 For a long-running update, sysadmin:mon_syssqltrace.sql_runtime is coming in at 36028786393.29 seconds. Looks like a bug from here? (expression) 1987-08-23 04:50:12 <==== start tx time (expression) 2016-02-01 20:29:37 <==== end tx time sql_stmtname UPDATE sql_finishtime 1454383777 sql_begintxtime 556714212 sql_runtime 36028786393.29 sql_pgreads 1 sql_bfreads 7 sql_rdcache 85.71428571429 sql_bfidxreads 0 sql_pgwrites 0 sql_bfwrites 1 sql_wrcache 100.0000000000 sql_lockreq 5 sql_lockwaits 0 sql_lockwttime 0.00 sql_logspace 136 sql_sorttotal 0 sql_sortdisk 0 sql_sortmem 0 sql_executions 46495 sql_totaltime 14.89836110029 sql_avgtime 0.000320429317 sql_maxtime 36028786393.29 sql_numiowaits 0 sql_avgiowaits 0.00 sql_totaliowaits 0.00 sql_rowspersec 2.77555838e-11 sql_estcost 1 Thanks - Mark Scranton The Mark Scranton Group "All Informix ... all the time" mark@markscranton.com