db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r1443812 [1/6] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ suites/ tests/store/
Date Fri, 08 Feb 2013 00:51:10 GMT
Author: myrnavl
Date: Fri Feb  8 00:51:09 2013
New Revision: 1443812

URL: http://svn.apache.org/r1443812
Log:
DERBY-5977; Run storemore and possibly other store .sql tests in junit harness using ScriptTest mechanism
  Committing patch DERBY-5977_2, which:
  - adds the StoreScriptsTest, and adds it to store._Suite
  - modifies the .sql scripts run in it to have fully qualified resources
  - modifies the canons affected to adjust for running them through the 
    ScriptTest mechanism
  - removes the now unused properties files
  - removes the .sql scripts run this way from derbyall's storemore suite.

Added:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/StoreScriptsTest.java   (with props)
Removed:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/Rllmodule1_derby.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/Rllmodule3_derby.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/Rllmodule4_derby.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/RowLockIso_app.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/RowLockIso_derby.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/bug3498_app.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/cisco_app.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/cisco_default.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/cisco_derby.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/connectDisconnect_app.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/connectDisconnect_derby.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/heapscan_app.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/heapscan_derby.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/lockTableVti_app.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/removeStubs_app.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/testsqldecimal_app.properties
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/testsqldecimal_derby.properties
Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/SpaceTable.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/bug3498.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cisco.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/connectDisconnect.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/heapscan.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/lockTableVti.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/longRow.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/readlocks.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/removeStubs.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso1multi.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso2multi.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/rlliso3multi.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/testsqldecimal.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/storemore.runall
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/Rllmodule1.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/Rllmodule3.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/Rllmodule4.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/RowLockIso.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/SpaceTable.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/_Suite.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/cisco.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/heapscan.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/longRow.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/readlocks.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/rlliso1multi.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/rlliso2multi.sql
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/rlliso3multi.sql

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out?rev=1443812&r1=1443811&r2=1443812&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule1.out Fri Feb  8 00:51:09 2013
@@ -1,4 +1,4 @@
-ij> --
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -16,8 +16,8 @@ ij> --
 --
 -- Test whether the RllRAMAccessmanager is working right (ie. forcing row 
 -- level locking). 
-run resource 'LockTableQuery.subsql';
-ij> --
+run resource '/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -48,9 +48,10 @@ from 
     syscs_diag.lock_table l  right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' and t.type='UserTransaction';
 0 rows inserted/updated/deleted
-ij> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
+ij(CONNECTION1)> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
 -- order by
 --     tabname, type desc, mode, cnt, lockname
+
 -- lock table with system catalog locks included.
 create view full_lock_table as
 select 
@@ -67,7 +68,7 @@ from 
     syscs_diag.lock_table l right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- lock table with no join.
+ij(CONNECTION1)> -- lock table with no join.
 create view lock_table2 as
 select 
     cast(l.xid as char(8)) as xid,
@@ -81,26 +82,26 @@ from 
     syscs_diag.lock_table l  
 where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- transaction table with no join.
+ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as
 select 
     *
 from 
     syscs_diag.transaction_table;
 0 rows inserted/updated/deleted
-ij> autocommit off;
-ij> create table heap_only (a int);
+ij(CONNECTION1)> autocommit off;
+ij(CONNECTION1)> create table heap_only (a int);
 0 rows inserted/updated/deleted
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test insert into empty heap, should just get row lock 
 --------------------------------------------------------------------------------
 insert into heap_only values (1);
 1 row inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |HEAP_ONLY   |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |HEAP_ONLY   |(1,7)     |GRANT|ACTIVE  
-ij> commit;
-ij> 
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out?rev=1443812&r1=1443811&r2=1443812&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule3.out Fri Feb  8 00:51:09 2013
@@ -1,4 +1,4 @@
-ij> --
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -16,8 +16,8 @@ ij> --
 --
 -- Test whether the RllRAMAccessmanager is working right (ie. forcing row 
 -- level locking with no properties set). 
-run resource 'LockTableQuery.subsql';
-ij> --
+run resource '/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -48,9 +48,10 @@ from 
     syscs_diag.lock_table l  right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' and t.type='UserTransaction';
 0 rows inserted/updated/deleted
