[精华] ASE12.5全局变量(仅供参考,非官方资料,本人个人积累) |
|---|
|
| 来源 chinaunix.net 酷勤网整理 |
@@authmech
,@@monitors_active
,@@version_number
,@@msgschema
,@@msgreplytoinfo
,@@msgstatusinfo
,@@msgstatus
,@@msgid
,@@msgtimestamp
,@@msgproperties
,@@msgheader
,@@recovery_state
,@@max_precision
,@@lock_timeout
,@@datefirst
,@@tempdbid
,@@bootcount
,@@boottime
,@@bulkarraysize
,@@bulkbatchsize
,@@stringsize
,@@invalidsuid
,@@maxspid
,@@minspid
,@@version_as_integer
,@@unicharsize
,@@min_poolsize
,@@heapmemsize
,@@maxpagesize
,@@invaliduserid
,@@guestuserid
,@@probesuid
,@@maxgroupid
,@@mingroupid
,@@maxuserid
,@@minuserid
,@@maxsuid
,@@minsuid
,@@ha_local_nodeid
,@@crthaproxy
,@@errorlog
,@@haconnection
,@@failedoverconn
,@@hacmpservername
,@@cmpstate
,@@remotestate
,@@localstate
,@@nodeid
,@@curloid
,@@textptr_parameters
,@@transactional_rpc
,@@cis_rpc_handling
,@@cis_version
,@@scan_parallel_degree
,@@parallel_degree
,@@textcolid
,@@textdbid
,@@textobjid
,@@textts
,@@textptr
,@@identity
,@@mempool_addr
,@@shmem_flags
,@@kernel_size
,@@kernel_addr
,@@transtate
,@@char_convert
,@@maxcharlen
,@@client_csexpansion
,@@client_csname
,@@client_csid
,@@ncharsize
,@@thresh_hysteresis
,@@pagesize
,@@langid
,@@language
,@@servername
,@@isolation
,@@tranchained
,@@textsize
,@@spid
,@@max_connections
,@@dbts
,@@timeticks
,@@options
,@@total_errors
,@@total_write
,@@total_read
,@@packet_errors
,@@connections
,@@pack_sent
,@@pack_received
,@@idle
,@@io_busy
,@@cpu_busy
,@@version
,@@trancount
,@@nestlevel
,@@procid
,@@rowcount
,@@error
,@@sqlstatus
onku 回复于：2005-04-20 13:59:31
@@authmech
@@bootcount
@@boottime
@@bulkarraysize
@@bulkbatchsize
@@char_convert
@@cis_rpc_handling
@@cis_version
@@client_csexpansion
@@client_csid
@@client_csname
@@cmpstate
@@connections
@@cpu_busy
@@curloid
@@datefirst
@@dbts
@@error
@@errorlog
@@failedoverconn
@@guestuserid
@@hacmpservername
@@haconnection
@@heapmemsize
@@identity
@@idle
@@invaliduserid
@@io_busy
@@isolation
@@kernel_addr
@@kernel_size
@@langid
@@language
@@lock_timeout
@@maxcharlen
@@maxgroupid
@@maxpagesize
@@maxspid
@@maxsuid
@@maxuserid
@@max_connections
@@max_precision
@@mempool_addr
@@mingroupid
@@minspid
@@minsuid
@@minuserid
@@min_poolsize
@@monitors_active
@@ncharsize
@@nestlevel
@@nodeid
@@options
@@packet_errors
@@pack_received
@@pack_sent
@@pagesize
@@parallel_degree
@@probesuid
@@procid
@@recovery_state
@@rowcount
@@scan_parallel_degree
@@servername
@@shmem_flags
@@spid
@@sqlstatus
@@ssl_ciphersuite
@@stringsize
@@tempdbid
@@textcolid
@@textdbid
@@textobjid
@@textptr
@@textptr_parameters
@@textsize
@@textts
@@thresh_hysteresis
@@timeticks
@@total_errors
@@total_read
@@total_write
@@tranchained
@@trancount
@@transactional_rpc
@@transtate
@@unicharsize
@@version
@@version_as_integer
livefordie 回复于：2005-04-21 14:35:07
我正想了解这方面的内容，变量这么多，怎么知道它们对应的都是什么意思？
hobbylu 回复于：2005-04-21 14:53:57
你可以自己去判断,去select看什么东西
gsx 回复于：2005-04-22 14:37:00
蠻有用的文件,謝謝囉,馬上去試試
fbirds 回复于：2005-05-25 10:45:18
8) 很不错的东西,谢谢楼主啦!:)
jys1059 回复于：2005-05-25 13:40:37
如何执行这些全局变量，我执行后显示如下
1>; select @@version_number
2>; go
Msg 137, Level 15, State 2:
Line 1:
Must declare variable '@@version_number'.
hobbylu 回复于：2005-05-25 14:30:43
你的版本估计比较低,这个是12.5版本以上的
wangchy_love 回复于：2007-06-27 16:11:21
不错，收到，感谢！！！
Linuxcn.com 回复于：2007-06-28 09:45:54
引用：原帖由 jys1059 于 2005-5-25 13:40 发表
如何执行这些全局变量，我执行后显示如下
1>; select @@version_number
2>; go
Msg 137, Level 15, State 2:
Line 1:
Must declare variable '@@version_number'.
直接select @@version就可以吧
beginner-bj 回复于：2007-06-28 09:55:55
这是我不久前的学习记录，所有的全局变量都是从sybase网站下载的quickrefzh.pdf中导出来的，共85个。
cat "C:\Documents and Settings\Administrator\桌面\quickrefzh.txt" | grep @@
#sed -e 's/返/ /' -e 's/对/ /' -e 's/如/ /' -e 's/使/ /' 1 | grep -v }| awk '$1 ~ /^@@/ {print "select "$1"\ngo"}'
sed -e 's/返/ /' -e 's/对/ /' -e 's/如/ /' -e 's/使/ /' -e 's/.*}//' 1 |awk '$1 ~ /^@@/ {print $1}' |uniq |awk '{print "select "$1"\ngo"}'
isql -Usa -Pbbbbbb -S%COMPUTERNAME% -e -i1.txt -o2.txt
2.txt
sed -e 's/返/ /' -e 's/对/ /' -e 's/如/ /' -e 's/使/ /' -e 's/.*}//' 1 |awk '$1 ~ /^@@/ {print $1}' |uniq | wc
85 85 1120
1> select @@bootcount
-----------
30
(1 row affected)
1> select @@boottime
--------------------------
Jun 6 2007 1:06PM
(1 row affected)
1> select @@bulkarraysize
-----------
50
(1 row affected)
1> select @@bulkbatchsize
-----------
0
(1 row affected)
1> select @@char_convert
---
1
(1 row affected)
1> select @@cis_rpc_handling
-----------
0
(1 row affected)
1> select @@cis_version
------------------------------------------------------------------------------------------------------------------------------
libomni1 - Component Integration Services/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/a
se1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004
(1 row affected)
1> select @@client_csexpansion
-----------
1
(1 row affected)
1> select @@client_csid
------
1
(1 row affected)
1> select @@client_csname
------------------------------
iso_1
(1 row affected)
1> select @@cmpstate
-----------
-2
(1 row affected)
1> select @@connections
-----------
15
(1 row affected)
1> select @@cpu_busy
-----------
22
(1 row affected)
1> select @@curloid
-----------
60
(1 row affected)
1> select @@datefirst
---
7
(1 row affected)
1> select @@dbts
------------------
0x00000000afb30000
(1 row affected)
1> select @@error
-----------
0
(1 row affected)
1> select @@errorlog
--------------------------------------------
C:\sybase\ASE-12_5\install\HP12770113212.log
(1 row affected)
1> select @@failedoverconn
-----------
0
(1 row affected)
1> select @@guestuserid
-----------
2
(1 row affected)
1> select @@hacmpservername
------------------------------
NULL
(1 row affected)
1> select @@haconnection
-----------
0
(1 row affected)
1> select @@heapmemsize
-----------
1265664
(1 row affected)
1> select @@identity
-----------------------------------------
0
(1 row affected)
1> select @@idle
-----------
74229
(1 row affected)
1> select @@invaliduserid
-----------
-1
(1 row affected)
1> select @@io_busy
-----------
20
(1 row affected)
1> select @@isolation
-----------
1
(1 row affected)
1> select @@kernel_addr
------------------------------
0x20000000
(1 row affected)
1> select @@kernel_size
------------------------------
0x2594000
(1 row affected)
1> select @@langid
------
0
(1 row affected)
1> select @@language
------------------------------
us_english
(1 row affected)
1> select @@lock_timeout
-----------
-1
(1 row affected)
1> select @@maxcharlen
---
1
(1 row affected)
1> select @@max_connections
-----------
99992
(1 row affected)
1> select @@maxgroupid
-----------
1048576
(1 row affected)
1> select @@maxpagesize
-----------
2048
(1 row affected)
1> select @@max_precision
-----------
38
(1 row affected)
1> select @@maxspid
-----------
73
(1 row affected)
1> select @@maxsuid
-----------
2147483647
(1 row affected)
1> select @@maxuserid
-----------
2147483647
(1 row affected)
1> select @@mempool_addr
------------------------------
0x20197800
(1 row affected)
1> select @@mingroupid
-----------
16384
(1 row affected)
1> select @@min_poolsize
-----------
512
(1 row affected)
1> select @@minspid
-----------
1
(1 row affected)
1> select @@minsuid
-----------
-32768
(1 row affected)
1> select @@minuserid
-----------
-32768
(1 row affected)
1> select @@ncharsize
---
1
(1 row affected)
1> select @@nestlevel
-----------
0
(1 row affected)
1> select @@nodeid
------------
ebb7c9eec7d9
(1 row affected)
1> select @@options
--------------------
0x80210000000f014403
(1 row affected)
1> select @@packet_errors
-----------
1
(1 row affected)
1> select @@pack_received
-----------
623
(1 row affected)
1> select @@pack_sent
-----------
2166
(1 row affected)
1> select @@pagesize
-----------
2048
(1 row affected)
1> select @@parallel_degree
-----------
0
(1 row affected)
1> select @@probesuid
-----------
2
(1 row affected)
1> select @@procid
-----------
0
(1 row affected)
1> select @@rowcount
-----------
1
(1 row affected)
1> select @@scan_parallel_degree
-----------
0
(1 row affected)
1> select @@servername
------------------------------
HP12770113212
(1 row affected)
1> select @@shmem_flags
-----------
4185
(1 row affected)
1> select @@spid
------
30
(1 row affected)
1> select @@sqlstatus
-----------
0
(1 row affected)
1> select @@stringsize
-----------
50
(1 row affected)
1> select @@tempdbid
------
2
(1 row affected)
1> select @@textcolid
------
0
(1 row affected)
1> select @@textdbid
------
0
(1 row affected)
1> select @@textobjid
-----------
0
(1 row affected)
1> select @@textptr
----------------------------------
0x00000000000000000000000000000000
(1 row affected)
1> select @@textptr_parameters
-----------
0
(1 row affected)
1> select @@textsize
-----------
32768
(1 row affected)
1> select @@textts
------------------
0x0000000000000000
(1 row affected)
1> select @@thresh_hysteresis
-----------
64
(1 row affected)
1> select @@timeticks
-----------
100000
(1 row affected)
1> select @@total_errors
-----------
0
(1 row affected)
1> select @@total_read
-----------
2648
(1 row affected)
1> select @@total_write
-----------
464
(1 row affected)
1> select @@tranchained
-----------
0
(1 row affected)
1> select @@trancount
-----------
0
(1 row affected)
1> select @@transactional_rpc
-----------
1
(1 row affected)
1> select @@transtate
-----------
1
(1 row affected)
1> select @@unicharsize
---
2
(1 row affected)
1> select @@version
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-
bit/OPT/Fri Apr 09 04:15:03 2004
(1 row affected)
1> select @@version_as_integer
-----------
12500
(1 row affected)
|
 |
原文链接：http://bbs.chinaunix.net/viewthread.php?tid=533042
转载请注明作者名及原文出处
|
|
|