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
