sa_conn_compression_info system procedure

sa_conn_compression_info( [ connidparm ] )

connidparm Use this optional INTEGER parameter to specify the connection ID number. The default is NULL.

Column name	Data type	Description
Type	VARCHAR(20)	Returns a string identifying whether the compression statistics that follow represent either one connection (Connection), or all connections to the server (Server).
ConnNumber	INTEGER	Returns an INTEGER representing a connection ID number. Returns NULL if the Type is Server.
Compression	VARCHAR(10)	Returns On or Off to indicate whether communication compression is enabled on the connection. Returns NULL if the Type is Server, or ON/OFF if the Type is Connection.
TotalBytes	INTEGER	Returns an INTEGER representing the total number of actual bytes both sent and received.
TotalBytesUnComp	INTEGER	Returns an INTEGER representing the number of bytes that would have been sent and received if compression were disabled.
CompRate	NUMERIC(5,2)	Returns a NUMERIC (5,2) value representing the overall compression rate. For example, a value of 0 indicates that no compression occurred. A value of 75 indicates that the data was compressed by 75%, or down to one quarter of its original size.
CompRateSent	NUMERIC(5,2)	Returns a NUMERIC (5,2) value representing the compression rate for data sent to the client.
CompRateReceived	NUMERIC(5,2)	Returns a NUMERIC (5,2) value representing the compression rate for data received from the client.
TotalPackets	INTEGER	Returns an INTEGER representing the total number of actual packets both sent and received.
TotalPacketsUnComp	INTEGER	Returns an INTEGER representing the total number of packets that would have been sent and received if compression was disabled.
CompPktRate	NUMERIC(5,2)	Returns a NUMERIC (5,2) value representing the overall compression rate of packets.
CompPktRateSent	NUMERIC(5,2)	Returns a NUMERIC (5,2) value representing the compression rate of packets sent to the client.
CompPktRateReceived	NUMERIC(5,2)	Returns a NUMERIC (5,2) value representing the compression rate of packets received from the client.

If connidparm is less than zero, then a result set consisting of compression properties for the current connection is returned. If connidparm is not supplied or is NULL, then compression properties are returned for all connections to all databases running on the database server.

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

List of connection properties

The following example uses the sa_conn_compression_info system procedure to return a result set summarizing compression properties for all connections to the server.

CALL sa_conn_compression_info( );

Type	ConnNumber	Compression	TotalBytes	...
Connection	79	Off	7841	...
Server	(NULL)	(NULL)	2737761	...
...	...	...	...	...

sa_conn_compression_info system procedure

Syntax

Arguments

Result set

Remarks

Privileges

Side effects

See also

Example