sa_conn_activity( [ connidparm ] )

If connidparm is less than zero, then information for the current connection is returned. If connidparm is not supplied or is NULL, then information is returned for all connections to all databases running on the database server.

The sa_conn_activity system procedure returns a result set consisting of the most recently-prepared SQL statement for the connection. Recording of statements must be enabled for the database server before calling sa_conn_activity. To do this, specify the -zl option when starting the database server, or execute the following:

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

This procedure is useful when the database server is busy and you want to obtain information about the last SQL statement prepared for each connection. This feature can be used as an alternative to request logging.

Cloud note: Because of tenant database isolation rules, when this system procedure is run in the cloud it returns only information about the current tenant database.

No privileges are required to execute this system procedure for the current connection ID. To execute this system procedure for other connections, you must have either the SERVER OPERATOR, MONITOR, or DROP CONNECTION system privilege.

None

• -zl database server option
• sa_server_option system procedure
• Propriété de connexion Name
• List of connection properties

The following example uses the sa_conn_activity system procedure to display the most recently-prepared SQL statement for each connection.

CALL sa_conn_activity( );