on 12-30-2014 2:52 PM
Dear Ase Gurus,
We are taking dump like DBIF_RSQL_SQL_ERROR,
Short Text
SQL error 1105 occurred while accessing table "ALCLASTOOL".
What happened?
Database error text: "[ASE Error SQL1105]Can't allocate space for object
'ALCLASTOOL' in database 'HCP' 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 th".
When i check space on db,
sp_helpdb HCP
go
Returns screen shot
Not appliable mean : Not enough space for log database sure ?
Should increase log.database with this command ? And should i restart Sybase Ase and SAP ?
disk resize name ="HCP_log_002" , size="15G"
Best Regards
Hi Kemal,
This has already a lot of replies, let just summarize.
1) the "not applicable" you see on a sp_helpdb for log segment doesn't means "Not enough space for log". It is always returned for any log segment (let say that free space of transaction log cannot be estimated while transactions are running).
2) The error : "
Database error text: "[ASE Error SQL1105]Can't allocate space for object
'ALCLASTOOL' in database 'HCP' 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 th".
"
indicated that your "data" segment (not the log segment) was fullfiled. You have been instructed about how to increase the data segment.
3) for the data segment fullfiled on database "saptools", your DBACockpit screenshot is showing that the data segment of "saptools" is full, and the output you sent from command line is about the available space on device saptools_data_001 (1gb) but the other 1Gb marked red has been added to saptempdb_data_001 that is a saptempdb database device.
As mentioned Mark an sp_helpdb would help to understand which devices are used for each databases, or a snapshot from your DBA Cockpit ( go to Database HCP -> Space -> Databases -> click on HCP (or saptools) -> tab "Devices" )
For information about free spaces on "saptools" database, you may check Note 1836607 - SYB: How to solve error 1105 in database "saptools".
Just for the record: you can avoid such error 1105, to use the Automatic Database Extension feature.
HTH,
Best regards,
Victoria.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.