You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Ян Программист <we...@gmail.com> on 2010/04/21 12:00:57 UTC
Table transactional locks advance
ij> select * from SYSCS_DIAG.TRANSACTION_TABLE;
XID |GLOBAL_XID
|USERNAME
|TYPE
|STATUS |FIRST_INSTANT |SQL_TEXT
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
152 |NULL
|APP
|UserTransaction |IDLE |NULL |NULL
201 |NULL
|APP
|UserTransaction |IDLE |NULL |NULL
212 |NULL
|APP
|UserTransaction |ACTIVE |(1,81878) |insert
into TRANS_SET select * from TRANS_SET
176 |NULL
|APP
|UserTransaction |IDLE |NULL |select *
from SYSCS_DIAG.TRANSACTION_TABLE
ij> select * from SYSCS_DIAG.LOCK_TABLE;
XID |TYPE |MODE|TABLENAME
|LOCKNAME |STATE|TABLETYPE|LOCK&|INDEXNAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1889 |TABLE|IX |TRANS_SET
|Tablelock |GRANT|T |2 |NULL
1889 |TABLE|X |TRANS_SET
|Tablelock |GRANT|T |1 |NULL
ij> select * from SYSCS_DIAG.STATEMENT_CACHE;
ID |SCHEMANAME
|SQL_TEXT
|UNICO&|VALID |COMPILED_AT
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
bc9ec0ce-0128-1af1-d729-ffff8205eb45|APP
|delete from TRANS_SET
|1 |1 |NULL
0d0600d0-0128-1af1-d729-ffff8205eb45|APP
|insert into TRANS_SET values
(
1, 'sdfsd')
|1 |1 |NULL
45b300a8-0128-1af1-d729-ffff8205eb45|APP
|select * from SYSCS_DIAG.LOCK_TABLE
|1 |1 |NULL
72e9c096-0128-1af1-d729-ffff8205eb45|APP
|call
SYSIBM.SQLCAMESSAGE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
|1 |1
|NULL
2e31c0ab-0128-1af1-d729-ffff8205eb45|APP
|select * from SYSCS_DIAG.TRANSACTION_TABLE
|1 |1 |NULL
01b7c0e6-0128-1af1-d729-ffff8205eb45|APP
|select * from SYSCS_DIAG.STATEMENT_CACHE
|1 |1 |NULL
8f3600b1-0128-1af1-d729-ffff8205eb45|APP
|insert into TRANS_SET values (1, 'skfskf')
|1 |1 |NULL
c3350098-0128-1af1-d729-ffff8205eb45|APP
|create table trans_set
(
id integer,
description varchar(10)
) |1
|1 |NULL
4d3680a5-0128-1af1-d729-ffff8205eb45|APP
|insert into TRANS_SET select * from TRANS_SET
|1 |1 |NULL
6c44409f-0128-1af1-d729-ffff8205eb45|APP
|select count(*) as counted from TRANS_SET
|1 |1 |NULL
Выбрано строк: 10
First two SQL requests help to show what I was trying to figure out
during runtime test. Results of a second request are satisfactorily
for me. John