Troubleshooting Visual Explain

The SQL command did not execute when I pressed [Enter].

The [Enter] key enables you to create multi-line SQL commands. To execute an SQL command, either click on the blue "explain" icon, select Statement -> Explain, or press [Ctrl]-[Enter].

The Edit, Copy, or Delete button on the Configure window is grayed-out.

You need to select a database connection before you can perform these operations. For example, select the database connection you want to edit by clicking on it, then click on Edit.

I get a warning about lock files when I open a second copy of Visual Explain concurrently or after Visual Explain has exited abnormally.

Visual Explain is designed to run only as a single copy. The first copy creates a lock file that prevents other copies from saving configuration data. All other functions behave normally.

The EXPLAIN button is disabled

The EXPLAIN button remains disabled until you have established a connection to a database. See the Section called Using Visual Explain.

On a multi-processor system, Visual Explain hangs (IBM JRE only)

To run the IBM JRE on a multiprocessor system with Red Hat Linux, you first need to kill any java processes currently running, then set the LD_ASSUME_KERNEL environment variable. Depending on your shell, use either:
export LD_ASSUME_KERNEL=2.2.5
or
setenv LD_ASSUME_KERNEL 2.2.5