Update Statistics help

Our update statistics process is that we run update statistics low for theentire database Monday through Thursday night, on Friday night we run update statistics high for the entire database. The update statistics high finishes some time on Sunday morning. We also have a nightly billing process (4GL program) that runs, and there has never been a conflict between the two processes until we recently pulled all the 4GL applications off the database server and put them on their own application server. The last 2 Friday evenings the billing program has crashed with a -750 error. The line the program crashes on is a select statement from 2 often read from tables in our database. The error message and line 79 of the 4GL code is below. Date: 03/22/2003 Time: 02:27:30 Program error at "program.4gl", line number 79. SQL statement error number -750. Invalid distribution format found for column2 select column1 into column1_var from table1, table2 Some facts about our system Database Server RS6000 F80 AIX 4.3.3 IDS 7.31.FD1 Is this an issue where I need to change the process we use for update statistics, or is it our 4GL program that needs to be changed? Thanks, Roy Verstegen Warehouse Specialists, Inc Informix DBA verroy@wsinc.com

We had similiar issues and changed when and how update statistics executed. > -----Original Message----- > From: Roy Verstegen [mailto:VERROY@wsinc.com] > Sent: Monday, March 24, 2003 8:32 AM > To: ids@iiug.org > Subject: Update Statistics help [785] > > > Our update statistics process is that we run update > statistics low for the > entire database Monday through Thursday night, on Friday > night we run update > statistics high for the entire database. The update > statistics high finishes > some time on Sunday morning. > > We also have a nightly billing process (4GL program) that > runs, and there > has never been a conflict between the two processes until we > recently pulled > all the 4GL applications off the database server and put them > on their own > application server. The last 2 Friday evenings the billing program has > crashed with a -750 error. The line the program crashes on is a select > statement from 2 often read from tables in our database. The > error message > and line 79 of the 4GL code is below. > > Date: 03/22/2003 Time: 02:27:30 > Program error at "program.4gl", line number 79. > SQL statement error number -750. > Invalid distribution format found for column2 > > select column1 into column1_var from table1, table2 > > Some facts about our system > > Database Server > RS6000 F80 > AIX 4.3.3 > IDS 7.31.FD1 > > Is this an issue where I need to change the process we use for update > statistics, or is it our 4GL program that needs to be changed? > > Thanks, > Roy Verstegen > Warehouse Specialists, Inc > Informix DBA > verroy@wsinc.com > > > > > > "CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel Retail. This email message and all attachments may contain legally privileged and confidential information intended solely for the use of the addressee. If you are not the intended recipient, you should immediately stop reading this message and delete it from the system. Any unauthorized reading, distribution, copying, or other use of this message or its attachments is strictly prohibited. All personal messages express solely the sender's views and not those of WHSmith USA Travel Retail. This message may not be copied or distributed without this disclaimer."

1. UPDATE STATS LOW DROP DISTRIBUTIONS might help. 2. Use Art Kagel's dostats program, you're not doing optimal update stats. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche >From: "Roy Verstegen " <VERROY@wsinc.com> >To: ids@iiug.org >Subject: Update Statistics help [785] Date: Mon, 24 Mar 2003 08:32:23 -0500 >(EST) > >Our update statistics process is that we run update statistics low for the >entire database Monday through Thursday night, on Friday night we run >update >statistics high for the entire database. The update statistics high >finishes >some time on Sunday morning. > >We also have a nightly billing process (4GL program) that runs, and there >has never been a conflict between the two processes until we recently >pulled >all the 4GL applications off the database server and put them on their own >application server. The last 2 Friday evenings the billing program has >crashed with a -750 error. The line the program crashes on is a select >statement from 2 often read from tables in our database. The error message >and line 79 of the 4GL code is below. > >Date: 03/22/2003 Time: 02:27:30 >Program error at "program.4gl", line number 79. >SQL statement error number -750. >Invalid distribution format found for column2 > >select column1 into column1_var from table1, table2 > >Some facts about our system > >Database Server >RS6000 F80 >AIX 4.3.3 >IDS 7.31.FD1 > >Is this an issue where I need to change the process we use for update >statistics, or is it our 4GL program that needs to be changed? > >Thanks, >Roy Verstegen >Warehouse Specialists, Inc >Informix DBA >verroy@wsinc.com > > > > > > _________________________________________________________________ Overloaded with spam? With MSN 8, you can filter it out http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=32&DI=1059

