- 论坛徽章:
- 0
|
我建立了个表
CREATE TABLE
testlinkin
(
a INTEGER,
b INTEGER,
PRIMARY KEY (a)
);
还有个存储过程
CREATE PROCEDURE informix.test3(count int)
define i int;
define zl01 int;
define zl02 int;
let i=0;
let zl01=10001;
let zl02=10002;
while i<count
insert into testlinkin values(zl01,zl02);
let i=i+1;
let zl01=zl01+1;
let zl02=zl02+1;
end while
end procedure;
执行execute procedure test3(50000)
同时不断的select count(*) from testlinkin;
结果到后面插入到26640条的时候,就停下来,不继续增加了。
这时候onstat 查看数据库的状态是正常的,但是 onmode -z PID 没有反应 。
有谁知道为什么吗?
[informix@localhost ~]$onstat -g sql
IBM Informix Dynamic Server Version 11.50.UC9 -- On-Line -- Up 00:13:28 -- 144148 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
33 SELECT user CR Not Wait 0 0 9.28 Off
32 INSERT user CR Not Wait 0 0 9.24 Off
31 - user CR Not Wait 0 0 9.24 Off
30 CREATE TEMP user CR Not Wait 0 0 9.28 Off
21 sysadmin DR Wait 5 0 0 - Off
20 sysadmin DR Wait 5 0 0 - Off
19 UPDATE sysadmin DR Wait 5 0 0 - Off
4 - user CR Not Wait 0 0 9.28 Off |
|