想要对sql的时长进行统计分析,informix怎样可以获取sql的执行时长? 注:用time/timex ./a.sh的方式不能实现将数据自动入库处理,不考虑(如有入库方法亦可考虑(花了N久时间都没有研究出来怎么入库,哪位仁兄有办法,请告知一二,谢谢))。 PS:在linux下time到是可以输出到文件里(已经实现),但在hp-ux下不可以。。但要的就是hp-ux:em06: 附:timex用法http://nixdoc.net/man-pages/HP-UX/man1/timex.1.html 再PS:在hp-u...
sco unix 5.05 informix online版本是7.31.UC5 informix online不能执行sql文件 用sh abc.sql 命令运行出错 而用isql -s进入,可视化界面,写入如下sql语句却可以正常执行 delete from smctl_tx_code where 1=1; load from /temp/code.txt insert into tx_code; 请老大分析一下为什么?? 下面是abc.sql文件 isql -s <
:em11: 执行sql过程中出错: Program stopped at "cs.4gl", line number 1804. 4GL run-time error number -25580. System error occurred in network function 然后informix就down啦! 查看online.log 信息: 11:57:48 On-Line Mode 12:03:17 Checkpoint Completed: duration was 1 seconds. 12:08:23 Checkpoint Completed: duration was 6 seconds. 12:13:31 Checkpoint Completed: duration was 7 seconds. 12:18:34 ...
:em11: 执行sql过程中出错: Program stopped at "cs.4gl", line number 1804. 4GL run-time error number -25580. System error occurred in network function 然后informix就down啦! 查看online.log 信息: 11:57:48 On-Line Mode 12:03:17 Checkpoint Completed: duration was 1 seconds. 12:08:23 Checkpoint Completed: duration was 6 seconds. 12:13:31 Checkpoint Completed: duration was 7 seconds. 12:18:34 ...