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

• Attempt 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

SAP Adaptive Server Enterprise (ASE) All Versions

Arithmetic overflow

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