--- Derby Network Server Runtime Information --- ---------- Session Information --------------- Session # :1 Database :harvestDatabase/fullhddb User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :2 Database :harvestDatabase/fullhddb User :APP # Statements:13 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0005 DELETE FROM seedlists WHERE seedlist_id = ? SYSLH0002 DELETE FROM config_passwords WHERE config_passwords.config_id = ? SYSLH0003 DELETE FROM passwords WHERE password_id = ? SYSLH0001 values current isolation SYSLH00012 INSERT INTO config_passwords ( config_id, password_id ) SELECT config_id, password_id FROM configurations, passwords WHERE configurations.domain_id = ? AND configurations.name = ? AND passwords.name = ? AND passwords.domain_id = configurations.domain_id SYSLH00013 UPDATE domains SET defaultconfig = (SELECT config_id FROM configurations WHERE domain_id = ? AND name = ?) WHERE domain_id = ? SYSLH00010 INSERT INTO config_seedlists ( config_id, seedlist_id ) SELECT configurations.config_id, seedlists.seedlist_id FROM configurations, seedlists WHERE configurations.name = ? AND seedlists.name = ? AND configurations.domain_id = ? AND seedlists.domain_id = ? SYSLH00011 UPDATE ownerinfo SET created = ?, info = ? WHERE ownerinfo_id = ? SYSLH0008 SELECT ownerinfo_id, created, info FROM ownerinfo WHERE domain_id = ? SYSLH0009 select IDENTITY_VAL_LOCAL() from SYSIBM.SYSDUMMY1 SYSLH0006 SELECT extendedfield_id FROM extendedfield WHERE extendedfieldtype_id = ? ORDER BY sequencenr ASC SYSLH0007 SELECT config_id, configurations.name, comments, ordertemplates.name, maxobjects, maxrate, maxbytes FROM configurations, ordertemplates WHERE domain_id = ? AND configurations.template_id = ordertemplates.template_id SYSLH0004 SELECT historyinfo_id, stopreason, objectcount, bytecount, name, job_id, harvest_id, harvest_time FROM historyinfo, configurations WHERE configurations.domain_id = ? AND historyinfo.config_id = configurations.config_id Session # :3 Database :harvestDatabase/fullhddb User :APP # Statements:13 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0005 UPDATE ownerinfo SET created = ?, info = ? WHERE ownerinfo_id = ? SYSLH0002 DELETE FROM config_seedlists WHERE config_seedlists.config_id = ? SYSLH0003 INSERT INTO config_passwords ( config_id, password_id ) SELECT config_id, password_id FROM configurations, passwords WHERE configurations.domain_id = ? AND configurations.name = ? AND passwords.name = ? AND passwords.domain_id = configurations.domain_id SYSLH0001 values current isolation SYSLH00012 DELETE FROM config_passwords WHERE config_passwords.config_id = ? SYSLH00013 UPDATE domains SET defaultconfig = (SELECT config_id FROM configurations WHERE domain_id = ? AND name = ?) WHERE domain_id = ? SYSLH00010 DELETE FROM configurations WHERE config_id = ? SYSLH00011 INSERT INTO historyinfo ( stopreason, objectcount, bytecount, config_id, job_id, harvest_id, harvest_time ) VALUES ( ?, ?, ?, ?, ?, ?, ? ) SYSLH0008 select IDENTITY_VAL_LOCAL() from SYSIBM.SYSDUMMY1 SYSLH0009 UPDATE historyinfo SET stopreason = ?, objectcount = ?, bytecount = ?, config_id = (SELECT config_id FROM configurations, domains WHERE domains.domain_id = ? AND configurations.name = ? AND configurations.domain_id = domains.domain_id), harvest_id = ?, job_id = ? WHERE historyinfo_id = ? SYSLH0006 SELECT job_id FROM jobs WHERE status = ? AND priority = ? ORDER BY job_id SYSLH0007 DELETE FROM seedlists WHERE seedlist_id = ? SYSLH0004 INSERT INTO config_seedlists ( config_id, seedlist_id ) SELECT configurations.config_id, seedlists.seedlist_id FROM configurations, seedlists WHERE configurations.name = ? AND seedlists.name = ? AND configurations.domain_id = ? AND seedlists.domain_id = ? Session # :4 Database :harvestDatabase/fullhddb User :APP # Statements:3 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0002 UPDATE runningJobsMonitor SET jobId=?, harvestName=?, elapsedSeconds=?, hostUrl=?, progress=?, queuedFilesCount=?, totalQueuesCount=?, activeQueuesCount=?, retiredQueuesCount=?, exhaustedQueuesCount=?, alertsCount=?, downloadedFilesCount=?, currentProcessedKBPerSec=?, processedKBPerSec=?, currentProcessedDocsPerSec=?, processedDocsPerSec=?, activeToeCount=?, status=?, tstamp=? WHERE jobId=? AND harvestName=? SYSLH0003 SELECT schedule_id, comments, startdate, enddate, maxrepeats, timeunit, numtimeunits, anytime, onminute, onhour, ondayofweek, ondayofmonth, edition FROM schedules WHERE name = ? SYSLH0001 values current isolation Session # :5 Database :harvestDatabase/fullhddb User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :6 Database :harvestDatabase/fullhddb User :APP # Statements:2 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0002 SELECT jobId, harvestName, elapsedSeconds, hostUrl, progress, queuedFilesCount, totalQueuesCount, activeQueuesCount, retiredQueuesCount, exhaustedQueuesCount, alertsCount, downloadedFilesCount, currentProcessedKBPerSec, processedKBPerSec, currentProcessedDocsPerSec, processedDocsPerSec, activeToeCount, status, tstamp FROM runningJobsHistory WHERE jobId=? ORDER BY elapsedSeconds ASC SYSLH0001 values current isolation Session # :7 Database :harvestDatabase/fullhddb User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :8 Database :harvestDatabase/fullhddb User :APP # Statements:2 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0002 SELECT version FROM schemaversions WHERE tablename = ? SYSLH0001 values current isolation Session # :9 Database :harvestDatabase/fullhddb User :APP # Statements:1 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0001 values current isolation Session # :10 Database :harvestDatabase/fullhddb User :APP # Statements:5 Prepared Statement Information: Stmt ID SQLText ------------- ----------- SYSLH0004 SELECT password_id, name, comments, url, realm, username, password FROM passwords WHERE domain_id = ? SYSLH0005 UPDATE runningJobsMonitor SET jobId=?, harvestName=?, elapsedSeconds=?, hostUrl=?, progress=?, queuedFilesCount=?, totalQueuesCount=?, activeQueuesCount=?, retiredQueuesCount=?, exhaustedQueuesCount=?, alertsCount=?, downloadedFilesCount=?, currentProcessedKBPerSec=?, processedKBPerSec=?, currentProcessedDocsPerSec=?, processedDocsPerSec=?, activeToeCount=?, status=?, tstamp=? WHERE jobId=? AND harvestName=? SYSLH0002 SELECT config_id, configurations.name, comments, ordertemplates.name, maxobjects, maxrate, maxbytes FROM configurations, ordertemplates WHERE domain_id = ? AND configurations.template_id = ordertemplates.template_id SYSLH0003 SELECT fullharvests.harvest_id FROM fullharvests, harvestdefinitions, harvestdefinitions AS currenthd WHERE currenthd.harvest_id=? AND fullharvests.harvest_id = harvestdefinitions.harvest_id AND harvestdefinitions.submitted < currenthd.submitted ORDER BY harvestdefinitions.submitted DESC SYSLH0001 values current isolation Session # :41 ------------------------------------------------------------- # Connection Threads : 11 # Active Sessions : 11 # Waiting Sessions : 0 Total Memory : 64356352 Free Memory : 58657576