--- Derby Network Server Runtime Information --- ---------- Session Information --------------- Session # :1 Database :adminDB User :APP # Statements:4 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0004 INSERT INTO replicafileinfo (file_id, replica_id, filelist_status, checksum_status, upload_status ) VALUES ( ?, ?, ?, ?, ? ) SYSLH0003 select IDENTITY_VAL_LOCAL() from SYSIBM.SYSDUMMY1 SYSLH0002 SELECT upload_status FROM replicafileinfo, file WHERE replicafileinfo.file_id = file.file_id AND file.filename = ? AND replica_id = ? SYSLH0001 values current isolation Session # :2 Database :adminDB User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :3 Database :adminDB User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :4 Database :adminDB User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :5 Database :adminDB User :APP # Statements:4 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0004 INSERT INTO replicafileinfo (file_id, replica_id, filelist_status, checksum_status, upload_status ) VALUES ( ?, ?, ?, ?, ? ) SYSLH0003 select IDENTITY_VAL_LOCAL() from SYSIBM.SYSDUMMY1 SYSLH0002 UPDATE replicafileinfo SET upload_status = ?, filelist_status = ?, checksum_status = ? WHERE replica_id = ? AND file_id = ? SYSLH0001 values current isolation Session # :6 Database :adminDB User :APP # Statements:2 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0002 SELECT replica_id FROM replica SYSLH0001 values current isolation Session # :7 Database :adminDB User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :8 Database :adminDB User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :9 Database :adminDB User :APP # Statements:2 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0002 SELECT checksum_updated FROM replica WHERE replica_id = ? SYSLH0001 values current isolation Session # :10 Database :adminDB User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :20 ------------------------------------------------------------- # Connection Threads : 11 # Active Sessions : 11 # Waiting Sessions : 0 Total Memory : 64356352 Free Memory : 61730928