The following MaxL script creates an output file of performance statistics tables.
/* to execute: essmsh scriptname username password */ login $1 $2; spool on to 'c:\mxlouts\pstatsouts.txt'; alter database sample.basic set performance statistics enabled; execute calculation 'SET MSG ERROR; CALC ALL;' on Sample.basic; alter database sample.basic set performance statistics mode to medium persistence server scope; query database sample.basic get performance statistics kernel_io table; alter database sample.basic set performance statistics mode to long persistence database scope; query database sample.basic get performance statistics kernel_cache table; alter database sample.basic set performance statistics mode to medium persistence database scope; query database sample.basic get performance statistics end_transaction table; query database sample.basic get performance statistics database_synch table; query database sample.basic get performance statistics database_asynch table; spool off; logout;