SAP Knowledge Base Article - Preview

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

Symptom

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...

Environment

  • SAP Adaptive Server Enterprise (ASE)

Product

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

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.