-ij> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
+ij(CONNECTION1)> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
 -- order by
 --     tabname, type desc, mode, cnt, lockname
+
 -- lock table with system catalog locks included.
 create view full_lock_table as
 select 
@@ -67,7 +68,7 @@ from 
     syscs_diag.lock_table l right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- lock table with no join.
+ij(CONNECTION1)> -- lock table with no join.
 create view lock_table2 as
 select 
     cast(l.xid as char(8)) as xid,
@@ -81,26 +82,26 @@ from 
     syscs_diag.lock_table l  
 where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- transaction table with no join.
+ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as
 select 
     *
 from 
     syscs_diag.transaction_table;
 0 rows inserted/updated/deleted
-ij> autocommit off;
-ij> create table heap_only (a int);
+ij(CONNECTION1)> autocommit off;
+ij(CONNECTION1)> create table heap_only (a int);
 0 rows inserted/updated/deleted
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test insert into empty heap, should just get row lock 
 --------------------------------------------------------------------------------
 insert into heap_only values (1);
 1 row inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |HEAP_ONLY   |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |HEAP_ONLY   |(1,7)     |GRANT|ACTIVE  
-ij> commit;
-ij> 
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out?rev=1443812&r1=1443811&r2=1443812&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Rllmodule4.out Fri Feb  8 00:51:09 2013
@@ -1,4 +1,4 @@
-ij> --
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -16,8 +16,8 @@ ij> --
 --
 -- Test whether the RllRAMAccessmanager is working right (ie. forcing row 
 -- level locking). 
-run resource 'LockTableQuery.subsql';
-ij> --
+run resource '/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -48,9 +48,10 @@ from 
     syscs_diag.lock_table l  right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' and t.type='UserTransaction';
 0 rows inserted/updated/deleted
-ij> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
+ij(CONNECTION1)> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
 -- order by
 --     tabname, type desc, mode, cnt, lockname
+
 -- lock table with system catalog locks included.
 create view full_lock_table as
 select 
@@ -67,7 +68,7 @@ from 
     syscs_diag.lock_table l right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- lock table with no join.
+ij(CONNECTION1)> -- lock table with no join.
 create view lock_table2 as
 select 
     cast(l.xid as char(8)) as xid,
@@ -81,26 +82,26 @@ from 
     syscs_diag.lock_table l  
 where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- transaction table with no join.
+ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as
 select 
     *
 from 
     syscs_diag.transaction_table;
 0 rows inserted/updated/deleted
-ij> autocommit off;
-ij> create table heap_only (a int);
+ij(CONNECTION1)> autocommit off;
+ij(CONNECTION1)> create table heap_only (a int);
 0 rows inserted/updated/deleted
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test insert into empty heap, should just get row lock 
 --------------------------------------------------------------------------------
 insert into heap_only values (1);
 1 row inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |HEAP_ONLY   |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |HEAP_ONLY   |(1,7)     |GRANT|ACTIVE  
-ij> commit;
-ij> 
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> 
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out?rev=1443812&r1=1443811&r2=1443812&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/RowLockIso.out Fri Feb  8 00:51:09 2013
@@ -1,4 +1,4 @@
-ij> --
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -23,8 +23,8 @@ ij> --
 --    print lock table which should match the master
 --    end transation
 -- 
-run resource 'createTestProcedures.subsql';
-ij> --
+run resource '/org/apache/derbyTesting/functionTests/tests/store/createTestProcedures.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -42,10 +42,10 @@ ij> --
 --
 CREATE FUNCTION  PADSTRING (DATA VARCHAR(32000), LENGTH INTEGER) RETURNS VARCHAR(32000) EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.Formatters.padString' LANGUAGE JAVA PARAMETER STYLE JAVA;
 0 rows inserted/updated/deleted
-ij> CREATE PROCEDURE WAIT_FOR_POST_COMMIT() DYNAMIC RESULT SETS 0 LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.T_Access.waitForPostCommitToFinish' PARAMETER STYLE JAVA;
+ij(CONNECTION1)> CREATE PROCEDURE WAIT_FOR_POST_COMMIT() DYNAMIC RESULT SETS 0 LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.T_Access.waitForPostCommitToFinish' PARAMETER STYLE JAVA;
 0 rows inserted/updated/deleted
