DbVisualizer 9.x consumes 100% CPU on execute

Hi! I'm using Ubuntu 14.04 64-bit and java 1.7.0_60 64-bit. I'm connected to DB2 database. The problem I have is this: - whenever I run a procedure that runs for a minute or two one CPU gets to 100% and stays there until the procedure is finished I've attached two thread dumps of DbVisualizer 9.1.9. Thread dumps were taken couple of seconds apart. I hope you will find the cause and fix it. Best regards, Kovi

Hi Kovica, It seems like the driver is trying to read the result in a loop. Which JDBC driver do you use? If there's a later version, please try to upgrade to see if that makes a difference. Best Regards, Hans

Hi! Thanks for the reply. I've DB2 upgraded driver to latest version and still experience the same symptoms. dbvis3.txt and dbvis4.txt are two stack traces I took couple of seconds inbetween. Just to point out. I've been trying IntelliJ's 0xDBE tool and I don't get the same sympthoms there, so I imagine it is not the drivers fault. Best regards, Kovi

Hi Kovica, Other than the JDBC driver, the only thread running when executing a query or procedures is the animated GIF showing progress in the SQL Commander tab and the main window status bar. There is an issue with animated GIFs in Java, especially in tabs, where the CPU peaks abnormally. Here is the bug report: https://bugs.openjdk.java.net/browse/JDK-6306909 Typically, this has no or just minor performance implications, but one workaround you can do is to replace the animated gif icon with a static image. Do as follows: 1) Open the Finder and navigate to DbVisualizer.app/Contents/Resources/app/resources 2) Create a new images folder 3) Save attached file in the images folder as *animatedProgress1.gif* 4) Re-start DbVisualizer and check whether the CPU is affected Please let us know the progress. Best Regards, Hans Edited by: Hans Bergsten on Jun 23, 2014 9:12 PM

I'm using Linux. Where should I put the image there?

This is solved. :) Now CPU is low, at 5% during the execution time. Great. Best regards, Kovi

Great. :) Thanks. Kovica

Hi! Great news. I've tried it and it is working. Thanks.