R&D test the database and find that the database table tAlarmToTrail can be reconstruct...949536 KB to 5712 KB
We tried to reconstruct the database to decrease the database table size by below procedure:
# . /opt/sybase/SYBASE.sh
root@Secondary # isql -Usa -SDBSVR -P
1> use TNSDHDB
1> reorg rebuild tAlarmToTrail
Beginning REORG REBUILD of table 'tAlarmToTrail'.
Msg 1105, Level 17, State 16:
Server 'DBSVR', Line 1:
Can't allocate space for object 'tAlarmToTrail' in database 'TNSDHDB' 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.
So this procedure fail due to NOT enough space in database --> so the only choice is to increase the database size. (R&D had little bit earlier database data so there were able to reconstruct the database)