Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

sp_monitor arithmetic overflow

9 posts in General Discussion Last posting was on 2011-01-19 13:12:26.0Z
David Posted on 2011-01-18 09:53:48.0Z
Sender: 72bc.4d3562a8.846930886@sybase.com
From: David
Newsgroups: sybase.public.ase.general
Subject: sp_monitor arithmetic overflow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d35632c.72cc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jan 2011 01:53:48 -0800
X-Trace: forums-1-dub 1295344428 10.22.241.41 (18 Jan 2011 01:53:48 -0800)
X-Original-Trace: 18 Jan 2011 01:53:48 -0800, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29863
Article PK: 79091

I'm running sybase 12.5.2 and we are now getting an
arithmetic overflow error on total reads is there an easy
fix for this ?
can you update spt.monitor table to fix this?


Rob V [ Sybase ] Posted on 2011-01-18 12:09:17.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: sp_monitor arithmetic overflow
References: <4d35632c.72cc.1681692777@sybase.com>
In-Reply-To: <4d35632c.72cc.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d3582ed@forums-1-dub>
Date: 18 Jan 2011 04:09:17 -0800
X-Trace: forums-1-dub 1295352557 10.22.241.152 (18 Jan 2011 04:09:17 -0800)
X-Original-Trace: 18 Jan 2011 04:09:17 -0800, vip152.sybase.com
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29864
Article PK: 79094


On 18-Jan-2011 10:53, David wrote:
> I'm running sybase 12.5.2 and we are now getting an
> arithmetic overflow error on total reads is there an easy
> fix for this ?
> can you update spt.monitor table to fix this?

These variables are of type 'int' so they may indeed overflow.
Unfortunately, there's no way to fix this yourself as far as I can see.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


Rob V [ Sybase ] Posted on 2011-01-18 13:34:33.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: sp_monitor arithmetic overflow
References: <4d3582ed@forums-1-dub> <4d359632.7da0.1681692777@sybase.com>
In-Reply-To: <4d359632.7da0.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d3596e9$1@forums-1-dub>
Date: 18 Jan 2011 05:34:33 -0800
X-Trace: forums-1-dub 1295357673 10.22.241.152 (18 Jan 2011 05:34:33 -0800)
X-Original-Trace: 18 Jan 2011 05:34:33 -0800, vip152.sybase.com
Lines: 53
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29866
Article PK: 79095


