SMI on IDS7.3

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BF8F27.94AE6C7E Content-Type: text/plain; charset="WINDOWS-874" Hi : I got some problem when I alters big tables like add or drop a column from them and queries with SQL statements (Work with SMI ) such as: select today,t1.tabname,sum(iswrites+isdeletes),sum(isrewrites) from sysmaster@ol_nebula21:sysptprof t1,oltp@ol_nebula21:systables t2 where dbsname = "oltp" and t1.tabname=t2.tabname and tabid > 99 andtabtype = 'T' group by t1.tabname having sum(iswrites+isdeletes)>0 OR select dbsname, tabname, count(*) num_of_extents, sum( pe_size )total_size from systabnames, sysptnext where partnum = pe_partnum group by 1, 2 order by 3 desc, 4 desc; While I enter these statement the online.log indicate like this and after that the system is going down. 14:48:51 Checkpoint Completed: duration was 0 seconds. 14:49:07 Assert Failed: No Exception Handler 14:49:07 Informix Dynamic Server Version 7.31.UC5X2a 14:49:07 Who: Session(34, informix@nebula1, 27853, 872903496) Thread(117, sqlexec, 3405800c, 7) File: mtex.c Line: 446 14:49:07 Results: Exception Caught. Type: MT_EX_OS, Context: mem 14:49:07 Action: Please notify Informix Technical Support. 14:49:22 See Also: /DBA/af.45d91f2, shmem.45d91f2.0 But if I updata statistics on altered table and run the same SQL statement I don't got any problem but the system work fine! I don't know,Why ? - Could somebody explain what is happen ? - How can I skip this problem by don't run update statistics after I alters the table and I wondering If somebody can explain me about how the IDS works when we alter the table in deep concept. By the way I am using informix IDS 7.31 UC5x2a on SUN ( I'm sorry about my english becasue I am not native english.) Ake. ------_=_NextPart_001_01BF8F27.94AE6C7E Content-Type: text/html; charset="WINDOWS-874" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=WINDOWS-874"> <META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD> <BODY> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>Hi :</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000></SPAN></FONT>&nbsp;</FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>&nbsp;I got some problem when I alters big tables like add or drop a column&nbsp;from them and queries&nbsp;with SQL statements (Work with SMI ) such as:</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000></SPAN></FONT>&nbsp;</FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>select&nbsp; today,t1.tabname,sum(iswrites+isdeletes),sum(isrewrites)</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>from&nbsp;&nbsp;&nbsp; sysmaster@ol_nebula21:sysptprof t1,oltp@ol_nebula21:systables t2</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>where&nbsp;&nbsp; dbsname = "oltp" and t1.tabname=t2.tabname and tabid &gt; 99 and&nbsp; tabtype = 'T'</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>group by t1.tabname</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>having sum(iswrites+isdeletes)&gt;0</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5>&nbsp;</FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>OR</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000><BR>select&nbsp; dbsname, tabname,&nbsp; count(*) num_of_extents, sum( pe_size ) total_size</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>from systabnames, sysptnext</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>where partnum = pe_partnum</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>group by 1, 2</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>order by 3 desc, 4 desc;</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000></SPAN></FONT>&nbsp;</FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>While I enter these statement the online.log indicate like this and after that the system is going down.</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><SPAN class=517395008-16032000>&nbsp;</FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2>14:48:51 Checkpoint Completed: duration was 0 seconds. </FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2>14:49:07 Assert Failed: No Exception Handler </FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2>14:49:07 Informix Dynamic Server Version 7.31.UC5X2a </FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT size=2><FONT face=Arial>14:49:07 Who: Session(34, informix@nebula1, 27853, 872903496)&nbsp;</FONT></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2>Thread(117, sqlexec, 3405800c, 7) </FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2>File: mtex.c Line: 446 </FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2>14:49:07 Results: Exception Caught. Type: MT_EX_OS, Context: mem </FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2>14:49:07 Action: Please notify Informix Technical Support. </FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2>14:49:22 See Also: /DBA/af.45d91f2, shmem.45d91f2.0 </FONT></FONT></DIV> <DIV></SPAN><FONT SIZE=5>&nbsp;</FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>But if I updata statistics on altered table and run the same SQL statement I don't got any problem but the system work fine!</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>I don't know,Why ? </SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>- Could somebody explain what is happen ? </SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>- How can I skip this problem by don't run update statistics after I alters the table&nbsp; and I wondering If somebody can explain me about how the IDS works when we alter the table in deep concept.</SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000></SPAN></FONT>&nbsp;</FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>By the way I am using informix IDS 7.31 UC5x2a on SUN </SPAN></FONT></FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000></SPAN></FONT>&nbsp;</FONT></DIV> <DIV><FONT SIZE=5><FONT face=Arial size=2><SPAN class=517395008-16032000>( I'm sorry a

In article <8aqahu$cst$1@news.xmission.com>, Surachai Lerdboonchuaykul <SurachaL@tac.co.th> writes > >select dbsname, tabname, count(*) num_of_extents, sum( pe_size )>total_size >from systabnames, sysptnext >where partnum = pe_partnum >group by 1, 2 >order by 3 desc, 4 desc; > >While I enter these statement the online.log indicate like this and after >that the system is going down. > >14:48:51 Checkpoint Completed: duration was 0 seconds. >14:49:07 Assert Failed: No Exception Handler >14:49:07 Informix Dynamic Server Version 7.31.UC5X2a >14:49:07 Who: Session(34, informix@nebula1, 27853, 872903496) >Thread(117, sqlexec, 3405800c, 7) >File: mtex.c Line: 446 >14:49:07 Results: Exception Caught. Type: MT_EX_OS, Context: mem >14:49:07 Action: Please notify Informix Technical Support. >14:49:22 See Also: /DBA/af.45d91f2, shmem.45d91f2.0 > What does that /DBA/af.45d91f2 say? >By the way I am using informix IDS 7.31 UC5x2a on SUN > -- David Williams