2673068 - Error 1105 Can't allocate space for object .. in dbccdb with sp_dbcc_alterws - SAP ASE

Error 1105 has appeared when the workspace is extended by 10 MB on the scanseg segment by using sp_dbcc_alterws.
But, there is 20.5 MB (636+20400) as a free space with sp_helpdb.

[Sample]

1> sp_dbcc_alterws dbccdb , scan_pubs2, "10M"
2> go
Msg 1105, Level 17, State 3:
Server 'ase1600', Procedure 'sp_dbcc_run_alterws', Line 242:
Can't allocate space for object 'scan_pubs2' in database 'dbccdb' because 'scanseg' 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.
Msg 9984, Level 16, State 2:
Server 'ase1600', Procedure 'sp_dbcc_run_alterws', Line 242:
DBCC could not expand the size of workspace 'scan_pubs2' in database 'dbccdb' to 1280 pages.
(return status = 1)   

1> sp_helpdb dbccdb
2> go
 name   db_size       owner dbid  created      durability lobcomplvl inrowlen status
 ------ ------------- ----- ----- ------------ ---------- ---------- -------- ----------------------------
 dbccdb       60.0 MB sa    31515 Jul 24, 2018 full                0     NULL select into/bulkcopy/pllsort

(1 row affected)

 device_fragments size          usage     created             free_kbytes
 ---------------- ------------- --------- ------------------- ----------------
 dbccdb_dat             20.0 MB data only Jul 24 2018  8:51AM              636
 dbccdb_log             20.0 MB log only  Jul 24 2018  8:51AM not applicable
 dbccdb_dat2            20.0 MB data only Jul 24 2018  9:04AM            20400

 --------------------------------------------------------------------------------------------------------------
 log only free kbytes = 20376
(return status = 0)

 

Read more...

• SAP Adaptive Server Enterprise (ASE)

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

textseg , text ,  sp_dbcc_createws , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To