...
If you want to run any SQL command on this database make sure you select test from the Use DB: pull-down menu, enter the SQL command and then click the Run SQL button. The results of the command will be displayed near the bottom of the portlet.
Configuring the location of system Derby databases
By default, all system databases are created in the /var/derby
directory when Geronimo server starts up for the first time. You can override the default derbySystemHome attribute of the DerbySystem GBean. Find the system-database module in /var/config/config.xml
and it looks like as below:
...