-ij> run  resource 'LockTableQuery.subsql';
-ij> --
+ij(CONNECTION1)> run  resource '/org/apache/derbyTesting/functionTests/tests/store/LockTableQuery.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -76,9 +76,10 @@ from 
     syscs_diag.lock_table l  right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' and t.type='UserTransaction';
 0 rows inserted/updated/deleted
-ij> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
+ij(CONNECTION1)> --on l.xid = t.xid where l.tableType <> 'S' or l.tableType is null
 -- order by
 --     tabname, type desc, mode, cnt, lockname
+
 -- lock table with system catalog locks included.
 create view full_lock_table as
 select 
@@ -95,7 +96,7 @@ from 
     syscs_diag.lock_table l right outer join syscs_diag.transaction_table t
 on l.xid = t.xid where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- lock table with no join.
+ij(CONNECTION1)> -- lock table with no join.
 create view lock_table2 as
 select 
     cast(l.xid as char(8)) as xid,
@@ -109,677 +110,680 @@ from 
     syscs_diag.lock_table l  
 where l.tableType <> 'S' ;
 0 rows inserted/updated/deleted
-ij> -- transaction table with no join.
+ij(CONNECTION1)> -- transaction table with no join.
 create view tran_table as
 select 
     *
 from 
     syscs_diag.transaction_table;
 0 rows inserted/updated/deleted
-ij> autocommit off;
-ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
+ij(CONNECTION1)> autocommit off;
+ij(CONNECTION1)> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
 0 rows inserted/updated/deleted
-ij> create table a (a int, b int, c varchar(1900)) ;
+ij(CONNECTION1)> create table a (a int, b int, c varchar(1900)) ;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> set isolation read committed;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> set isolation read committed;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test select from empty heap table
 --------------------------------------------------------------------------------
 select a, b from a;
 A          |B          
 -----------------------
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test select from one row heap table
 --------------------------------------------------------------------------------
 insert into a values (1, -1, PADSTRING('one',1900));
 1 row inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
-ij> commit;
-ij> select a, b from a;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select a, b from a;
 A          |B          
 -----------------------
 1          |-1         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test select from two row heap table - this will release one row lock as it
 -- moves to the next one.
 --------------------------------------------------------------------------------
 insert into a values (2, -2, PADSTRING('two',1900));
 1 row inserted/updated/deleted
-ij> commit;
-ij> select a,b from a;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select a,b from a;
 A          |B          
 -----------------------
 1          |-1         
 2          |-2         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test select from three row heap table (multiple pages) - this will release 
 -- one row lock as it moves to the next one.
 --------------------------------------------------------------------------------
 insert into a values (3, -3, PADSTRING('two',1900));
 1 row inserted/updated/deleted
-ij> insert into a values (4, -4, PADSTRING('two',1900));
+ij(CONNECTION1)> insert into a values (4, -4, PADSTRING('two',1900));
 1 row inserted/updated/deleted
-ij> insert into a values (5, -5, PADSTRING('two',1900));
+ij(CONNECTION1)> insert into a values (5, -5, PADSTRING('two',1900));
 1 row inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |3   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |A           |(2,6)     |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |A           |(2,7)     |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |A           |(3,6)     |GRANT|ACTIVE  
-ij> commit;
-ij> delete from a where a.a = 3;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> delete from a where a.a = 3;
 1 row inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |A           |(2,6)     |GRANT|ACTIVE  
-ij> commit;
-ij> select a,b from a;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select a,b from a;
 A          |B          
 -----------------------
 1          |-1         
 2          |-2         
 4          |-4         
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test full read cursor scan over all the rows in the heap, no group fetch.
 --------------------------------------------------------------------------------
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b from a';
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
+ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');
 0 rows inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 1          |-1         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |S   |A           |(1,7)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 2          |-2         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |S   |A           |(1,8)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 4          |-4         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |S   |A           |(2,7)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |S   |A           |(3,6)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> close scan_cursor;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
