ASE Sysbase - Space issue

[#1]

Hi Experts,

Need to allocate space by using the mentioned isql commands in sysbase ASE 16.3

Error details :

Cannot allocate space for object "js_callouts" in database 'sybmgmtdb' because 'default' segment is full/has no free extents. if you ran out of space in syslogs, dump the transaction log. otherwise,use ALTER DATABASE to increase the size of the segment.

* what should be used for the "device name" and "log_device_name" fields and how to find them out on a windows server.
* what can be the size given in below commands.
* where can I find the transaction log..path please.

$ isql -Usapsa -S<SID> -X -w2000

use master
go
disk resize name = "<device_name>", size = "<size>M"
go

Add the new space on device <device_name> to database saptools:

use master
go
alter database saptools on <device_name>= "<size>M"
go

To increase the saptools' log segment on the <log_device_name> by xxx MB, for example:

use master
go
disk resize name = "<log_device_name>", size = "<size>M"
go
alter database saptools log on <log_device_name> = "<size>M"
go

I would appreciate all of your inputs and help.

Thanks in advance

[former_member201054]

Hi Bret,

A Big thank you and appreciate your reply.

Could you please relate the sp and ALTER commands to my case.

* Please tell me the procedure to execute sp * commands on a windows server.. navigation path please.

* from which user should I execute the sp/ALTER commands in general?..Can it be done from Database <sidadm> also?

* what should be the database name used in the field of test..Is it the ASE system ID (or) "sybmgmtdb" appearing in the error?. Please clarify.

* Instead of using the sp command, Can I use the ALTER database command also?

Please provide the detailed inputs..I would appreciate.

Thanks in advance