SAP Knowledge Base Article - Preview

1908785 - Error 3606. Cannot define free space thresholds on data segments in a 1.6 TB database - ASE

Symptom

  • Attempted to add a freespace threshold reports 3606 error

sp_addthreshold "test_data", "default", 384000, "pr_CPPThresholdAction1500"
go

08:40:35.523 DBMS test_PRD -- Number (3606) Severity (16) State (0) Server (test_PRD) Procedure (sp_addthreshold) Arithmetic overflow occurred.

  •  sp_helpdb  (partial) reports  free kbytes as 17 TB each and clearly wrong as fragment size is only 20GB.


device_fragments               size          usage                created                   free kbytes    

------------------------------ ------------- -------------------- ------------------------- ----------------

data32    20000.0 MB  data only  Oct 5 2011 9:04AM  17179868992
data33    20000.0 MB  data only  Oct 5 2011 9:08AM  17179868512

  • Sysusages is also wrong and shows invalid number of unreservedpgs

dbid   segmap      lstart     size       vstart      location unreservedpgs crdate                          vdevno    

------ ----------- ---------- ---------- ----------- -------- ------------- ------------------------------- -----------

     18           3  293120000    5120000     5125120     NULL    4294967248             Oct  5 2011  9:04AM          44
     18           3  298240000    5120000     5125120     NULL    4294967128             Oct  5 2011  9:08AM          45

  • dbcc dbtable snippet shows negative unreserved value

dm_lstart=293120000 (dm_hi_lpage=298239999) dm_vstart=5125120 (dm_hi_vpage=15365
119)
dm_lsize=5120000 (20000 Mb)  *dbt_unrsvd=-48
dm_vstart=[ 0x1008463f298 vpgdevno=44 vpvpn=5125120 vdisk=0x1000c1cfef0 ]
dm_segmap: 0x00000003 (0x00000002 (SEG_DEFAULT), 0x00000001 (SYS_SEGMENT))
dm_lstart=298240000 (dm_hi_lpage=303359999) dm_vstart=5125120 (dm_hi_vpage=15365
119)
dm_lsize=5120000 (20000 Mb)  *dbt_unrsvd=-168


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

Arithmetic overflow

, KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.