+ij(CONNECTION1)> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
 0 rows inserted/updated/deleted
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test full cursor scan over all the rows in the heap, with 2 row group fetch.
 --------------------------------------------------------------------------------
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','2');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b from a';
-ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
+ij(CONNECTION1)> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
 0 rows inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 1          |-1         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 2          |-2         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 4          |-4         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> close scan_cursor;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test full cursor scan over all the rows in the heap, with default group fetch
 --------------------------------------------------------------------------------
 get cursor scan_cursor as
     'select a, b from a';
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 1          |-1         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 2          |-2         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 4          |-4         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> close scan_cursor;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test full cursor for update scan over all the rows in the heap, 
 -- with default group fetch.  Group fetch should be disabled.
 --------------------------------------------------------------------------------
 get cursor scan_cursor as
     'select a, b from a for update';
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 1          |-1         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |U   |A           |(1,7)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 2          |-2         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |U   |A           |(1,8)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 4          |-4         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |U   |A           |(2,7)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |U   |A           |(3,6)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-ij> close scan_cursor;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IX  |A           |Tablelock |GRANT|ACTIVE  
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test full read cursor scan on a join over all the rows in the btree, 
 -- 2 row group fetch.
 --------------------------------------------------------------------------------
+
 drop table a;
 0 rows inserted/updated/deleted
-ij> create table a (a int, b int, c varchar(1900), d int, e varchar(2000)) ;
+ij(CONNECTION1)> create table a (a int, b int, c varchar(1900), d int, e varchar(2000)) ;
 0 rows inserted/updated/deleted
-ij> create index a_idx on a (a, b, c) ;
+ij(CONNECTION1)> create index a_idx on a (a, b, c) ;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> create table b (a int, b int, c varchar(1900)) ;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> create table b (a int, b int, c varchar(1900)) ;
 0 rows inserted/updated/deleted
-ij> insert into b values (1, -1, PADSTRING('one',1900));
+ij(CONNECTION1)> insert into b values (1, -1, PADSTRING('one',1900));
 1 row inserted/updated/deleted
-ij> insert into b values (2, -2, PADSTRING('two',1900));
+ij(CONNECTION1)> insert into b values (2, -2, PADSTRING('two',1900));
 1 row inserted/updated/deleted
-ij> insert into b values (3, -3, PADSTRING('three',1900));
+ij(CONNECTION1)> insert into b values (3, -3, PADSTRING('three',1900));
 1 row inserted/updated/deleted
-ij> insert into b values (4, -4, PADSTRING('four',1900));
+ij(CONNECTION1)> insert into b values (4, -4, PADSTRING('four',1900));
 1 row inserted/updated/deleted
-ij> insert into b values (5, -5, PADSTRING('five',1900));
+ij(CONNECTION1)> insert into b values (5, -5, PADSTRING('five',1900));
 1 row inserted/updated/deleted
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test select from empty index
 --------------------------------------------------------------------------------
 select a, b from a;
 A          |B          
 -----------------------
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test select from one row index'd table
 --------------------------------------------------------------------------------
 insert into a values (5, -5, PADSTRING('five',1900), 5, PADSTRING('negative five',2000));
 1 row inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |A           |(1,7)     |GRANT|ACTIVE  
-ij> commit;
-ij> select a, b from a;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select a, b from a;
 A          |B          
 -----------------------
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test select from two row indexed heap table - this will release one row
 -- lock as it moves to the next one.
 --------------------------------------------------------------------------------
 insert into a values (4, -4, PADSTRING('four',1900), 4, PADSTRING('negative four',2000));
 1 row inserted/updated/deleted
-ij> commit;
-ij> select a,b from a;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select a,b from a;
 A          |B          
 -----------------------
 4          |-4         
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test select from three row indexed heap table (multiple pages) - this will
 -- release one row lock as it moves to the next one.
 --------------------------------------------------------------------------------
 insert into a values (3, -3, PADSTRING('three',1900), 3, PADSTRING('negative three',2000));
 1 row inserted/updated/deleted
-ij> insert into a values (2, -2, PADSTRING('two',1900),   2, PADSTRING('negative two',2000));
+ij(CONNECTION1)> insert into a values (2, -2, PADSTRING('two',1900),   2, PADSTRING('negative two',2000));
 1 row inserted/updated/deleted
