ASE Sysbase - Space issue

[former_member201054]

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_member188958 · Accepted solution]

1) There is no one procedure. In general, you log into the ASE using some client application. SAP provides a standard simple command-line client called "isql". The typical locations for installation are c:/sybase or c:/sap, but the location is actually arbitrary. One way to find it would be to search for a "SYBASE.bat" file. Once you execute SYBASE.bat, isql should be in your search PATH (if it wasn't already), your DSQUERY (server name specification) should be set, and you should be able to connect to ASE with isql using a login and password.

2) Depends on just how general, and the security model being used. By default, the sp_helpdb and sp_helpdevice stored procedures can be executed by any user. DISK RESIZE requires a login that has sa_role. ALTER DATABASE requires sa_role or that you be the database owner.

3) The database name in the error, "sybmgmtdb"

4) ALTER DATABASE won't tell you which devices the database is already using or how much free space is currently available on them. However, you can just issue an ALTER and ASE will allocate space from what is available on any devices that have been marked as "default" devices - but you probably will want more control than that for anything but a quick-and-dirty test system.