sa_performance_statistics( )

The sa_performance_statistics system procedure returns a result set consisting of a set of memory diagnostic statistics if the server has been told to collect the information. Recording of memory diagnostic statistics must be turned on the database server before calling sa_performance_statistics. To do this, specify the -zt option when starting the database server or execute the following:

CALL sa_server_option( 'RequestTiming','ON' );

DBA authority

None

• -zt dbeng12/dbsrv12 server option
• sa_performance_diagnostics system procedure
• sa_server_option system procedure

The following example unloads all performance statistics to a text file named dump_stats.txt:

UNLOAD
   SELECT CURRENT TIMESTAMP, *
   FROM sa_performance_statistics()
   TO 'dump_stats.txt'
   APPEND ON;