How to retrieve non default configuration of ASE
select "Config Name"=convert(varchar(30),ss.comment) ,"Value"=convert(varchar(20),sc.value), "defvalue"=convert(varchar(20), sc.defvalue)
from syscurconfigs sc, sysconfigures ss
where sc.value != 0
and convert(varchar(255),sc.value) != sc.defvalue
and sc.config = ss.config
union
select "Config Name"=convert(varchar(30),ss.comment) ,"Value"=convert(varchar(20),sc.value2), "defvalue"=convert(varchar(20), sc.defvalue)
from syscurconfigs sc, sysconfigures ss
where sc.value2 is not null
and sc.value2 != sc.defvalue
and sc.config = ss.config
from syscurconfigs sc, sysconfigures ss
where sc.value != 0
and convert(varchar(255),sc.value) != sc.defvalue
and sc.config = ss.config
union
select "Config Name"=convert(varchar(30),ss.comment) ,"Value"=convert(varchar(20),sc.value2), "defvalue"=convert(varchar(20), sc.defvalue)
from syscurconfigs sc, sysconfigures ss
where sc.value2 is not null
and sc.value2 != sc.defvalue
and sc.config = ss.config
2 Comments:
You can also use the below command in sybase ase 15.0 to retrieve non default sybase config parameters.
Thanks,
John
http://www.sybaseteam.com (Sybase Discussion Forum) Member
By Sybase DBA, at 9:27 AM
Sorry..missed out the command in the previous comment.
sp_configure 'nondefault'
Thanks,
John
http://www.sybaseteam.com
By Sybase DBA, at 9:28 AM
Post a Comment
<< Home