add device command in sybase

[former_member547765]

Hi,

i got error "can't allocate space for object 'syslog' in database 'SID' because 'logsegment' segment is full........"

i try to add device using this command

when i check in /sybase/SID/saplog_1 there is one physical file using extension .dat

did i used the wrong command?

Regards

[luc_vanderveurst]

Hi,

You specified ***_log_002 in your command, and I can see a ***_log_002 file.

If you want that the file has a .dat extension, you have to specify it in the disk init command.

Since you didn't use the device yet in a database allocation, you can remove it with:

sp_dropdevice '***_log_002'

and recreate it with name '***_log_002', and physical name '/sybase***/***_log_002.dat'

HTH,

Luc.

[former_member547765]

Hi luc.vanderveurst

should i stop the sap because the device is being used

1> sp_dropdevice 'SID_log_002'
2> go
Msg 17482, Level 16, State 1:
Server 'SID', Procedure 'sp_dropdevice', Line 132:
Device is being used by a database. You can't drop it.
 database_name           device                size
 ----------------------- --------------------- ----------------------------
 SID                     SID_log_002           1024 MB


(1 row affected)
(return status = 1)

Regards

[luc_vanderveurst]

Hi Irfan,

Ok, it means you have also executed:

alter database SID log on SID_log_002 = 1024

Is this test or production?

You can shrink the database with (if I read it correctly in the documentation, I have never used this) :

alter database SID off SID_log_002 = 1024

I suppose it will then be possible to drop te device, recreate it with the correct name, and reallocate the space to the database.

It is possible to that you have to put the database in single user mode to do that.
You should google for sybase ase schrinking database, and read the documentation.
You can also leave the filename as it is.

Best Regards,
Luc.

[former_member547765]

Hi luc.vanderveurst

yes this is solution manager prod

thanks for your answer

Regards

[hrollizo]

Hi,

you can follow this SAP Note:

1931223 - Error SQL1105 "Can't allocate space for object..." - SAP ASE for Business Suite and SAP BW

If you ran out of space in syslogs, dump the transaction log.
Otherwise, use ALTER DATABASE to increase the size of the segment.

/sybase/<SID>% cd $SYBASE/$SYBASE_OCS/bin
isql -Usapsa -Pyourpassword -SGSD -X

use master
go
disk resize name ="<SID>_log_001",size="2G"
go
alter database <SID> log on <SID>_log_001="2G"
go

To reallocate:

update sysdevices set phyname = '/sybase/<SID>/sapdata1/<SID>_data_001.dat' where phyname = '/sybase/<SID>/sapdata_1/<SID>_data_001.dat'

Regards