学习总结

svn help command:获取子命令说明。
svn info $URL 查看工作空间信息
svn info $DIR 查看目录信息


fedora 共享windows 目录

mount   -t   cifs   -o   username=sti,password=sti   //terminal/software   /home1/tournet/soft_bk

产看sybase 实例名称

select @@servername

sybase 查看执行计划

set showpalan on

set noexec on

go

linux查看执行历史命令

history ,history n  查看所有和查看n条历史命令

history -d n  删除第n条命令

! n，! -n 执行第n条历史命令 ，执行倒数第n条命令

!! 执行最后一条历史命令，! [String] 执行以String 开头的语句

定时svn更新代码

30 11 * * * /usr/bin/svn update /home/wangzhen/SZFY/40_源码
32 11 * * * /usr/bin/svn update /home/wangzhen/SZFY/20_工程过程

查询各系统的IP地址

SELECT t.C_KEY,substring(t.IP,1,charindex(t.T,t.IP)-1) AS IP FROM (SELECT C_KEY,':' AS T,substring(C_VALUE,8,len(C_VALUE)-7) AS IP FROM JCSZ..T_PZ_XTPZXX 
WHERE C_KEY in ('sys.np.fy.url.spxt','sys.np.fy.url.laxt',
'sys.np.fy.url.sym','sys.np.fy.url.ajxq','sys.np.fy.url.xtgl',
'sys.np.fy.url.dzjz','sys.np.fy.url.blxt','sys.np.fy.url.sgb',
'sys.np.fy.url.tjfx','sys.np.fy.url.wyxt','sys.np.fy.url.dwjk',
'sys.np.fy.url.ssoServer')) t

慢sql典型:

select tzxaj0_.C_BH as col_0_0_ from YWST.dbo.T_ZX_AJ tzxaj0_ where tzxaj0_.N_JBFY=1732 and (tzxaj0_.N_AJJZJD=10 or tzxaj0_.N_AJJZJD=11) and (tzxaj0_.DT_FASJ 
is not null) and tzxaj0_.N_JAFS=10 and tzxaj0_.N_CBR=113508418 and not (exists (select tzxzxyaj1_.C_BH from YWST.dbo.T_ZX_ZXYAJ tzxzxyaj1_, YWST.dbo.T_ZX_AJ 
tzxaj2_ where tzxzxyaj1_.C_BH_AJ=tzxaj2_.C_BH and tzxaj2_.N_ZXCX=9 and (tzxaj0_.C_BH=tzxzxyaj1_.C_BH_YSAJ or tzxaj0_.C_AH=tzxzxyaj1_.C_AH and (tzxzxyaj1_.N_JBFY 
in (1732))))) and not (exists (select tzxzxyj3_.C_BH from YWST.dbo.T_ZX_ZXYJ tzxzxyj3_, YWST.dbo.T_ZX_AJ tzxaj4_ where tzxzxyj3_.C_BH_AJ=tzxaj4_.C_BH and 
tzxaj4_.N_ZXCX=9 and (tzxaj0_.C_BH=tzxzxyj3_.C_BH_YSAJ or tzxaj0_.C_AH=tzxzxyj3_.C_YSAH and (tzxzxyj3_.N_JBFY in (1732))))) 

上午排查问题总结：

现象江西现场环境很慢。数据库有锁，cup很高。

Sybase uuid: select newid()

sybase insert into select:insert into table_a  select * from table_b 

 

sybase 生成kill lock语句:

select 'kill '+str(t.ss) from (select  distinct lo.spid as ss  from master..syslocks lo left join master..sysprocesses pro on lo.spid=pro.spid  where pro.status !='stoped' and object_name(lo.id) = 'T_ZX_CCCK_ZDCXRW') t