Error -1215 Value exceeds limit of INTEGER precisi
FRANK saw SCHAPI error -1215 (value exceeds limit of INTEGER precision) in the online log of 11.70 FC7 and asked how to find the session. Art Kagel said it was a task manager task, so check sysadmin:ph_run. John Miller said the mon_users task has 4-byte counters that overflow past 2 billion, so re-create the table with 8-byte integers. BENJAMIN cited APAR IC89509.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Folks, IDS11.70 FC7, Linux Redhat 5 Any idea how to catch the session who caused the error in online log file? Thanks, Frank 09:39:52 Maximum server connections 348 09:39:52 Checkpoint Statistics - Avg. Txn Block Time 0.005, # Txns blocked 4, Plog used 19337, Llog used 111149 09:44:35 SCHAPI: [mon_users 11-5321] Error -1215 Value exceeds limit of INTEGER precision 09:44:54 Checkpoint Completed: duration was 1 seconds. 09:44:54 Wed Oct 9 - loguniq 115409, logpos 0x2cf571a0, timestamp: 0xd6b2ce10 Interval: 274449 --047d7b6783aa121d9304e8640680
It was a task manager monitoring task. Just look for a task that ran at around 9:39.52 in sysadmin:ph_run. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 10, 2013 at 10:43 AM, FRANK <yunyaoqu@gmail.com> wrote: > Folks, > > IDS11.70 FC7, Linux Redhat 5 > > Any idea how to catch the session who caused the error in online log file? > > Thanks, > Frank > > 09:39:52 Maximum server connections 348 > 09:39:52 Checkpoint Statistics - Avg. Txn Block Time 0.005, # Txns blocked > 4, Plog used 19337, Llog used 111149 > 09:44:35 SCHAPI: [mon_users 11-5321] Error -1215 Value exceeds limit of > INTEGER precision > 09:44:54 Checkpoint Completed: duration was 1 seconds. > 09:44:54 Wed Oct 9 - loguniq 115409, logpos 0x2cf571a0, timestamp: > 0xd6b2ce10 Interval: 274449 > > --047d7b6783aa121d9304e8640680 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0160b8284d3bee04e8645728
This is a known issue with the mon=5Fusers task. The co= unters in the sysmaster table are 8 byte integers, but the mon=5Fuser ta= ble are 4 byte integers. When the value exceed 2 billion the overf= low occurs. You can just drop and re-create the mon=5Fuser table w= ith 8 byte integers instead of 4 byte integers. John F. Mill= er III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IB= M Informix Dynamic Server (IDS) -----= ids-bounces@iiug.org wrote: ----- >To: ids@iiug.org >= ;From: "Art Kagel" >Sent by: ids-bounces@iiug.org >Date: 10/10= /2013 08:06AM >Subject: Re: Error -1215 Value exceeds limit of INTEGE= R.... [31684] > >It was a task manager monitoring task. Just l= ook for a task that ran >at around 9:39.52 in sysadmin:ph=5Frun. A= rt Art S. Kagel, >Principal Consultant Advanced DataTools (www.ad= vancedatatools.com) >Blog: http://informix-myview.blogspot.com/ Dis= claimer: Please keep >in mind that my own opinions are my own opinion= s and do not reflect >on my employer, Advanced DataTools, the IIUG, = nor any other >organization with which I am associated either explic= itly, >implicitly, or by inference. Neither do those opinions reflect= those >of other individuals affiliated with any entity with which I= am >affiliated nor those of the entities themselves. On Thu, Oct = 10, >2013 at 10:43 AM, FRANK <yunyaoqu@gmail.com> wrote: >= Folks, > > >IDS11.70 FC7, Linux Redhat 5 > > Any ide= a how to catch the session >who caused the error in online log file? = > > Thanks, > Frank > > >09:39:52 Maximum server = connections 348 > 09:39:52 Checkpoint >Statistics - Avg. Txn Bloc= k Time 0.005, # Txns blocked > 4, Plog >used 19337, Llog used 111= 149 > 09:44:35 SCHAPI: [mon=5Fusers 11-5321] >Error -1215 Value e= xceeds limit of > INTEGER precision > 09:44:54 >Checkpoint Co= mpleted: duration was 1 seconds. > 09:44:54 Wed Oct 9 - >loguniq = 115409, logpos 0x2cf571a0, timestamp: > 0xd6b2ce10 Interval: >274= 449 > > --047d7b6783aa121d9304e8640680 > > > > &= gt;******************************************************************* ** >********** > Forum Note: Use "Reply" to post a response in the = >discussion forum. > > --089e0160b8284d3bee04e8645728 >*= ******************************************************************** >= ;********** Forum Note: Use "Reply" to post a response in the >dis= cussion forum. =
Hi, It's: IC89509 SCHEDULER MIGHT LOG SCHAPI ERROR -1215 MESSAGES IN ONLINE LOG http://www.ibm.com/support/docview.wss?uid=swg1IC89509 Ben.