따봉 구걸남's 블로그

select t.HOST명, t.디바이스명, t.물리적디바이스명, t.DB명, t.할당, t.가용, t.사용율, t.SegMap설명, t.crdate
from
(
SELECT      
"HOST명"=@@servername,     
"디바이스명" = substring(d.name, 1, 20),     
"물리적디바이스명"=d.phyname,      
"DB명" = db_name(u.dbid),     
"할당" = round(u.size /(512.0/(@@maxpagesize/@@pagesize)),2),     
"가용"=  round(curunreservedpgs(u.dbid,u.lstart,u.unreservedpgs)/ (512.0/(@@maxpagesize/@@pagesize)),2) ,     
"사용율"= round(  ((u.size-curunreservedpgs(u.dbid,u.lstart,u.unreservedpgs))*100.0/u.size),2) ,     
"SegMap설명" = case segmap when 4 then "LOG"     
               else "DATA" end,   
convert(varchar(8),u.crdate,112) as crdate,1 col
FROM      
master.dbo.sysdevices d,      
master.dbo.sysusages u      
WHERE   u.vdevno = d.vdevno
and d.phyname not in ('/dev/rmt4','/dev/rst0')
and db_name(u.dbid) not in ('master','sybsystemdb','sybsystemprocs','tempdb','tempdb2')     
union all
SELECT      
"HOST명"=@@servername,     
"디바이스명" = substring(d.name, 1, 20),     
"물리적디바이스명"=d.phyname,      
"DB명" = db_name(u.dbid),     
"할당" = round(u.size /(512.0/(@@maxpagesize/@@pagesize)),2),     
"가용"=  round(curunreservedpgs(u.dbid,u.lstart,u.unreservedpgs)/ (512.0/(@@maxpagesize/@@pagesize)),2) ,     
"사용율"= round(  ((u.size-curunreservedpgs(u.dbid,u.lstart,u.unreservedpgs))*100.0/u.size),2) ,     
"SegMap설명" = case segmap when 4 then "LOG"     
               else "DATA" end,   
convert(varchar(8),u.crdate,112) as crdate, 2 col   
FROM      
master.dbo.sysdevices d,      
master.dbo.sysusages u      
WHERE   u.vdevno = d.vdevno
and d.phyname not in ('/dev/rmt4','/dev/rst0')
and db_name(u.dbid) in ('master','sybsystemdb','sybsystemprocs','tempdb','tempdb2')     
) t
ORDER BY col, DB명

sybase 15.7 기준

isql -Usa -w400     

2) lock session check

sp_lock

-- lock check

sp_who

-- session check

spid 확인

3) kill 세션

kill 'spid'

# ASE

-- 건수제한

sp_modify_resource_limit '계정', NULL,'at all times',row_count,건수,2,4,1

-- 시간제한

sp_modify_resource_limit ‘계정’, NULL,'at all times',elapsed_time,시간,2,4,6

​

ex) sp_modify_resource_limit 'testuser', NULL,'at all times',row_count,200,2,4,1

​

확인 : sp_help_resource_limit 

​

#IQ

​

​​sp_iqcheckoptions

set option 계정.QUERY_ROWS_RETURNED_LIMIT ='1000'

​