on 07-15-2020 5:19 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.