On 18-Jan-2011 14:31, Dav id wrote:
>> On 18-Jan-2011 10:53, David wrote:
>>> I'm running sybase 12.5.2 and we are now getting an
>>> arithmetic overflow error on total reads is there an
>>> easy fix for this ?
>>> can you update spt.monitor table to fix this?
>> These variables are of type 'int' so they may indeed
>> overflow. Unfortunately, there's no way to fix this
>> yourself as far as I can see.
>>
>> HTH,
>>
>> Rob V.
>> ----------------------------------------------------------
>> ------- Rob Verschoor
>>
>> Certified Sybase Professional DBA for ASE
>> 15.0/12.5/12.0/11.5/11.0 and Replication Server
>> 15.0.1/12.5 // TeamSybase
>>
>> Author of Sybase books (order online at
>> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
>> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
>> Reference Guide" "The Complete Sybase Replication Server
>> Quick Reference Guide"
>>
>> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
>> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
>> Commerce 27138666
>> ----------------------------------------------------------
>> -------
>> Is there a way I can reset the spt_monitor table with out
> havign to recycle the sybase server?

Yes, if you reboot ASE, the coutners will go to zero again.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


David Posted on 2011-01-18 13:38:58.0Z
Sender: 7326.4d3566b9.1804289383@sybase.com
From: David
Newsgroups: sybase.public.ase.general
Subject: Re: sp_monitor arithmetic overflow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d3597f2.7de6.1681692777@sybase.com>
References: <4d3596e9$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jan 2011 05:38:58 -0800
X-Trace: forums-1-dub 1295357938 10.22.241.41 (18 Jan 2011 05:38:58 -0800)
X-Original-Trace: 18 Jan 2011 05:38:58 -0800, 10.22.241.41
Lines: 62
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29867
Article PK: 79097


> On 18-Jan-2011 14:31, Dav id wrote:
> >> On 18-Jan-2011 10:53, David wrote:
> >>> I'm running sybase 12.5.2 and we are now getting an
> >>> arithmetic overflow error on total reads is there an
> >>> easy fix for this ?
> >>> can you update spt.monitor table to fix this?
> >> These variables are of type 'int' so they may indeed
> >> overflow. Unfortunately, there's no way to fix this
> >> yourself as far as I can see.
> >>
> >> HTH,
> >>
> >> Rob V.
> >>
> ----------------------------------------------------------
> >> ------- Rob Verschoor >>
> >> Certified Sybase Professional DBA for ASE
> >> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> >> 15.0.1/12.5 // TeamSybase
> >>
> >> Author of Sybase books (order online at
> >> www.sypron.nl/shop): "Tips, Tricks& Recipes for
> Sybase >> ASE" (ASE 15 edition) "The Complete Sybase ASE
> Quick >> Reference Guide" "The Complete Sybase Replication
> Server >> Quick Reference Guide"
> >>
> >> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> >> @rob_verschoor Sypron B.V., The Netherlands | Chamber
> of >> Commerce 27138666
> >>
> ----------------------------------------------------------
> >> ------- >> Is there a way I can reset the spt_monitor
> > table with out havign to recycle the sybase server?
> Yes, if you reboot ASE, the coutners will go to zero
> again.
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Sybase Professional DBA for ASE
> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
> Reference Guide" "The Complete Sybase Replication Server
> Quick Reference Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------
> Thanks I was jost hoping there was a way of doing this

with out restarting the ASE server as it is a prodcution
server
but thanks for your help
could I not update the table directly?


Rob V [ Sybase ] Posted on 2011-01-18 15:41:17.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: sp_monitor arithmetic overflow
References: <4d3596e9$1@forums-1-dub> <4d3597f2.7de6.1681692777@sybase.com>
In-Reply-To: <4d3597f2.7de6.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4d35b49d$1@forums-1-dub>
Date: 18 Jan 2011 07:41:17 -0800
X-Trace: forums-1-dub 1295365277 10.22.241.152 (18 Jan 2011 07:41:17 -0800)
X-Original-Trace: 18 Jan 2011 07:41:17 -0800, vip152.sybase.com
Lines: 113
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29869
Article PK: 79096


On 18-Jan-2011 14:38, David wrote:
>> On 18-Jan-2011 14:31, Dav id wrote:
>>>> On 18-Jan-2011 10:53, David wrote:
>>>>> I'm running sybase 12.5.2 and we are now getting an
>>>>> arithmetic overflow error on total reads is there an
>>>>> easy fix for this ?
>>>>> can you update spt.monitor table to fix this?
>>>> These variables are of type 'int' so they may indeed
>>>> overflow. Unfortunately, there's no way to fix this
>>>> yourself as far as I can see.
>>>>
>>>> HTH,
>>>>
>>>> Rob V.
>>>>
>> ----------------------------------------------------------
>>>> ------- Rob Verschoor>>
>>>> Certified Sybase Professional DBA for ASE
>>>> 15.0/12.5/12.0/11.5/11.0 and Replication Server
>>>> 15.0.1/12.5 // TeamSybase
>>>>
>>>> Author of Sybase books (order online at
>>>> www.sypron.nl/shop): "Tips, Tricks& Recipes for
>> Sybase>> ASE" (ASE 15 edition) "The Complete Sybase ASE
>> Quick>> Reference Guide" "The Complete Sybase Replication
>> Server>> Quick Reference Guide"
>>>> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
>>>> @rob_verschoor Sypron B.V., The Netherlands | Chamber
>> of>> Commerce 27138666
>> ----------------------------------------------------------
>>>> ------->> Is there a way I can reset the spt_monitor
>>> table with out havign to recycle the sybase server?
>> Yes, if you reboot ASE, the coutners will go to zero
>> again.
>>
>> HTH,
>>
>> Rob V.
>> ----------------------------------------------------------
>> ------- Rob Verschoor
>>
>> Certified Sybase Professional DBA for ASE
>> 15.0/12.5/12.0/11.5/11.0 and Replication Server
>> 15.0.1/12.5 // TeamSybase
>>
>> Author of Sybase books (order online at
>> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
>> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
>> Reference Guide" "The Complete Sybase Replication Server
>> Quick Reference Guide"
>>
>> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
>> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
>> Commerce 27138666
>> ----------------------------------------------------------
>> -------
>> Thanks I was jost hoping there was a way of doing this
> with out restarting the ASE server as it is a prodcution
> server
> but thanks for your help
> could I not update the table directly?

I don't think you can...

Rob V.

--
Dear Sybase user,

I am currently unable to respond to the specific question(s) which you have sent me. Due to the ever increasing number of questions I am receiving, I currently simply don't have the time to answer detailed individual questions.
Please post your question to one of the ASE-related newsgroups so that the ASE community can participate/benefit.
These newsgoups are comp.databases.sybase (Usenet), as well as various newsgroups on Sybase's own news server (forums.sybase.com).
Also, please provide sufficient technical details (error messages, actual queries, query plans, etc.) about your problem.
Try the Sybase FAQ at http://www.isug.com/Sybase_FAQ/, which contains answers to many questions about ASE.

Kind regards,

Rob Verschoor

If you don't want to use X Windows, you could try "sybinit4ever", a free tool which uses only an ASCII interface to create a new ASE server. It can be downloaded from http://www.sypron.nl/si4evr.html

See the
ASE reference manual / System Administration Guide / Transact-SQL user's guide
This / These books can be viewed or downloaded as PDF files from the Sybase website http://www.sybase.com/support/manuals/ . For more details how to get there, see http://www.sypron.nl/sybbooks.html .

For more information on the background of this problem, as well as a solution, see http://www.sypron.nl/idgaps.html .

... syntax and description are in the ASE Quick Reference Supplement, which you can download from http://www.sypron.nl/ase_qref.html (for a better version, see my book -- www.sypron.nl/qr).


To use dynamic SQL, you need at least ASE version 12.0, which has the "execute immediate" feature for this. In earlier versions of ASE you can simulate some types of dynamic SQL though; for more information, see http://www.sypron.nl/dynsql.html and http://www.sypron.nl/dynsqlcis.html .

For more information about Sybase Certification Exams, see http://www.sypron.nl/certtips.html .

The ASE Performance and Tuning Guide contains a lot fo info about this topic. You can download this manual from http://sybooks.sybase.com/as.html .

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


jobless Posted on 2011-01-18 23:58:51.0Z
Sender: 130f.4d35f521.1804289383@sybase.com
From: jobless
Newsgroups: sybase.public.ase.general
Subject: Re: sp_monitor arithmetic overflow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d36293b.1c8e.1681692777@sybase.com>
References: <4d35632c.72cc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jan 2011 15:58:51 -0800
X-Trace: forums-1-dub 1295395131 10.22.241.41 (18 Jan 2011 15:58:51 -0800)
X-Original-Trace: 18 Jan 2011 15:58:51 -0800, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29873
Article PK: 79101


> I'm running sybase 12.5.2 and we are now getting an
> arithmetic overflow error on total reads is there an
> easy fix for this ?
> can you update spt.monitor table to fix this?

I recall having same issue few years back on a trading
server ON 12.5.3 server. (when I did have a job :( )

It is due to int cols as already pointed out and you know
one of the solutions to reboot.
But you can also be fixed by updating the spt_monitor table
and 0 out the counters. This avoids a re-boot.
We did re-create the table with larger datatype and was
supported by tech support. Since u are referring production
server, u should hv support contract. Ask them to search for
a case and they should find one with the fix I had listed.
You might get some more details. We never rebooted the
server but use to run updates often then we ended up
re-creating the tables itself....


PDreyer Posted on 2011-01-19 13:07:21.0Z
Sender: 3a6c.4d36e17c.1804289383@sybase.com
From: PDreyer
Newsgroups: sybase.public.ase.general
Subject: Re: sp_monitor arithmetic overflow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d36e209.3a80.1681692777@sybase.com>
References: <4d35632c.72cc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Jan 2011 05:07:21 -0800
X-Trace: forums-1-dub 1295442441 10.22.241.41 (19 Jan 2011 05:07:21 -0800)
X-Original-Trace: 19 Jan 2011 05:07:21 -0800, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29876
Article PK: 79106


> I'm running sybase 12.5.2 and we are now getting an
> arithmetic overflow error on total reads is there an
> easy fix for this ?
> can you update spt.monitor table to fix this?

See if this fix your problem

update master.dbo.spt_monitor
set
lastrun = getdate(),
cpu_busy = @@cpu_busy,
io_busy = @@io_busy,
idle = @@idle,
pack_received = @@pack_received
pack_sent = @@pack_sent,
connections = @@connections,
pack_errors = @@packet_errors,
total_read = @@total_read,
total_write = @@total_write,
total_errors = @@total_errors


PDreyer Posted on 2011-01-19 13:12:26.0Z
Sender: 3a6c.4d36e17c.1804289383@sybase.com
From: PDreyer
Newsgroups: sybase.public.ase.general
Subject: Re: sp_monitor arithmetic overflow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d36e33a.3aa9.1681692777@sybase.com>
References: <4d36e209.3a80.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Jan 2011 05:12:26 -0800
X-Trace: forums-1-dub 1295442746 10.22.241.41 (19 Jan 2011 05:12:26 -0800)
X-Original-Trace: 19 Jan 2011 05:12:26 -0800, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29877
Article PK: 79108


> > I'm running sybase 12.5.2 and we are now getting an
> > arithmetic overflow error on total reads is there an
> > easy fix for this ?
> > can you update spt.monitor table to fix this?
>
> See if this fix your problem
>
> update master.dbo.spt_monitor
> set
> lastrun = getdate(),
> cpu_busy = @@cpu_busy,
> io_busy = @@io_busy,
> idle = @@idle,
> pack_received = @@pack_received
> pack_sent = @@pack_sent,
> connections = @@connections,
> pack_errors = @@packet_errors,
> total_read = @@total_read,
> total_write = @@total_write,
> total_errors = @@total_errors

The period should be an underscore in the variables