Symptom
- 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
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) All Versions
Product
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.