1)Reboot the system. if informix used OS locking,it willunlock the table.
2)Use "onstat -u|grep your-login
use "onmode -z sid" to kill this session
(onstat -g sql sid or onstat -g ses sid ) to see the session id is doing that you are looking at.
[國民2]/home/mis/kmsrc>onstat -u |grep mis
44d59878 Y-BP--- 12 mis 2 452d5c98 0 116 449510 10496
44d59e90 Y-B---- 12 mis 2 4537b700 0 116 0 0
44d5aac0 Y--P--- 14 mis 2 45366648 0 1 49 2
44d5b0d8 --B-X-- 12 mis 2 0 0 116 248299 249038
[國民2]/home/mis/kmsrc>onstat -g ses
IBM Informix Dynamic Server Version 9.40.UC4 -- On-Line -- Up 01:20:07 -- 27
920 Kbytes
session #RSAM total used dyna
mic
id user tty pid hostname threads memory memory expl
ain
15 informix - 0 - 0 12288 7896 off
14 mis 2 4557 komin2 1 53248 47032 off
12 mis 2 4512 komin2 1 110592 98984 off
3 informix - 0 - 0 12288 9264 off
2 informix - 0 - 0 12288 7896 off
[國民2]/home/mis/kmsrc>onstat -g ses 12
IBM Informix Dynamic Server Version 9.40.UC4 -- On-Line -- Up 01:22:21 -- 27
920 Kbytes
session #RSAM total used dyna
mic
id user tty pid hostname threads memory memory expl
ain
12 mis 2 4512 komin2 1 110592 98984 off
tid name rstcb flags curstk status
40 sqlexec 44d59878 Y--P--- 1584 cond wait(netnorm)
Memory pools count 1
name class addr totalsize freesize #allocfrag #freefrag
12 V 45439020 110592 11608 256 12
name free used name free used
overhead 0 1648 scb 0 96
opentable 0 13592 filetable 0 2184
ru 0 264 log 0 2160
temprec 0 16200 keys 0 984
ralloc 0 32720 gentcb 0 2592
ostcb 0 2632 sort 0 72
sqscb 0 14736 sql 0 40
rdahead 0 112 hashfiletab 0 280
osenv 0 2184 sqtcb 0 2976
fragman 0 1624 udr 0 1888
sqscb info
scb sqscb optofc pdqpriority sqlstats optcompind directives
45332618 45463018 0 0 0 2 1
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
12 ALTER TABLE komin NL Not Wait 0 0 9.03 Off
Current SQL statement :
alter table postsldm modify(vat_no char(8))
Last parsed SQL statement :
alter table postsldm modify(vat_no char(8))
[國民2]/home/mis/kmsrc>onmode -z 12
caused by control-z
What is the difference between Ctrl-z and Ctrl-c in the terminal?
Control+C aborts the application almost immediately while Control+Z shunts it into the background, suspended.
- Control+C (control character intr) sends SIGINT which will interrupt the application. Usually causing it to abort, but this is up to the application to decide.
- Control+Z (control character susp) sends SIGTSTP to a foreground application, effectively putting it in the background, suspended. This is useful if you need to break out of something like an editor to go and grab some data you needed. You can go back into the application by running fg (or %x where x is the job number as shown in jobs).
|