Where do I find Art Kagel's dostats program? - Jane -----Original Message----- From: Obnoxio The.... [mailto:obnoxio@hotmail.com] Sent: Monday, March 24, 2003 10:48 AM To: ids@iiug.org Subject: Re: Update Statistics help [787]=20 1. UPDATE STATS LOW DROP DISTRIBUTIONS might help. 2. Use Art Kagel's dostats program, you're not doing optimal update = stats. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien =E0 dire qu'il faut fermer sa gueule" - Coluche >From: "Roy Verstegen " <VERROY@wsinc.com> >To: ids@iiug.org >Subject: Update Statistics help [785] Date: Mon, 24 Mar 2003 08:32:23 = -0500 >(EST) > >Our update statistics process is that we run update statistics low for = the >entire database Monday through Thursday night, on Friday night we run=20 >update >statistics high for the entire database. The update statistics high=20 >finishes >some time on Sunday morning. > >We also have a nightly billing process (4GL program) that runs, and = there >has never been a conflict between the two processes until we recently=20 >pulled >all the 4GL applications off the database server and put them on their = own >application server. The last 2 Friday evenings the billing program has >crashed with a -750 error. The line the program crashes on is a select >statement from 2 often read from tables in our database. The error = message >and line 79 of the 4GL code is below. > >Date: 03/22/2003 Time: 02:27:30 >Program error at "program.4gl", line number 79. >SQL statement error number -750. >Invalid distribution format found for column2 > >select column1 into column1_var from table1, table2 > >Some facts about our system > >Database Server >RS6000 F80 >AIX 4.3.3 >IDS 7.31.FD1 > >Is this an issue where I need to change the process we use for update >statistics, or is it our 4GL program that needs to be changed? > >Thanks, >Roy Verstegen >Warehouse Specialists, Inc >Informix DBA >verroy@wsinc.com > > > > > > _________________________________________________________________ Overloaded with spam? With MSN 8, you can filter it out=20 http://join.msn.com/?page=3Dfeatures/junkmail&pgmarket=3Den-gb&XAPID=3D3= 2&DI=3D1059

http://www.iiug.org, in the software section in the bundle utils2_ak. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche >From: "Jane Vohden " <jvohden@co.fairbanks.ak.us> >To: ids@iiug.org >Subject: RE: Update Statistics help [788] Date: Mon, 24 Mar 2003 >17:37:00 -0500 (EST) > >Where do I find Art Kagel's dostats program? - Jane > >-----Original Message----- >From: Obnoxio The.... [mailto:obnoxio@hotmail.com] >Sent: Monday, March 24, 2003 10:48 AM >To: ids@iiug.org >Subject: Re: Update Statistics help [787]=20 > > >1. UPDATE STATS LOW DROP DISTRIBUTIONS might help. > >2. Use Art Kagel's dostats program, you're not doing optimal update = >stats. > >-- >Bye now, >Obnoxio > >"C'est pas parce qu'on n'a rien =E0 dire qu'il faut fermer sa gueule" > - Coluche > > > > > >From: "Roy Verstegen " <VERROY@wsinc.com> > >To: ids@iiug.org > >Subject: Update Statistics help [785] Date: Mon, 24 Mar 2003 08:32:23 = >-0500 > > >(EST) > > > >Our update statistics process is that we run update statistics low for = >the > >entire database Monday through Thursday night, on Friday night we run=20 > >update > >statistics high for the entire database. The update statistics high=20 > >finishes > >some time on Sunday morning. > > > >We also have a nightly billing process (4GL program) that runs, and = >there > >has never been a conflict between the two processes until we recently=20 > >pulled > >all the 4GL applications off the database server and put them on their = >own > >application server. The last 2 Friday evenings the billing program has > >crashed with a -750 error. The line the program crashes on is a select > >statement from 2 often read from tables in our database. The error = >message > >and line 79 of the 4GL code is below. > > > >Date: 03/22/2003 Time: 02:27:30 > >Program error at "program.4gl", line number 79. > >SQL statement error number -750. > >Invalid distribution format found for column2 > > > >select column1 into column1_var from table1, table2 > > > >Some facts about our system > > > >Database Server > >RS6000 F80 > >AIX 4.3.3 > >IDS 7.31.FD1 > > > >Is this an issue where I need to change the process we use for update > >statistics, or is it our 4GL program that needs to be changed? > > > >Thanks, > >Roy Verstegen > >Warehouse Specialists, Inc > >Informix DBA > >verroy@wsinc.com > > > > > > > > > > > > > > >_________________________________________________________________ >Overloaded with spam? With MSN 8, you can filter it out=20 >http://join.msn.com/?page=3Dfeatures/junkmail&pgmarket=3Den-gb&XAPID=3D3= >2&DI=3D1059 > > > _________________________________________________________________ Use MSN Messenger to send music and pics to your friends http://messenger.msn.co.uk