Espera de recursos
Hi, when i execute=20 select 'x' from z80pto_cnx where pto_cnx matches '1090146118* ' the following message is displayed 'not rows found' But, I when execute select 'x' from z80pto_cnx where pto_cnx matches '1090146118* ' = for update and there is another user locking any other rows of the same table, this = sentence waits for resources. I include an example. INFORMIX-OnLine Version 7.14.UD1 -- On-Line -- Up 5 days 11:44:28 -- = 153408 Kbytes session #RSAM total used =20 id user tty pid hostname threads memory memory =20 15601 mbiribin ttyq7 17923 hpk210 1 253952 240272 =20 tid name rstcb flags curstk status 17642 sqlexec c5e1980c L-BPR-- 31520 sleeping(Forever) Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag=20 15601 V c681c010 253952 13680 483 21 =20 name free used name free used = =20 overhead 0 112 scb 0 80 = =20 opentable 0 17720 filetable 0 2368 = =20 ru 0 232 misc 13680 0 = =20 log 0 2120 temprec 0 5448 = =20 ralloc 0 180344 gentcb 0 192 = =20 ostcb 0 2216 net 0 7880 = =20 sort 0 56 sqscb 0 13416 = =20 rdahead 0 1592 hashfiletab 0 280 = =20 osenv 0 816 buft_buffer 0 456 = =20 sqtcb 0 3632 fragman 0 1312 = =20 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 15601 SELECT apsf_109 DR Wait 0 0 6.03 Current statement name : i00003231_0c7dad28 Current SQL statement : select 'x' from z80pto_cnx where pto_cnx matches '1090146118* ' = for update Last parsed SQL statement : select 'x' from z80pto_cnx where pto_cnx matches '1090146118* ' = for update INFORMIX-OnLine Version 7.14.UD1 -- On-Line -- Up 5 days 11:44:42 -- = 153408 Kbytes session #RSAM total used =20 id user tty pid hostname threads memory memory =20 15576 minon ttyr5 17557 hpk210 1 376832 340768 =20 tid name rstcb flags curstk status 17609 sqlexec c5e22b28 L-BPR-- 31520 sleeping(Forever) Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag=20 15576 V c6ed6010 376832 36064 561 20 =20 name free used name free used = =20 overhead 0 112 scb 0 80 = =20 opentable 0 13768 filetable 0 2176 = =20 ru 0 232 misc 36064 0 = =20 log 0 2120 temprec 0 5448 = =20 ralloc 0 285472 gentcb 0 192 = =20 ostcb 0 2216 net 0 7880 = =20 sort 0 56 sqscb 0 13704 = =20 rdahead 0 1592 hashfiletab 0 280 = =20 osenv 0 816 buft_buffer 0 448 = =20 sqtcb 0 3152 fragman 0 1024 = =20 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 15576 SELECT apsf_109 DR Wait 0 0 6.02 Current statement name : i00002e68_0c7dad28 Current SQL statement : select 'x' from z80pto_cnx where pto_cnx matches '1090037102000* ' = for update Last parsed SQL statement : select 'x' from z80pto_cnx where pto_cnx matches '1090037102000* ' = for update INFORMIX-OnLine Version 7.14.UD1 -- On-Line -- Up 5 days 11:48:00 -- = 153408 Kbytes Locks address wtlist owner lklist type tblsnum rowid key#/bsiz c0b4e658 0 c5e24460 0 S 100002 212 0 =20 c0b4f1b0 0 c5e1980c c0be2b14 HDR+X a00003 916a0a K- 1 =20 c0b4f7e0 0 c5e0f854 0 HDR+S 100002 212 0 =20 c0b50f98 0 c5e0df1c c0c4e754 S 100002 20f 0 =20 c0b51a40 0 c5e1873c c0c237d4 HDR+X b00014 196d19 K- 2 =20 c0b51bf8 0 c5e20dbc 0 HDR+S 100002 213 0 =20 c0b53e84 0 c5e23390 c0bb0c08 S 100002 20f 0 =20 c0b584fc 0 c5e1ceb0 0 S 100002 20d 0 =20 c0b5aaf8 0 c5e1766c c0bf12c4 S 100002 20f 0 =20 c0b5c64c 0 c5e20dbc c0b51bf8 S 100002 20f 0 =20 c0b601f0 0 c5e24cc8 0 S 100002 20d 0 =20 c0b60610 0 c5e0fc88 0 S 100002 20b 0 =20 c0b60e50 0 c5e15d34 c0c47718 HDR+X e00002 12ca4301 K- 3 =20 c0b640ac 0 c5e15d34 c0be9cdc HDR+IX b00730 0 0 =20 c0b650d4 0 c5e0efec 0 S 100002 20f 0 =20 c0b66d88 0 c5e15d34 c0b7c0fc HDR+X e00002 12ca410b K- 1 =20 c0b670f8 0 c5e115c0 c0be1fbc S 100002 20f 0 =20 c0b698ac 0 c5e22b28 c0c4477c IX e0000c 0 0 =20 c0b69b6c 0 c5e15098 0 S 100002 20f 0 =20 c0b6bf84 0 c5e14c64 0 S 100002 20d 0 =20 c0b6c798 0 c5e15d34 c0c1fef0 HDR+IX b005f7 0 0 =20 c0b6cdc8 0 c5e1a8dc c0bfab38 S 100002 20f 0 =20 c0b6de74 0 c5e1f484 0 S 100002 20f 0 =20 c0b74148 0 c5e22b28 c0b9bc30 S 100002 20f 0 =20 c0b74460 0 c5e15d34 c0bf82a8 HDR+X e00002 12ca4301 K- 5 =20 c0b76090 0 c5e0f854 c0b4f7e0 S 100002 20f 0 =20 c0b76954 0 c5e25530 0 HDR+S 100002 203 0 =20 c0b77588 0 c5e0f420 0 S 100002 20f 0 =20 c0b77664 0 c5e15d34 c0beab4c HDR+X e00002 12ca410b K- 4 =20 c0b781bc 0 c5e1873c c0bd48b8 HDR+X b00014 196d0d K- 1 =20 c0b78c38 0 c5e15d34 c0bcfdf4 HDR+X e00002 12ca4301 0 =20 c0b7bd08 0 c5e1e7e8 0 S 100002 20f 0 =20 c0b7c0fc 0 c5e15d34 c0b83e1c HDR+X e00002 12ca410b 0 =20 c0b7de8c 0 c5e1a074 0 S 100002 20d 0 =20 c0b82168 0 c5e24894 0 S 100002 212 0