ChinaUnix.net
相关文章推荐:

informix onstat sql 执行缓慢的原因

:em17: :em17: :em17:

by kerom - Informix - 2009-09-18 18:27:42 阅读(2861) 回复(3)

相关讨论

想要对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...

by liaosnet - Informix - 2007-04-05 17:32:40 阅读(1953) 回复(8)

谁能提供一个查看当前每一个session id执行的sql的东东。 输入回车看下一个session id执行什么,直到最后结束

by sashaye - Informix - 2005-10-26 10:15:37 阅读(2440) 回复(3)

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 <

by foolboy007 - Informix - 2005-05-27 17:01:14 阅读(1228) 回复(3)

我在informix数据库下,批量执行sql语句,如果中间报错,怎么才能让dbaccess把执行成功和错误的sql语句打印出来

by anamath - Informix - 2009-09-04 09:28:28 阅读(2392) 回复(3)

xdjm如有知道的请告知,谢谢!

by whb1028 - Informix - 2005-09-26 16:23:46 阅读(984) 回复(1)

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

by wenjh - Informix - 2004-04-19 18:44:19 阅读(787) 回复(5)

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

by wenjh - Informix - 2004-04-22 11:44:24 阅读(992) 回复(5)

各位老大,我想优化informix,想获取占用资源最多的sql语句以及语句的执行计划,如何获得?请告知,小弟先行谢过!

by depsyq - Informix - 2005-04-29 16:40:38 阅读(1908) 回复(0)

informixsql执行语句和执行时间长短的日志吗 我想导出来检查,sql频率和效率

by 我是DBA - Informix - 2008-06-25 15:38:06 阅读(2568) 回复(7)
by bellbird - Informix - 2006-09-27 10:09:02 阅读(957) 回复(0)