cancel
Showing results for 
Search instead for 
Did you mean: 

How to change sybase database parameter.

former_member362299
Participant
0 Kudos

Hi Team,

I want to set new value in sp_configure, i am not able to set value . Kindly share me the steps to set parameter.

DB- sybase 16.

OS- windows server 2012.

regards

Manjappa

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

Hi Manjappa,

could you please share which parameter value you want to change in the database.

Regards

sunil

former_member362299
Participant
0 Kudos

Hi Sunil,

I want "set stack guard size" to 4096.

regards

Manjappa

Former Member
0 Kudos

Hi Manjappa,

can you check the parameter through t-code 'dbacockpit' then database SID ---> configuraation --> server configuration. search for the parameter and you can change the value.

regards

sunil

former_member362299
Participant
0 Kudos

Hi Sunil,

I have some problem in DBA cockpit, it is showing that page can't be displayed. Is there anyway we can set from OS level. l

regards

Manjappa

Former Member
0 Kudos

Hi Manjappa,

you can do this through command also. please run the following command.

isql -w999 -Usapsa -P<sapsa password> -S <DB SID> -X

use master

go

spconfigure 'stack guard size',4096

go

Regards

Sunil

Former Member
0 Kudos

HI,

please use sp_configure instead spconfigure.



Regards

Sunil

Answers (2)

Answers (2)

former_member362299
Participant
0 Kudos

thank you sunil, issue resolved.

Former Member
0 Kudos

Dear Manjappa,

Login with syb<sid> and password.

Go to command line

Enter isql -Usapsa -P<pwd> -X

use master

go

spconfigure 'stack guard size',4096

go


former_member362299
Participant
0 Kudos

Thank you, resolved.