]]>
]]>
榪樻湁灝辨槸鑷繁锠㈠埌灝哯xing鐨凧AVASE鐨刯ar鏂囦歡鎷垮埌android鐜涓嬪幓瀹炵幇鍏舵柟娉曘?br />浣嗚繖涓鍒囬兘鎴愪負浜嗚繃鍘匯傛牴鎹浗澶栫殑涓浜涗唬鐮佷俊鎭繕鏈夊緢澶欸oogle涓婄殑璧勬簮緇堜簬綆楁槸瀹屾垚浜嗐?nbsp;
浠ヤ笅鏄埅鍥俱?br />
]]>
]]>
浣跨敤鍔ㄦ佹洿鏂版垨鏄姩鎬佹彃鍏ユ柟娉?br />
@Entity
@org.hibernate.annotations.Entity(dynamicUpdate=true)
]]>
寤虹珛sybase錛屽鐩綍鍦?opt/sybase,鍔犲瘑鐮併傝В鍘嬪埌/tmp/inst/銆備慨鏀?etc/hosts:ip tank
2.鐢╯ybase鐧誨綍錛屽惎鍔▁window錛岃繍琛?tmp/inst/setup榪涜鍥懼艦瀹夎銆?br /> 3銆傛煡鐪婼YBASE鏈嶅姟鍛戒護錛?br /> $showserver
4.鍋滄sybase鏈嶅姟錛?br /> $isql -Usa -STANK
>shutdown SYB_BACKUP --->鍋渂ackupserver
>go
>shutdown ------->鍋渄ataserver
>go
>quit
5.鍚姩sybase鏈嶅姟錛?br /> $cd ~ASE_125/install/
$startserver -f RUN_TANK
$startserver -f RUN_TANK_BS
$showserver
瀹夎 FOR WIN
綾諱技涓鑸▼搴忓畨瑁咃紱鍦╓IN鏈嶅姟綆＄悊閲岃緗惎鍔ㄣ?br /> win涓嬬殑SYBASE瀹㈡埛绔痵ql advantage鍜宒sedit絳夋棤娉曞惎鍔紙鏈満LAN鍘熷洜錛夎В鍐蟲柟娉曪細
淇敼鏈満X:\sybase\locales\locales鏂囦歡閲孨T閫夐」鐨刲ocale = zh_CN, us_english, iso_1錛屽姞鍏ユ湰鏈篖AN鍗沖彲錛堝zh_CN錛?br />
甯哥敤鎿嶄綔錛?br /> 1.su - sybase -c "isql -Usa -STANK"
2.淇敼SA鐨勫瘑鐮?SA榛樿瀵嗙爜涓虹┖):
鐢↖SQL榪炴帴涓婂悗
sp_password null,"鏂板瘑鐮? or sp_password "鏃у瘑鐮?,"鏂板瘑鐮?
3.寮濮嬪拰紜浜嬪姟(娉ㄦ剰錛氭湁浜涘懡浠や笉鍙互鍦ㄤ簨鍔￠噷榪愯錛岃闄勫綍)
begin transaction鍜宑ommit transaction鍙皢浠繪剰鏁扮洰鐨凷QL璇彞灝佽璧鋒潵錛岃繖涓ゅ悕鐨勭畝鍗曡娉曚負錛?br /> begin transaction
commit transaction
or
begin tran
commit
ps:鍙湁鎵ц浜哻ommit鏁版嵁鎵嶆槸鐪熸鍐欏叆搴撻噷銆?br /> 4. 鍥為浜嬪姟
鍦╟ommit transaction鍛戒護鎻愪氦鍓嶄換浣曟椂鍊欏彲鍙栨秷鎴栧洖閫浜嬪姟錛岃鍛戒護鐨勭畝鍗曡娉曚負錛?br /> rollback transaction
or
rollback
5錛庢鏌ヤ簨鍔＄姸鎬?br /> 鍏ㄥ眬鍙橀噺@@transtate璁板綍浜嗕簨鍔″綋鍓嶇殑鐘舵併傚湪鎵ц涓涓鍙ュ悗SQL Server閫氳繃璁板綍鎵鏈変簨鍔″彉鍖栨潵紜畾榪斿洖浣曠鐘舵併?br /> @@transtate鍙寘鍚笅鍒楀鹼細
鍊?nbsp; 鎰忎箟
0浜嬪姟榪涜涓細涓涓樉寮忔垨闅愬紡浜嬪姟鏈夋晥錛涗笂涓璇彞鎵ц鎴愬姛
1浜嬪姟瀹屾垚錛氫簨鍔″畬鎴愬茍鎻愪氦鍏跺彉鍖?br /> 2璇彞寮傚父涓錛氫笂涓璇彞寮傚父緇堟錛涘浜嬪姟鏃犲獎鍝?br /> 3浜嬪姟寮傚父涓錛氫簨鍔″紓甯鎬腑姝㈠茍鍥為鎵鏈夊彉鍖?br /> 涓句緥錛氬湪浜嬪姟涓紝鍙湪涓涓鍙ワ紙濡俰nsert錛夊悗浣跨敤@@transtate紜畾璇ヨ鍙ユ垚鍔熸垨澶辮觸瀵逛簨鍔＄殑褰卞搷銆俢ommit transaction
Begin transaction
Insert into publishers(pub_id)values(‘9999’)
(1 row affected)
select @@transtate
…………………
0
commit transaction
select @@transtate
…………………
0
(1 row affected)
6.澶囦喚緋葷粺鏁版嵁
SYBASE 緋葷粺鐨勫浠戒笌鎭㈠鏈哄埗淇濊瘉浜嗗湪緋葷粺澶辮觸鏃墮噸鏂拌幏鍙栨暟鎹殑鍙兘鎬с係QL Server 鎻愪緵浜嗕袱縐嶄笉鍚岀被鍨嬬殑鎭㈠鏈哄埗錛氫竴綾繪槸緋葷粺鑷姩瀹屾垚鐨勬仮澶嶏紝榪欑鎺柦鍦ㄦ瘡嬈＄郴緇熷惎鍔ㄦ椂閮借嚜鍔ㄨ繘琛岋紝淇濊瘉浜嗗湪緋葷粺鐦棯鍓嶅畬鎴愮殑浜嬪姟閮藉啓鍒版暟鎹簱璁懼涓婏紝鑰屾湭瀹屾垚鐨勪簨鍔￠兘琚洖閫錛涘彟涓綾繪槸浜哄伐瀹屾垚鐨勬仮澶嶏紝榪欐槸閫氳繃 DUMP 鍜?LOAD 鍛戒護鏉ユ墽琛屼漢宸ュ浠藉拰鎭㈠宸ヤ綔銆傚洜姝ゅ畾鏈熷浠戒簨鍔℃棩蹇楀拰鏁版嵁搴撴槸涓欏瑰崄鍒嗛噸瑕佺殑鏃ュ父緇存姢宸ヤ綔銆?
7銆佸浠芥暟鎹簱
姣忎竴涓暟鎹簱閮藉簲鍦ㄥ垱寤轟箣鍚庡嵏鍑猴紝浠庤屾彁渚涗竴涓鍏ュ熀鐐廣傚湪姝や箣鍚庢寜鎺掑畾鐨勬椂闂村懆鏈熻〃鍗稿嚭銆傛瘮濡傛瘡鍛ㄤ簲鍗稿嚭鏁版嵁搴撱傚涓鑸暟鎹簱緋葷粺鍗稿嚭鏁版嵁搴撳懆鏈熷緩璁負姣忓懆涓嬈°?br /> 闄や簡鎸夎鍒掑懆鏈熷嵏鍑烘暟鎹簱涔嬪錛岃繕闇鍦ㄦ瘡嬈¤繍琛屾病鏈夋棩蹇楃殑鎿嶄綔鍚庡嵏鍑烘暟鎹簱銆備緥濡傦細
·姣忔寮哄埗鍦拌繍琛屼簡 DUMP TRAN WITH NO_LOG 錛堝洜涓烘暟鎹簱鐨勭鐩樼┖婧㈠嚭錛夛紱
·姣忔鐢?sp_dboption 鍏佽 select into/bulkcopy 鍋氬揩閫熸嫹璐濓紝鎴栫敤 SELECT INTO 鍛戒護鍒涘緩涓涓案涔呮х殑琛紝鎴栦嬌鐢ㄤ簡 WRITETEXT 鍛戒護銆?br /> 鍗稿嚭鏁版嵁搴撶殑鍛戒護涓猴細
DUMP DATABASE database_name
TO dump_device
database_name 鏄鍗稿嚭鐨勬暟鎹簱鍚嶇О錛宒ump_device 鏄嵏鍑鴻澶囩殑鍚嶇О銆傜敤緋葷粺榪囩▼ sp_helpdevice 鍙互鑾峰緱璁懼鐨勪俊鎭?br /> 涓嬮潰涓鏉″懡浠ょ敤鏉ュ嵏鍑烘暟鎹簱 my_db 錛?br /> DUMP DATABASE my_db
TO db_bk_dev
榛樿瀵煎嚭鍒癈:\WINDOWS\SYSTEM32\涓嬩簡銆備篃鍙互鎸囧畾璺緞銆?br /> 8銆佸浠戒簨鍔℃棩蹇?br /> 濡傛灉浜嬪姟鏃ュ織涓庢暟鎹簱鏀懼湪鍚屼竴涓澶囦笂錛屽垯浜嬪姟鏃ュ織涓嶅簲涓庢暟鎹簱鍒嗗紑澶囦喚銆俶aster 鏁版嵁搴撳拰灝忎簬 4M 鐨勭敤鎴鋒暟鎹簱灝辨槸榪欑鎯呭喌銆備竴鑸暟鎹簱緋葷粺鐨勬暟鎹簱鍜屾棩蹇楀垎鍒斁鍦ㄤ笉鍚岀殑璁懼涓婏紝鍥犳錛屽彲浠ョ敤 DUMP TRAN 鍛戒護鍗曠嫭澶囦喚鏃ュ織銆?br /> 澶囦喚浜嬪姟鏃ュ織鐨勫懆鏈熺洿鎺ュ獎鍝嶆暟鎹殑鎭㈠紼嬪害錛屽洜姝ゅ緩璁瘡澶╁浠姐?br /> 澶囦喚浜嬪姟鏃ュ織鐨勫懡浠ゆ牸寮忎負錛?br /> DUMP TRANsaction database_name
[TO dump_device]
[WITH TRUNCATE_ONLY|WITH NO_LOG|WITH NO_TRUNCATE]
鍏朵腑 database_name 鏄澶囦喚浜嬪姟鐨勬暟鎹簱鍚嶇О錛宒ump_device 鏄浠借澶囧悕縐幫紝浠呭綋鍖呭惈浜?WITH TRUNCATE_ONLY 鎴?WITH NO_LOG 瀛愬彞鏃訛紝鎵嶅彲浠ュ浠藉埌璁懼銆?br /> 娉ㄦ剰錛氬鏋滄繪槸鐢?DUMP DATEBASE 錛堝浠芥暟鎹簱鍙婂叾鏃ュ織錛夛紝鑰屼笉鐢?DUMP TRAN 錛屼簨鍔℃棩蹇楀皢涓嶄細鍒鋒柊錛岃屽彉寰楅潪甯稿簽澶с?br /> 瀵逛簬 master 鏁版嵁搴撳拰灝忓瀷鏁版嵁搴撴瘡嬈¤繍琛?DUMP DATEBASE 涔嬪悗搴斿綋榪愯 DUMP TRANsaction 鍛戒護鍒鋒柊鏃ュ織 銆?br /> 涓嬮潰涓鏉″懡浠ゅ浠芥暟鎹簱 db160 鐨勪簨鍔℃棩蹇楀埌澶囦喚璁懼涓婏細
DUMP TRANsaction db160
TO db_log_bk_dev
WITH TRUNCATE_ONLY
9銆佸浠芥暟鎹簱鍙婂叾鏃ュ織闂寸殑鐩鎬簰浣滅敤
鍦ㄨ嚦灝戝嵏鍑轟竴嬈℃暟鎹簱鍓嶏紝鍗稿嚭浜嬪姟鏃ュ織鏄鏃犳剰涔夌殑銆備笅鍥炬樉紺轟簡澶囦喚鏁版嵁搴撳強鍏舵棩蹇楅棿鐨勫叧緋?br /> 濡傛灉鍦ㄦ槦鏈熶簩涓嬪崍5錛?1鍑虹幇闈炵‖浠舵晠闅滐紝闇瑕佸仛鐨勬墍鏈夊伐浣滄槸瑁呭叆紓佸甫5錛堝弬瑙佷笅涓鑺傦細鏁版嵁鎭㈠錛夛紝鐢變簬紓佸甫5鏄笅鍗?錛?0鍒氬浠界殑錛屽洜姝ゅ彧鏈夊浠藉拰瑁呭叆涔嬮棿鐨勪竴鍒嗛挓鍐呯殑鏁版嵁鎹熷け銆?br /> 浣嗘槸錛屽鏋滃湪鏄熸湡浜屼笅鍗?錛?9澶辨晥浼氭庝箞鏍峰憿錛熷湪榪欑鎯呭喌涓嬶紝瑕佽鍏ョ甯?錛堝湪鏄熸湡浜斾笅鍗?錛?0鐨勫嵏鍑猴級銆傜劧鍚庯紝渚濇瑁呭叆紓佸甫2錛?浠ュ強4銆傝繖鏍鳳紝緋葷粺灝嗘仮澶嶅埌鏄熸湡浜屼笂鍗?0錛?0鐐圭殑鐘舵侊紝鏄熸湡浜岀殑澶ч儴鍒嗗伐浣滀涪澶變簡銆傛渚嬫樉紺轟簡緇忓父鍗稿嚭浜嬪姟鐨勯噸瑕佹с?br /> 10銆佷竾涓緋葷粺澶辮觸鏃舵仮澶嶆暟鎹簱緋葷粺
濡傛灉鐢ㄦ埛鏁版嵁搴撳瓨鍌ㄧ殑璁懼澶辨晥錛屼粠鑰屾暟鎹簱琚牬鍧忔垨涓嶅彲瀛樺彇錛岄氳繃瑁呭叆鏈鏂扮殑鏁版嵁搴撳浠戒互鍙婂悗鏉ョ殑浜嬪姟鏃ュ織澶囦喚鍙互鎭㈠鏁版嵁搴撱傚亣璁懼綋鍓嶇殑浜嬪姟鏃ュ織瀛樺湪浜庝竴涓茍娌℃湁姣佸潖鐨勮澶囦笂錛屽甫鐫 WITH NO_TRUNCATE 閫夐」鐨?DUMP TRANsaction 鍛戒護鍗稿嚭瀹冦?br /> 瑕佹仮澶嶆暟鎹簱鎸夊涓嬫楠ゅ幓鍋氾細
1錛夈佸鏋滄棩蹇楀瓨鍦ㄤ簬涓涓垎紱葷殑璁懼涓婏紝鐢ㄥ甫鐫 NO_TRUNCATE 閫夐」鐨?DUMP TRANsaction 鍛戒護鍗稿嚭琚瘉鍧忕殑鎴栬呬笉鍙瓨鍙栫殑鐢ㄦ埛鏁版嵁搴撲簨鍔℃棩蹇椼?br /> 2錛夈佺敤涓嬮潰鐨勬煡璇㈡鏌ヨ澶囧垎閰嶅凡姣佸潖鏁版嵁搴撶殑璁懼浣跨敤鎯呭喌銆傚繀欏諱負鍚屼竴鐩殑璧嬪悓鏍風殑絀洪棿鍧椼?br /> 涓嬮潰鐨勬煡璇㈡樉紺轟簡鍒嗛厤緇欐暟鎹簱 mydb 璁懼浣跨敤鍜屽昂瀵告儏鍐碉細
SELECT segmap錛宻ize FROM銆sysusages
WHERE dbid =
錛?SELECT dbid FROM sysdatabases WHERE name = “mydb”錛?br /> 3錛夈佹鏌ユ煡璇㈢殑杈撳嚭銆傚湪 segmap 鍒楃殑 ‘3’浠ｈ〃鏁版嵁鍒嗛厤錛?#8216;4’浠ｈ〃鏃ュ織鍒嗛厤銆俿ize 鍒椾唬琛?2K 鏁版嵁鍧楃殑鏁扮洰銆傛敞鎰忔淇℃伅鐨勬搴忋佷嬌鐢ㄥ拰灝哄閮ㄥ垎銆備緥濡傦紝杈撳嚭涓猴細
4錛夈佺敤 DROP DATABASE 鍛戒護鍒犻櫎姣佸潖璁懼涓婄殑鏁版嵁搴撱傚鏋滅郴緇熸姤閿欙紝鐢―BCC DBREPAIR 鍛戒護鐨?DROPDB 閫夐」銆?br /> 5錛夈佸垹闄ゆ暟鎹簱鍚庯紝鐢?sp_dropdevice 鍒犻櫎姣佸潖浜嗙殑璁懼銆?br /> 6錛夈佺敤 DISK INIT 鍒濆鍖栨柊鐨勬暟鎹簱璁懼銆?br /> 7錛夈侀噸寤烘暟鎹簱銆傜敤 CREATE DATABASE 鍛戒護浠庤佺殑 sysusages 琛ㄦ嫹璐濇墍鏈夌殑琛岋紝騫跺寘鍚涓閫昏緫璁懼銆?br /> 瀵逛笂渚嬶紝鍛戒護涓猴細
CREATE DATABASE mydb
ON datadev1=20錛宒atadev2=10
LOG ON logdev1=10
8錛夈佺敤 ALTER DATABASE 鍛戒護閲嶅緩鍏朵綑鍏ュ彛銆傚湪姝や緥涓紝鍦╠atadev1涓婂垎閰嶆洿澶氱殑絀洪棿錛屽懡浠や負錛?br /> ALTER DATABASE mydb ON datadev1=2
9錛夈佺敤 LOAD DATABASE 閲嶆柊瑁呭叆鏁版嵁搴擄紝鐒跺悗鐢?LOAD TRAN 瑁呭叆鍓嶉潰鍗稿嚭鐨勬棩蹇椼?br /> LOAD DATABASE 鍛戒護璇硶鏄細
LOAD DATABASE database_name
FROM dump_device
LOAD TRANsaction 鍛戒護鐨勮娉曟槸錛?br /> LOAD TRANsaction database_name FROM dump_device
鍗稿嚭鏁版嵁搴撳拰浜嬪姟鏃ュ織鐨勭己鐪佹潈闄愬綊鏁版嵁搴撴墍鏈夎咃紝涓斿彲浠ヤ紶閫掔粰鍏朵粬鐢ㄦ埛錛涜杞芥暟鎹簱鍜屼簨鍔＄殑鏉冮檺涔熷綊鏁版嵁搴撴墍鏈夎咃紝浣嗕笉鑳戒紶閫掋?br />
11銆佷駭鐢熺敤鎴蜂俊鎭〃錛屽茍涓轟俊鎭〃鎺堟潈錛?br /> 緋葷粺緇存姢浜哄憳鐨勫彟涓涓棩甯鎬簨鍔℃槸涓虹敤鎴峰垱寤烘柊鐨勪俊鎭〃錛屽茍涓轟箣鎺堟潈銆傚垱寤鴻〃浠ュ強涓鴻〃鎺堟潈鐨勬柟娉曞凡緇忓湪璁茶繃錛屽湪姝ゅ彧灝嗘湁鍏沖懡浠よ娉曞啓鍑烘潵銆?br /> ·鍒涘緩琛ㄧ殑鍛戒護涓猴細
CREATE TABLE table_name
錛?column_1 datatype [NULL | NOT NULL | IDENTITY]錛?br /> column_2 ……
錛?br /> go
ALTER TABLE table_name
ADD PRIMARY KEY 錛坈olumn_list錛?br /> go
·鍒犻櫎琛ㄧ殑鍛戒護鏍煎紡涓猴細
DROP TABLE table_name
go
·涓鴻〃鎺堟潈鐨勫懡浠ゆ牸寮忎負錛?br /> GRANT {ALL|permission_list}
ON table_name TO user_name
go
·鏀跺洖鏉冮檺鐨勫懡浠ゆ牸寮忎負
REVOKE {ALL|permission_list}
ON table_name FROM user_name
go
12銆佺洃瑙嗙郴緇熻繍琛岀姸鍐碉紝鍙婃椂澶勭悊緋葷粺閿欒錛?br /> 緋葷粺綆＄悊鍛樼殑鍙︿竴欏規棩甯稿伐浣滄槸鐩戣緋葷粺榪愯鎯呭喌銆備富瑕佹湁浠ヤ笅鍑犱釜鏂歸潰錛?br /> 1錛夈佺洃瑙嗗綋鍓嶇敤鎴蜂互鍙婅繘紼嬬殑淇℃伅
浣跨敤緋葷粺榪囩▼錛歴p_who
璇存槑錛氳鍛戒護鏄劇ず褰撳墠緋葷粺鎵鏈夋敞鍐岀敤鎴峰強榪涚▼淇℃伅錛屽涓嬭〃鏄煇緋葷粺鐨勪俊鎭?br /> SpidStatusLoginamehostnameblkdbnamecmd
---------------------------------------------------------------
1RunningSascosysv0MasterSELECT
2SleepingNULL0MasterNETWORK HANDLE
3SleepingNULL0MasterDEADLOCK TUNE
4SleepingNULL0MasterMIRROR HANDLER
5SleepingNULL0MasterHOUSEKEEPER
6SleepingNULL0MasterCHECKPOINT SLEEP
浠庡乏鍚戝彸渚濇鏄劇ず錛氳繘紼嬪彿銆佸綋鍓嶇姸鎬併佹敞鍐岀敤鎴峰悕銆佷富鏈哄悕銆佸崰鐢ㄥ潡鏁般佹暟鎹簱鍚嶄互鍙婂綋鍓嶅懡浠ゃ?br /> 濡傛灉鐩戣鏃跺彂鐜拌繘紼嬫繪暟鎺ヨ繎鏈澶ц繛鎺ユ暟錛堢敤緋葷粺榪囩▼錛歴p_configure “user conn” 鏌ョ湅錛夋椂錛屽簲涓嬫帀涓嶆椿鍔ㄦ垨鏃犲叧榪涚▼錛屼互淇濊瘉緋葷粺姝ｅ父榪愬仛錛涘彟澶栦害鍙洃瑙嗛潪娉曠敤鎴鋒垨鐢ㄦ埛浣跨敤涓嶅睘浜庤嚜宸變嬌鐢ㄨ寖鍥寸殑鏁版嵁搴撶瓑鎯呭喌銆?br /> 2錛夈佺洃瑙嗙洰鏍囧崰鐢ㄧ┖闂存儏鍐?br /> 浣跨敤緋葷粺榪囩▼錛歴p_spaceused
璇存槑錛氳榪囩▼鏄劇ず琛屾暟銆佹暟鎹〉鏁頒互鍙婂綋鍓嶆暟鎹簱涓敱鏌愪釜鐩爣鎴栨墍鏈夌洰鏍囨墍鍗犵敤鐨勭┖闂淬傚涓嬭〃鏄煇鏁版嵁搴撴棩蹇楄〃鐨勪俊鎭細
NameRow_totalreserveddataIndex_sizeunused
------------------------------------------------------------
SyslogsNot avail32KB32KB0KBNot avail
鏃ュ父瑕佺洃瑙嗙殑涓昏鐩爣鏈夛細鐢ㄦ埛鏁版嵁搴撱佹暟鎹簱鏃ュ織琛紙syslogs錛変互鍙婅璐瑰師濮嬫暟鎹〃絳夈傚鏋滃彂鐜板崰鐢ㄧ┖闂磋繃澶э紝瀵規棩蹇楄〃瑕佽繘琛岃漿鍌紱瀵瑰叾浠栫洰鏍囧垯搴旀墿鍏呯┖闂存垨娓呮鍨冨溇鏁版嵁銆?br /> 3錛夈佺洃瑙?SQL Server 緇熻鏁板瓧
浣跨敤緋葷粺榪囩▼錛歴p_monitor
璇存槑錛歴p_monitor 鏄劇ずSQL Server 鐨勫巻鍙茬粺璁℃暟瀛楋紝涓嬭〃鏄煇緋葷粺鐨勭粺璁℃暟瀛楋細
Last_runCurrent_runSeconds
---------------------------------------------------------------
May 13 2000 1:27PMMay 13 2000 3:01PM5678
CPU_busyIO_busyIdle
---------------------------------------------------------------
16(6)-0%0(0)-0%5727(5672)-99%
Packets_receivedPackets_sentPacket_errors
---------------------------------------------------------------
21(17)100(97)0(0)
Total_readTotal_writeTotal_errorsConnections
--------------------------------------------------------
785(366)311(113)0(0)3(2)
涓婅〃渚濇緇欏嚭璇ョ郴緇熸湰嬈¤繍琛岀粺璁＄殑涓婁竴嬈℃椂闂淬佹湰嬈℃椂闂淬侀棿闅旂鏁般丆PU鍗犵敤銆両O鍗犵敤銆佹敹鍙戝寘鎯呭喌銆佺郴緇熻鍏ュ啓鍑烘儏鍐電瓑淇℃伅
13銆佷繚璇佺郴緇熸暟鎹畨鍏紝鍛ㄦ湡鏇存敼鐢ㄦ埛鍙ｄ護錛?br /> 涓轟繚璇佺郴緇熸暟鎹殑瀹夊叏錛岀郴緇熺鐞嗗憳蹇呴』渚濇嵁緋葷粺鐨勫疄闄呮儏鍐碉紝鎵ц涓緋誨垪鐨勫畨鍏ㄤ繚闅滄帾鏂姐傚叾涓紝鍛ㄦ湡鎬х殑鏇存敼鐢ㄦ埛鍙ｄ護鏄瘮杈冨父鐢ㄤ笖鍗佸垎鏈夋晥鐨勬帾鏂姐?br /> 鏇存敼鐢ㄦ埛鍙ｄ護鏄氳繃璋冪敤緋葷粺榪囩▼sp_password 鏉ュ疄鐜扮殑銆係p_password 鐨勮娉曚負錛?br /> sp_password caller_password,new_password [,loginame]
鍏朵腑caller_password 鏄櫥褰曞彛浠わ紙鑰佸彛浠わ級錛宯ew_password鏄柊鍙ｄ護錛宭oginame鏄櫥褰曞悕縐般?br />
14.濡備綍淇敼IP鍦板潃鏀瑰彉鍚庣殑interfaces鏂囦歡錛?br /> A.瀹夎SYBASE Adapive Server鐨勬満鍣↖P鍦板潃鏀瑰彉鍚? 搴斾慨鏀?interfaces 鏂囦歡鍙婃湁鍏崇殑璁劇疆銆?br /> 濡傛灉 interfaces 鏂囦歡涓嬌鐢ㄧ殑鏄満鍣ㄥ悕鑰屼笉鏄?IP 鍦板潃, 鍒欎笉闇瑕佸彉鍔ㄣ?浣嗗鏋滃鎴風鑱旂粨鏈嶅姟鍣ㄤ嬌
鐢ㄧ殑鏄湇鍔″櫒鐨?IP 鍦板潃鑰屼笉鏄満鍣ㄥ悕,閭ｄ箞瀹㈡埛绔渶淇敼鑱旂粨鏈嶅姟鍣ㄧ殑 IP 鍦板潃.銆?br /> 濡傛灉 interfaces 鏂囦歡涓嬌鐢ㄧ殑鏄?IP 鍦板潃, 閭ｄ箞闇瑕佷慨鏀?interfaces 鏂囦歡涓拰鍦板潃鏈夊叧鐨勯儴鍒?
鍙嬌鐢╠scp 鎴?dsedit 榪涜淇敼銆?濡傛灉瀹㈡埛绔仈緇撴湇鍔″櫒浣跨敤鐨勬槸鏈嶅姟鍣ㄧ殑鍦板潃鑰屼笉鏄満鍣ㄥ悕,閭ｄ箞瀹?br /> 鎴風涔熼渶淇敼銆?br /> 15銆傚疄鐜板紑鏈烘椂鑷姩瑁呰澆Sybase鏁版嵁搴?br /> 銆銆鍘熷厛瑕佷嬌Sybase SQL Server鍚姩錛屼竴鑸渶瑕佸厛浠ybase鐢ㄦ埛鐧誨綍錛岀劧鍚庤繍琛?SYBASE/install鐩綍涓嬬殑startserver鍛戒護鍚姩SYBASE_XXXX鏈嶅姟榪涚▼鍜孲YB_BACKUP_XXXX澶囦喚鏈嶅姟榪涚▼銆?br /> 銆銆瑕佸疄鐜癠nix緋葷粺鍚姩鏃跺氨鑳藉湪鍚庡彴瑁呰澆Sybase鐨勫姛鑳?鎴戜滑鍙湪/etc/rc2.d/鐩綍涓嬫柊寤轟竴鏂囦歡S99sybase,鍐呭濡備笅:
銆銆SYBASE=/usr/sybase
銆銆PATH=$PATH:$SYBASE/bin
銆銆export $SYBASE $PATH
銆銆$SYBASE/install/startserver -f $SYBASE/install/RUN_SYBASE_XXXX > /dev/null
銆銆$SYBASE/install/startserver -f $SYBASE/install/RUN_SYB_BACKUP_XXX >/dev/null
銆銆鐒跺悗淇敼Sybase鐨勬潈闄愶紝閲嶅惎緋葷粺鍗沖彲銆?br /> 16.瀹炵幇鍏蟲満鏃惰嚜鍔ㄥ嵏杞絊ybase鏁版嵁搴?br /> 涓轟繚璇丼ybase緋葷粺鐨勬甯歌繍琛岋紝姣忔鍦ㄥ叧闂璘nix緋葷粺鏃惰鍏堢粨鏉烻ybase SQL Server 鐨勬湇鍔¤繘紼嬶紝浠庡噺杞葷郴緇熺鐞嗕漢鍛樻搷浣滅殑瑙掑害鍑哄彂寤虹珛涓鐢ㄦ埛halt錛屼慨鏀?etc/passwd鏂囦歡錛屽皢halt鐢ㄦ埛鐨剈id鏀逛負0錛堟垨鍏朵粬鍙繍琛?shutdown鐨勭敤鎴穒d錛夛紝鍦?usr/halt/.profile涓坊鍔犱互涓嬭鍙ワ細
銆銆SYBASE=/usr/sybase
銆銆DSQUERY=SYBASE_XXXX
銆銆PATH=$PATH:$SYBASE/bin
銆銆export SYBASE DSQUERY PATH
銆銆isql -Usa -Pabcabc -ihalt.sql > /dev/null
銆銆shutdown -y -g0
銆銆鍏朵腑“abcabc”涓簊a鐢ㄦ埛鐨勫彛浠?halt.sql鏄竴綆鍗曠殑鏂囨湰鏂囦歡錛屽唴瀹瑰涓嬶細
銆銆shutdown
銆銆go
銆銆榪欐牱姣忔鍙浠alt鐢ㄦ埛鐧誨綍錛屽氨瀹炵幇浜嗚嚜鍔ㄥ嵏涓婼ybase鏁版嵁搴擄紝鐒跺悗鍏抽棴Unix緋葷粺銆?br /> 17. Sybase UTF-8涓枃瀛楃闆嗚緗?br /> (榪欓噷SYBASE鐨勫畨瑁呰礬寰勪負c:\sybase)
1.c:\>cd \sybase\charsets\cp936
2.c:\sybase\charsets\cp936> charset -U鐢ㄦ埛鍚?-P瀵嗙爜 -S鏁版嵁搴撴湇鍔″櫒鍚嶇О binary.srt cp936
鏇存敼榛樿瀛楃闆嗕負cp936
3.鍦⊿QL鐜涓?br /> 1>select name,id from syscharsets(浼氬垪鍑哄瓧絎﹂泦瀵瑰簲鐨刬d鍙?
2>go
鎵懼埌name涓篶p936瀵瑰簲鐨刬d(鍋囪涓?71)
1>sp_configure "default character set id",171
2>go
5.閲嶅惎server涓ゆ
錛堟敞:絎竴嬈″惎鍔ㄥ悗錛宻erver浼氳嚜鍔ㄥ畷鎺夛紝闇瑕佺浜屾閲嶅惎鍚庢墠鑳戒嬌鐢級
18.鍒涘緩鐢ㄦ埛鏁版嵁搴?br /> 浠ヤ笅閫氳繃涓涓緩绔嬫暟鎹簱鐨勮剼鏈鏄庡緩绔嬫暟鎹簱鐨勮繃紼嬶細
//鍒涘緩鏁版嵁搴撹澶囷紝璁懼澶у皬浠ラ〉錛?K錛変負鍗曚綅
disk init
name="test_dbdev",
physname="/home/bk/test_dbdev.dat",
vdevno=5,
size=10240
go
disk init
name="test_logdev",
physname="/home/bk/test_logdev.dat",
vdevno=6,
size=5120
go
//鍒涘緩鏁版嵁搴揟EST_DB錛屽叾澶у皬涓?0M錛屾棩蹇楀ぇ灝忎負10M
create database TEST_DB
on test_dbdev=20
log on test_logdev=10
go
//鎵撳紑鏁版嵁搴?br /> use TEST_DB
go
-----------
涓句緥璇存槑錛?br /> DISK INIT
Name=’My_Device’,
Physname=’D:\database\My_device.dat’,
Vdevno=3
Size=5000
娉ㄩ噴錛氶昏緫鍚嶃佺墿鐞嗗悕銆佽澶囪櫄鎷熷彿銆佽澶囧ぇ灝?br /> ------------------------
鍒涘緩鐢ㄦ埛鏁版嵁搴?br /> Create Database 鏁版嵁搴撳悕
On 璁懼_1=Size_1,//鍗曚綅錛歁
璁懼_2=Size_2,
……
log on 鏃ュ織璁懼=Log_Size
[With Override]//鍦ㄥ悓涓璁懼涓婂垱寤烘暟鎹簱鍜屼簨鍔℃棩蹇楁椂浣跨敤璇ラ夐」
[For Load] //紱佹鐢ㄦ埛璁塊棶鐩村埌鏁版嵁搴撶殑瑁呭叆鎴栨仮澶嶆搷浣滃畬鎴愪負姝?br /> 涓句緥錛?br /> Create Database test_db
On data_dev=100,//鍗曚綅錛歁
Index_dev=50
Log on log_dev=30
璇存槑錛?br /> 錛?錛夊皢鏃ュ織鏀懼湪鍗曠嫭鐨勮澶囦笂錛屾湁鍒╀簬鏁版嵁搴撴ц兘鐨勬彁楂橈紱
錛?錛夊鏋滃皢鏁版嵁搴撳拰鏃ュ織鏀懼湪鍚屼竴璁懼涓婏紝灝變笉鑳藉疄鐜板閲忓浠斤紱
錛?錛夐氬父灝哠ystem鍜孌efault孌電緝鍑忚寖鍥村埌涓涓澶囦笂錛屽鍒犻櫎璁懼Index_dev涓婄殑System孌靛拰Default孌碉紝鍒涘緩鏂扮殑孌碉紝鐢ㄦ潵瀛樻斁涓撻棬鐨勬暟鎹簱瀵硅薄
19.澶囦喚鍜屾仮澶岲B鏁版嵁
dump database mydb to '/u01/mydb_full.bk'
go
dump tranaction mydb to '/u01/mydb_tran.bk'
go
load database mydb from '/u01/mydb_full.bk'
load transaction mydb from '/u01/mydb_tran.bk'
online database mydb
go
ps:閲囩敤澧為噺澶囦喚鍚庯紝涓ョ鏃ュ織鎴柇! 鍗崇姝嬌鐢細dump transaction sctf truncate_only 鍛戒護!
澧為噺澶囦喚蹇呴』鏄湪瀹屾暣澶囦喚鍚庣殑鎴栦笂涓嬈″閲忓浠藉悗錛屼腑闂磋嫢閬囧埌鏃ュ織鎴柇錛屽悗緇殑澧為噺澶囦喚鍧囧憡澶辮觸錛?br /> 澧為噺澶囦喚鍙互鏍規嵁闇瑕侊紝濡傛瘡灝忔椂澶囦喚涓嬈★紝姣忔澶囦喚鎵闇鏃墮棿綰?錛?縐掞紝鎵浠ユ椂闂存瀬蹇?br /> ps: 鍗曞紩鍙峰拰鍙屽紩鍙烽兘鑳藉叧闂璼hell瀵圭壒孌婂瓧絎︾殑澶勭悊銆備笉鍚岀殑鏄紝鍙屽紩鍙鋒病鏈夊崟寮曞彿涓ユ牸錛屽崟寮曞彿鍏抽棴鎵鏈夋湁鐗規畩浣滅敤鐨勫瓧絎︼紝鑰屽弻寮曞彿鍙姹俿hell蹇界暐澶у鏁幫紝鍏蜂綋鐨勮錛屽氨鏄憼緹庡厓絎﹀彿鈶″弽寮曞彿鈶㈠弽鏂滄潬錛岃繖3縐嶇壒孌婂瓧絎︿笉琚拷鐣ャ?涓嶅拷鐣ョ編鍏冪鍙鋒剰鍛崇潃shell鍦ㄥ弻寮曞彿鍐呴儴涔熻繘琛屽彉閲忓悕鏇挎崲銆?br />
*********************************************
涓嬮潰璧勬枡鏉ヨ嚜SYBASE鐧界毊涔?br /> 1銆傚鎴風瀛楃闆嗕慨鏀?locales.dat
2.鍙互閫氳繃璁劇疆CHARSET椹卞姩紼嬪簭灞炴ф寚瀹氬湪搴旂敤紼嬪簭涓嬌鐢ㄧ殑瀛楃闆嗐?br /> 鎴栬呰緗甹connect瀛楃闆嗙殑鏂規硶鏉ヨ緗?br /> 3銆傛煡鐪嬪瓧絎﹂泦錛?br /> SERVER錛歴p_helpsort
go
CLIENT錛歴elect @@client_csname
go
4.孌?闃鍊鹼細
榛樿鏄笁涓: system default logsegment
system孌? 鏁版嵁搴撶郴緇熻〃瀛樻斁澶?br /> default孌? 鏈寚鏄庢鐨勫璞￠兘瀛樻斁鍦ㄨ繖閲?br /> logsegment孌?鏁版嵁搴撶殑浜嬪姟鏃ュ織瀛樻斁澶?br />
闃鍊?threshold) :
寤虹珛闃鍊? sp_addthreshold 搴撳悕,孌靛悕,鑷敱絀洪棿,瀛樺偍榪囩▼鍚嶅瓧
鍒犻櫎闃鍊? sp_dropthreshold 搴撳悕,孌靛悕,鑷敱絀洪棿欏?
鏄劇ず闃鍊? sp_helpthreshold
綆＄悊闃鍊? sp_dboption
鏄劇ず孌電┖闂翠俊鎭?sp_helpsegment
闃鍊肩鐞嗙殑嫻佺▼濡備笅:
鍏堝緩瀛樺偍榪囩▼:(涓嬮潰鐨勬槸鏃ュ織鐨勫瓨鍌ㄨ繃紼?鍘熷洜:鏃ュ織澧為暱鍏鋒湁涓嶅彲棰勮鎬?鐩告瘮涔嬩笅,鏁版嵁澧為暱鍏鋒湁鍙瑙佹?鎵浠ヤ竴鑸兘寤簂ogsegment鐨勯榾鍊肩鐞?default鐨勯榾鍊肩鐞嗗彲涓嶅緩)
create procedure szjj
@dbname varchar (30),
@segmentname varchar (30),
@space_left int,
@status int
as
dump transaction @dbname to "/tmp/bb.dat"
go
ps:涓婇潰鏄棩蹇楃殑瀛樺偍榪囩▼,濡傛灉鏄暟鎹殑瀛樺偍鍒欑敤dump database...
鏌ョ湅褰撳墠鏃ュ織鑷敱絀洪棿鎯呭喌:
sp_helpsegment logsegment
go
鏌ョ湅褰撳墠鏁版嵁搴撴暟鎹嚜鐢辯┖闂存儏鍐?
sp_helpsegment default
go
鏌ョ湅褰撳墠闃鍊兼儏鍐?
sp_helpthreshold
go
鏌ョ湅褰撳墠孌墊儏鍐?
sp_helpsegment
go
鐒跺悗鏍規嵁鑷敱絀洪棿鏉ュ畾闃鍊煎弬鏁?
sp_addthreshold test_db,logsegment,200,szjj
go
ps:褰撴棩蹇楁鐨勬渶鍚庢満浼氶榾鍊艱瓚呰秺鍚?璇曞浘寰璇ユ棩蹇楁涓婅鏃ュ織鐨勭敤鎴瘋繘紼嬮粯璁ゆ槸琚寕璧?鐢ㄤ笅闈㈢殑鍛戒護淇敼MASTER搴撳弬鏁?璁╅榾鍊艱瓚呰秺鍚庝簨鍔″氨浼氭粴.
use master
go
sp_dboption test_db,"abort tran on log full",true
go
5.緇存姢
1錛夊鍚凙SE鐢ㄦ埛鎷呭綋鐨勮鑹插拰鐗規潈榪涜鍒嗘淳銆?br /> 2錛夌鐞嗗拰鐩戣紓佺洏絀洪棿鐨勪嬌鐢ㄦ儏鍐點?br /> 3錛夋暟鎹簱絀洪棿錛?br /> sp_helpdb 鏌ョ湅鍚勫簱鎯呭喌
alter database 鎵╁厖絀洪棿
dump tran 鎴柇鏃ュ織
4錛夋棩甯告暟鎹浠藉拰鎭㈠
5錛塖YBASE榛樿鐨勬湇鍔″櫒錛?br /> adaptive server:綆＄悊鏁翠釜鏁版嵁搴撶郴緇燂紝鍖呮嫭鐢ㄦ埛 鏁版嵁 璧勬簮絳夌殑綆＄悊鍜屾帶鍒躲?br /> backup server: 鍦ㄥ浠藉拰鎭㈠鏃舵墽琛屾暟鎹簱鐨刣ump or load
xp server:鎵ц鎵╁睍瀛樺偍榪囩▼
monitor server:涓烘ц兘璋冭瘯鍒嗘瀽閲囬泦鏁版嵁銆?br /> historical server:淇濆瓨鏉ヨ嚜monitor server鐨勬暟鎹紝浠ュ灝嗘潵鍒嗘瀽銆?br /> 6銆傚崟妯″紡鍚姩SYBASE
1錛夊仠姝SE鏁版嵁搴撴湇鍔?br /> 2錛?/install/startserver -f RUN_servername -m
ps:windows涓嬪湪鏈嶅姟鐨勫睘鎬ч噷鍔?m銆?br /> 7.license搴忓垪鍙?br /> 楠岃瘉璁稿彲杞歡鏄惁鎵ц:*/bin/lmutil lmstat -c
鎵嬪伐鍚姩:*/bin/lmgrd -c $lm_license_file&
鍚姩璁稿彲綆＄悊鍣細*/bin/lmgr
榪愯錛?/bin/lmutil lmreread
8.鏌ョ湅閫昏緫欏靛ぇ灝?br /> select @@maxpagesize
9.鍚姩鍏抽棴SYBASE
鍚姩錛?/startserver -f RUN_servername
鍏抽棴錛氱櫥褰曞悗shutdown鍏蟲暟鎹簱鏈嶅姟 shutdown SYB_BACKUP鍏沖浠芥湇鍔″櫒
10銆傚笎鎴風鐞?br /> SA甯愭埛鍒濆鍙ｄ護涓虹┖錛屽叿鏈塖A鍜孲SO瑙掕壊銆傚叿鏈塖SO鐨勭櫥褰曞笎鎴峰彲浠ユ坊鍔犲叾浠栫櫥褰曞笎鎴楓?br /> 1錛夊垱寤虹櫥褰曞笎鎴?br /> sp_addlogin login_name,password
go
2)淇敼甯愭埛瀵嗙爜
sp_password caller_password,new_password,login_name
go
3)璁劇疆鐧誨綍甯愭埛鐨勭己鐪佹暟鎹簱(濡傛灉涓嶆寚瀹?榛樿鏄痬aster搴?
sp_addlogin login_name,password,default_db
go
or
sp_modifylogin login_name,"defdb",db_name
go
4錛変負鐧誨綍甯愭埛鎺堜簣緋葷粺瑙掕壊
sp_role "grant",role_name,login_name
go
or
grant role role_name to login_name
go
5)鏌ョ湅鐧誨綍甯愭埛鐨勪俊鎭?br /> sp_displaylogin login_name
go
6)SYBASE甯哥敤瑙掕壊錛歴a sso oper
7)淇敼鐧誨綍瀵嗙爜
sp_password caller_passwd,new_passwd[,login_name]
8)鍒犻櫎sa_role鐨勫彛浠?br /> alter role sa_role drop passwd
9錛夊垱寤烘暟鎹簱鐢ㄦ埛
sp_adduser loginname[,name_in_db[,grpname]]
go
10)娣誨姞鐢ㄦ埛騫舵巿浜堟煡璇㈡潈闄?br /> sp_adduser 鏉冮檺 on 琛ㄥ悕 to 鐢ㄦ埛鍚?br /> 11錛夊垹闄ゅ埆鍚?br /> sp_dropalias loginname
12)鍒涘緩鐢ㄦ埛鑷畾涔夌粍
sp_addgroup grpname
go
13)鎵懼洖SA瀵嗙爜
鍋滄SYBASE鏈嶅姟--銆変慨鏀筊UN_xxx,鍦ㄥ懡浠よ鐨勬渶鍚庡姞涓?psa--銆塻tartserver -f RUN_xxx-->鍚姩淇℃伅鐨勬渶鍚庝細鍑烘潵瀵嗙爜銆?br />
11銆傛暟鎹簱綆＄悊
1錛夋暟鎹簱閫夐」鐨勮緗?br /> sp_dboption[dbname,optname,{,true|false}]
2)寤哄簱
create database dbname on data_device_name=size log on log_device_name=size
go
ps:size default is M
3)鏌ョ湅搴撳ぇ灝?sp_helpdb dbname
4)鏀瑰彉搴撶殑灞炰富 sp_changedbowner loginname[,true]
5)鎵╁睍鏁版嵁搴?br /> 鎵╁睍鏁版嵁絀洪棿錛歛lter database db_name on device_name
鎵╁睍鏃ュ織絀洪棿: alter database db_name log on device_name
6)璁劇疆鏁版嵁搴撲負鍗曠敤鎴鋒ā寮?鍙互鍦ㄧ敤鎴瘋〃涓嚜鍔ㄦ坊鍔犲簭鍙風敓鎴愬櫒/鑷姩鎴柇浜嬪姟鏃ュ織妯″紡
use master
go
sp_dboption db_name,"signle user",true
go
sp_dboption db_name,"trunc log on chkpt",true
go
sp_dboption db_name,"auto identity",true
use db_name
go
checkpoint
go
7)鏌ョ湅褰撳墠搴撶殑榪涚▼淇℃伅
sp_who
闄勫綍=====================================
Explanation
SQL commands are grouped into the following categories:
SQL commands that are not allowed in transactions at all.
SQL commands, such as Data Definition Language (DDL) commands, that are allowed in transactions only if the required database option (ddl in tran) is set to TRUE.
SQL commands that are allowed only if the transaction affects some other database. These commands include create table, drop table, and other commands that are run across databases to create or drop objects in another database when the database in which the objects are being created or dropped has the database option ddl in tran set to TRUE.
Error 226 occurs when Adaptive Server detects a command that is not allowed in a multi-statement transaction. A multi-statement transaction is a set of commands prefaced with the begin transaction command.
The following commands are never allowed in multi-statement transactions:
alter database
create database
dbcc reindex, dbcc fix_text
disk init
drop database
dump database, dump transaction
load database, load transaction
select into
set transaction isolation level
truncate table
update statistics
setuser
The following commands are not normally allowed in multi-statement transactions but you can use them if you use sp_dboption to set ddl in tran to TRUE first:
create default
create index
create procedure
create rule
create schema
create table
create trigger
create view
drop default
drop index
drop procedure
drop rule
drop table
drop trigger
drop view
grant
revoke
Action
If the command is allowed in a multistatement transaction when ddl in tran is set to TRUE, set ddl in tran to TRUE before running the transaction. Setting ddl in tran to TRUE causes locks on system tables and this can affect performance. You can check the current setting of ddl in tran with sp_helpdb.
If the command is never allowed in a multi-statement transaction, execute it outside the multi-statement transaction.
]]>
]]>
]]>
]]>
]]>