I am running Derby 10.9.1.0 and am trying to figure out a  performance problem with query taking too long.   I don’t actually want to run the query so from the documentation, I try:

 

call syscs_util.syscs_set_runtimestatistics(1);

call syscs_util.syscs_set_xplain_schema('STATS');

call syscs_util.syscs_set_xplain_mode(1);

--- my query here

call syscs_util.syscs_set_runtimestatistics(0);

call syscs_util.syscs_set_xplain_schema('');

call syscs_util.syscs_set_xplain_mode(0);

 

When it runs my query, I get:

 

ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted. Verify that autocommit is OFF.

 

I try the following with IJ just to see:

 

call syscs_util.syscs_set_runtimestatistics(1);

call syscs_util.syscs_set_xplain_schema('STATS');

call syscs_util.syscs_set_xplain_mode(1);

select sql_text from syscs_diag.transaction_table where status != 'IDLE';

call syscs_util.syscs_set_runtimestatistics(0);

call syscs_util.syscs_set_xplain_schema('');

call syscs_util.syscs_set_xplain_mode(0);

 

And still get the same error.   Could someone try this on their system and see if it works.  It would be most appreciated.

 

Brett