Index: branches/eam_branches/ipp-20140717/ippToPsps/jython/dvo.py
===================================================================
--- branches/eam_branches/ipp-20140717/ippToPsps/jython/dvo.py	(revision 37238)
+++ branches/eam_branches/ipp-20140717/ippToPsps/jython/dvo.py	(revision 37239)
@@ -63,5 +63,4 @@
         # this scratch Db either has no DVO info ingested, or a different DVO ingested. Prompt user
         if not self.correctDvo:
-            print "*******************************************************************************"
             self.logger.warning("switching to a new dvo: '" + self.skychunk.dvoLocation + "'")
             # response = raw_input("(y/n) ")
@@ -105,5 +104,5 @@
 
         if (self.skychunk.dvoLocation == 'none'):
-            print "do not load Photcodes for place-holder DVO " + self.skychunk.dvoLocation
+            # print "do not load Photcodes for place-holder DVO " + self.skychunk.dvoLocation
             return False
 
@@ -160,5 +159,5 @@
 
         if (self.skychunk.dvoLocation == 'none'):
-            print "do not load SkyTable for place-holder DVO " + self.skychunk.dvoLocation
+            # print "do not load SkyTable for place-holder DVO " + self.skychunk.dvoLocation
             return False
 
Index: branches/eam_branches/ipp-20140717/ippToPsps/jython/gpc1db.py
===================================================================
--- branches/eam_branches/ipp-20140717/ippToPsps/jython/gpc1db.py	(revision 37238)
+++ branches/eam_branches/ipp-20140717/ippToPsps/jython/gpc1db.py	(revision 37239)
@@ -117,6 +117,4 @@
             stage = "forcedwarp"
             sql = "SELECT differentStuff from Stufftable"
-
-        self.logger.infoPair("sql for pending:", sql)
 
         try:
Index: branches/eam_branches/ipp-20140717/ippToPsps/jython/ipptopsps.py
===================================================================
--- branches/eam_branches/ipp-20140717/ippToPsps/jython/ipptopsps.py	(revision 37238)
+++ branches/eam_branches/ipp-20140717/ippToPsps/jython/ipptopsps.py	(revision 37239)
@@ -55,5 +55,4 @@
             raise
 
-        print "check client status"
         self.checkClientStatus()
 
@@ -143,8 +142,6 @@
     def checkClientStatus(self):
 
-        print "updateClient (add this process to client table)"
         self.ippToPspsDb.updateClient(self.config.programName, self.HOST, self.PID)
 
-        print "check if isKilled (has someone killed me?)"
         if self.ippToPspsDb.isKilled(self.HOST, self.PID): 
             self.exitProgram("killed via Db")
@@ -152,9 +149,5 @@
         # this loop pauses the process if we have no skychunk or we have set it to pause
         firstTimeIn = True
-        print "refreshSkychunk"
         while not self.refreshSkychunk() or self.ippToPspsDb.isPaused(self.HOST, self.PID):
-
-            print "looping in ipptopsps"
-
             self.ippToPspsDb.updateClient(self.config.programName, self.HOST, self.PID)
             if self.ippToPspsDb.isKilled(self.HOST, self.PID): 
@@ -163,6 +156,4 @@
             firstTimeIn = False
             time.sleep(self.PAUSEPERIOD)
-
-        print "DONE looping in ipptopsps"
 
     '''
Index: branches/eam_branches/ipp-20140717/ippToPsps/jython/ipptopspsdb.py
===================================================================
--- branches/eam_branches/ipp-20140717/ippToPsps/jython/ipptopspsdb.py	(revision 37238)
+++ branches/eam_branches/ipp-20140717/ippToPsps/jython/ipptopspsdb.py	(revision 37239)
@@ -1259,6 +1259,4 @@
                 AND batch_type = '" + batchType + "'")
 
-        print "deleted old items"
-
         for id in ids:
             sql = "INSERT IGNORE INTO pending \
@@ -1267,9 +1265,8 @@
                (" + str(box_id) + ", '" + batchType + "', " + str(id) + ")"
 
-            print "sql: ", sql
-
             try: self.execute(sql)
             except:
                 print "failed to insert into pending"
+                print "sql: " + sql
                 raise
 
@@ -1296,6 +1293,4 @@
                GROUP BY ra_center LIMIT 1"
 
-        # XXX print "sql: ", sql               
-
         try: rs = self.executeQuery(sql)
         except:
@@ -1303,5 +1298,4 @@
             print "SQL: " + sql
 
-        print "SQL: " + sql
         if not rs.next():
             self.logger.errorPair("No outstanding boxes", "nothing to do here")
@@ -1384,5 +1378,4 @@
             print "SQL: " + sql
 
-        print "SQL: " + sql
         if not rs.next():
             self.logger.infoPair("No outstanding boxes", "nothing to do here")
@@ -1620,5 +1613,5 @@
                        VALUES ( '" + dvo_db + "', '" + batchType + "'," + str(row[0]) + "," + str(row[1]) + " \
                        , " + str(row[2]) + ", '"+uniq+"' ) " 
-                print "sql 1: ", sql
+                # print "sql 1: ", sql
                 self.execute(sql)
             except: continue
@@ -1641,11 +1634,8 @@
                AND dec_bore BETWEEN " + str(minDEC) + " AND " + str(maxDEC)
 
-        print "items: ", sql
-
         try:
             rs = self.executeQuery(sql)
             while (rs.next()): 
                 ids.append(rs.getInt(1))
-                print "stage_id: " + str(rs.getInt(1))
         except:
             self.logger.errorPair("Can't get items in this box", sql)
Index: branches/eam_branches/ipp-20140717/ippToPsps/jython/scratchdb.py
===================================================================
--- branches/eam_branches/ipp-20140717/ippToPsps/jython/scratchdb.py	(revision 37238)
+++ branches/eam_branches/ipp-20140717/ippToPsps/jython/scratchdb.py	(revision 37239)
@@ -482,5 +482,5 @@
         try: self.execute(sql)
         except: 
-            print "problem dropping DVO " + dvoDetectionTable
+            self.logger.errorPair("problem dropping DVO table", dvoDetectionTable)
             pass
 
@@ -561,8 +561,9 @@
 
        # we need a big enough memory table for the incoming detections
-       print "requested memory in gigs: ", self.memoryTableSize
+       # print "requested memory in gigs: ", self.memoryTableSize
        tableSize = int(self.memoryTableSize) * 1024 * 1024 * 1024
+       self.logger.infoPair("setting max heap size: ", tableSize)
+
        sql = "set @@max_heap_table_size = " + str(tableSize)
-       print "setting max heap size: ", sql
        try: self.execute(sql)
        except: