#27 AseDbSpce - getting arithmetic overflow

[Murali Sabapathi]

2012/08/08 16:55:26.083 BOJ1_TOK_UAT_ASE_AseDbSpce - Error in loop. Error=3606 SQL message=Arithmetic overflow occurred. state=22003
com.sybase.jdbc3.jdbc.SybSQLException: Arithmetic overflow occurred.

Am using,
2012/08/08 16:55:12.060 main - Start Asemon_logger Version V2.7.3
2012/08/08 16:55:12.117 main - Current directory is : /BOJ1U/sybase/dba/mda
2012/08/08 16:55:12.118 main - Java version : 1.7.0_03

against the latest Adaptive Server Enterprise/15.7.0/EBF 20373 SMP ESD#02.

Is this fixed in asemon 2.7.5 ?

[Jean-Paul Martin]

Had same problem with "Fragment" collector just after installing ESD2 (some ASE counters like "number of empty pages" was over 4 billion) (I use asemon 2.7.5)

I fixed the problem with "dbcc checkdb"

A "update stat" may also solve the problem

Tell me if it fixes the problem

If not can you try identify the bad counter (runing manually the AseDbSpce SQL

[Murali Sabapathi]

Ran both 'dbcc checkdb' & update stats, didnt help.

This statement meets with the error 3606.

update #loginfo
set logUsed_pgs = logTotal_pgs - logFree_pgs - logClr_pgs
where isMixedLog=0

strangely, logTotal_pgs is less than logFree_pgs for one dbid (6) !

09Aug2012_17:24:42@BOJ1_TOK_UAT_ASE.master> select dbid, size from sysusages where dbid = 6 and segmap = 4;
dbid size --------------------------------------------------------------------------
6 51200
6 460800 (2 rows affected)
09Aug2012_17:24:48@BOJ1_TOK_UAT_ASE.master> select lct_admin("logsegment_freepages",6) - lct_admin("reserved_for_rollbacks",6);

---

968990

[Jean-Paul Martin]

Can you try :

dbcc tablealloc (syslogs, full, fix) -- need 'single user' on database

dbcc usedextents (your database, 1 ,1 )

on your database, in order to fix corrupted counters

[Murali Sabapathi]

That seems to have fixed it !