▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄
LINUX下启动SYBASE数据库
查看服务是否已经启动:showserver
启动的命令:
# unset LANG 回车
# RUN_服务名 (可按:TAB键) 回车
▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄
Sybase数据库锁表时,在SQL ADVANTAGE中使用
sp_lock 插锁
sp_who 查进程号
kill spid(进程号)
sp_helpdb dbname 查数据库剩余空间
在 SQL Advantage里执行下边的语句,查询锁表情况:
select l.spid,
locktype=convert(char(12),name),
dbname=convert(char(15),db_name(l.dbid)),
'table'=convert(char(15),object_name(l.id,l.dbid)),
page,
class=convert(char(15),class),
hostname,
cmd
from master..syslocks l,master..spt_values v,master..sysprocesses p
where l.type = v.number and
v.type = 'L' and
l.spid = p.spid
order by spid
查看表名
select object_name(id)
▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄
查询数据库触发器
select name,object_name(instrig) trigoninsert,object_name(deltrig) trigondel,object_name(updtrig) trigonupd
from sysobjects
where type='U' and (instrig > 0 or deltrig>0 or updtrig>0);
▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄
CS中心同步服务器脚本:dbmlsrv7 -c "dsn=sybase;uid=sa;pwd=" -o c:\1error.log
CS定点数据库里的刷同步脚本语句:alter Synchronization site x RENAME HXXX,ADDRESS 'HOST=192.168.1.1;PORT=2439';
CS定点启定点网络库:dbsrv7 -c 12m "C:\Documents and Settings\Administrator\master.db" -ti0 -n policy
dbsrv7 "D:\database\HIS_NEW\masterhis.db" -n policy -x tcpip{host=10.1.1.123,port=2439} -c 20m -ti0
CS定点同步上传语句:dbmlsync -c "dsn=policy;uid=dba;pwd=sql"
CS定点坏库导出语句:dbtran "dsn=shop;uid=dba;pwd=sql" mastershop.log 1.sql
dbtran -d -j 2012/03/01 mastershop.log 123.sql
▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄
CS定点库修改具有同步属性的表
alter synchronization definition HRBYB_HOS delete table t_unpay_inp_regi_temp ; 去掉同步属性
alter table t_unpay_inp_regi_temp modify INHOS_DIAG varchar(200) NULL; 修改字段长度
alter table t_unpay_inp_regi_temp modify OUTHOS_DIAG varchar(200) NULL;
alter synchronization definition HRBYB_HOS add table t_unpay_inp_regi_temp ; 增加同步属性
▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄
CS结构前置机配置流程:
①安装 BDE 、ASA7.0 、asa_704_升级 、 sybase11 、 PB8.0 ;
②复制ODBC文件夹导入注册表:按说明将升级odbc-3_5文件夹放到C盘下,执行asaodbc.reg和aseodbc2.reg这二个文件导入注册表;
③配置ODBC数据源:运行ODBC Administrator,在用户DSN下S选择ybase ASE ODBC Driver选项,弹出ODBC Sybase ASE Setup窗口。在【常规】
标签下添加【数据源名】必须为sybase,【服务器名】【数据库名】。在【连接】标签下添加【服务器列表】【数据库列表】
【缺省登陆ID】默认为sa。完成后点击下方【Test Connect】按钮,出现【Connection established!】则配置成功。
④刷同步脚本:先用SQL Advantage连上库执行一下sync_ase5.0.sql这个文件,完成后运行【PUSH.bat】文件
⑤打开中心的同步服务器:把【sync.bat】复制到D盘运行。
⑥运行Exename.exe 同时添加快捷方式到启动
⑦运行backup.exe 同时添加快捷方式到启动
▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄
▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄
▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄
▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄ ▄