查看连接Sybase IQ的客户端信息
sp_iqconnection
1 SQL_DBC_81daa0 DBA 2014-03-05 16:48:46.208 ...
2 SQL_DBC_7f254c334770 DBA 2014-03-06 10:58:13.462 ...
8 SQL_DBC_969800 DBA 2014-03-06 10:58:59.619 ...
select @@spid,@@version,@@servername,db_name()
(DBA)> select @@spid,@@version,@@servername,db_name()
@@spid @@version @@servername db_name()
----------------------------------------------------------------------------------------------------------------------------------------------------------
8 Sybase IQ/15.2.0.5604/100518/P/GA/Enterprise Linux64 - x86_64 - 2.6.9-67.0.4.ELsmp/64bit/2010-05-18 09:16:50 linux91_iqdemo iqdemo
删除客户端连接
drop connection 1
查看客户端连接的详细信息
sp_iqcontext
通过执行以下语句来禁止到服务器的连接:
CALL sa_server_option('disable_connections', 'ON')
通过执行以下语句列出到该数据库的所有连接:
CALL sa_conn_info()
删除客户端连接
drop connection [number]
通过执行以下语句重新启用到服务器的连接:
CALL sa_server_option('disable_connections', 'OFF')
call sa_server_option('request_level_logging','SQL')
call sa_server_option('request_level_log_file','e:\sqllog.txt')
sp_iqconnection
1 SQL_DBC_81daa0 DBA 2014-03-05 16:48:46.208 ...
2 SQL_DBC_7f254c334770 DBA 2014-03-06 10:58:13.462 ...
8 SQL_DBC_969800 DBA 2014-03-06 10:58:59.619 ...
select @@spid,@@version,@@servername,db_name()
(DBA)> select @@spid,@@version,@@servername,db_name()
@@spid @@version @@servername db_name()
----------------------------------------------------------------------------------------------------------------------------------------------------------
8 Sybase IQ/15.2.0.5604/100518/P/GA/Enterprise Linux64 - x86_64 - 2.6.9-67.0.4.ELsmp/64bit/2010-05-18 09:16:50 linux91_iqdemo iqdemo
删除客户端连接
drop connection 1
查看客户端连接的详细信息
sp_iqcontext
通过执行以下语句来禁止到服务器的连接:
CALL sa_server_option('disable_connections', 'ON')
通过执行以下语句列出到该数据库的所有连接:
CALL sa_conn_info()
删除客户端连接
drop connection [number]
通过执行以下语句重新启用到服务器的连接:
CALL sa_server_option('disable_connections', 'OFF')
call sa_server_option('request_level_logging','SQL')
call sa_server_option('request_level_log_file','e:\sqllog.txt')