Cloudscape 10.1 runtime statics

Hello;
I have been searching the internet about cloudscape and trying to tune the database for a specific sql query. After find several guides From various FAQ's on the internet running 'VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();' after a select statement should retrun various useful statics tuning my db.

If I write a simple select: "select * from customer;" the SYSCS_GET_RUNTIMESTATISTICS() returns some simple information. Nothing on the level of what is documented in the various cloudscape tuning guides. When I run my really complex business query, I get no statics. All that returns is the select statement.


Any suggestion on how to force cloudscape to verbosely tell me what it is doing and where it is spending it's time? Below is the sequence of steps I perform to get query statics.

CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);

select MANY_COLUMNS, .... from INSANELY_COMPLEX_INNER_AND_OUTER_JOIN_QUERY_WITH_CORROLATED_SUBQUERIES_THAT_TAKES_THREE_SECONDS_IN_D B2_ON_IBM_MONSTER_MAINFRAME;

VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();

CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0);



Thanks for any help