-ij> insert into a values (1, -1, PADSTRING('one',1900),   1, PADSTRING('negtive one',2000));
+ij(CONNECTION1)> insert into a values (1, -1, PADSTRING('one',1900),   1, PADSTRING('negtive one',2000));
 1 row inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |6   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |A           |(3,6)     |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |A           |(4,6)     |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |X   |A           |(5,6)     |GRANT|ACTIVE  
-ij> commit;
-ij> delete from a where a.a = 3;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> delete from a where a.a = 3;
 1 row inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |2   |IX  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |2   |X   |A           |(3,6)     |GRANT|ACTIVE  
-ij> commit;
-ij> select a,b from a;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select a,b from a;
 A          |B          
 -----------------------
 1          |-1         
 2          |-2         
 4          |-4         
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test full read cursor scan over all the rows in the indexed heap, 
 -- no group fetch.  This should be a covered index scan (make sure rows come
 -- back in order sorted by index).
 --------------------------------------------------------------------------------
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','1');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b from a';
-ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
+ij(CONNECTION1)> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
 0 rows inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 1          |-1         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |S   |A           |(5,6)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 2          |-2         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |S   |A           |(4,6)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 4          |-4         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |S   |A           |(2,6)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
 APP     |UserTransaction|ROW     |1   |S   |A           |(1,7)     |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> close scan_cursor;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test full cursor scan over all the rows in the index , 2 row group fetch.
 --------------------------------------------------------------------------------
 CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','2');
 0 rows inserted/updated/deleted
-ij> -- RESOLVE: missing row locks
+ij(CONNECTION1)> -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b from a';
-ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
+ij(CONNECTION1)> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault','16');
 0 rows inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 1          |-1         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 2          |-2         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 4          |-4         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> close scan_cursor;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test full cursor scan over all the rows in the index, with default group
 -- fetch
 --------------------------------------------------------------------------------
+
 -- RESOLVE: missing row locks
 -- WORKAROUND: creating an index and dropping it 
 -- to force the query 'select a, b from a' to be recompiled
 create index ix1 on a(a);
 0 rows inserted/updated/deleted
-ij> drop index ix1;
+ij(CONNECTION1)> drop index ix1;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> get cursor scan_cursor as
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> get cursor scan_cursor as
     'select a, b from a';
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 1          |-1         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 2          |-2         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 4          |-4         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 A          |B          
 -----------------------
 5          |-5         
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> next scan_cursor;
+ij(CONNECTION1)> next scan_cursor;
 No current row
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |IS  |A           |Tablelock |GRANT|ACTIVE  
-ij> close scan_cursor;
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> close scan_cursor;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
-ij> commit;
-ij> --------------------------------------------------------------------------------
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> --------------------------------------------------------------------------------
 -- Test getting index lock on a drop index - track 1634
 --------------------------------------------------------------------------------
+
 drop table a;
 0 rows inserted/updated/deleted
-ij> commit;
-ij> create table a (a int);
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> create table a (a int);
 0 rows inserted/updated/deleted
-ij> create index a2 on a (a);
+ij(CONNECTION1)> create index a2 on a (a);
 0 rows inserted/updated/deleted
-ij> insert into a values (1);
+ij(CONNECTION1)> insert into a values (1);
 1 row inserted/updated/deleted
-ij> commit;
-ij> drop index a2;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> drop index a2;
 0 rows inserted/updated/deleted
-ij> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
+ij(CONNECTION1)> select * from lock_table order by tabname, type desc, mode, cnt, lockname;
 USERNAME|TRANTYPE       |TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
 ----------------------------------------------------------------------------------
 APP     |UserTransaction|TABLE   |1   |X   |*** TRANSIEN|Tablelock |GRANT|ACTIVE  
 WARNING 01004: Data truncation
 APP     |UserTransaction|TABLE   |3   |X   |A           |Tablelock |GRANT|ACTIVE  
-ij> commit;
-ij> drop table a;
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> drop table a;
 0 rows inserted/updated/deleted
-ij> 
+ij(CONNECTION1)> 



Mime
View raw message