Oninit® Archive
Results for “STATCHANGE”
Upgrade 11.50 to 12.10
We have two large database engines running on Solaris 11.1 with a large amount of Enterprise Replication between them. In the near future I will be doing an upgrade from 11.50.FC9W2 up to 12.10.FC10 I understand it is an in-place update, 64 bit to 64 bit. We use Net-App SSD disks…
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
Need advice on compiling dostats utility
Hi Arts, I ran dostats on prod (dostats 2 -h ${INFORMIXSERVER} -m -v 2 -e -d ALL -Q 20 –p -P 0 -w 60), got some warning message as below: Warning: update statistics low using sampling may generate inaccurate index statistics for index xxxxxx due to data skew Can I safely ignore…
Serial and pseudo-rowid values going negative
Jacob: I know that this does not fix a problem with 3rd party applications that use ROWID specifically, but for customer developed software and for ad-hoc queries, there is the pseudo-column ifx_row_id which exists for all tables, even partitioned tables, without adding any hidde…
Update to utils2_ak
Forgot an example: $ myschema -d art -t extents --enable-boost /tmp/f $ cat /tmp/f CREATE LARGE TABLE "art".extents ( dbsname "informix".lvarchar(10000), tabname "informix".lvarchar(10000), chunk INTEGER, offset INTEGER, size BIGINT, truth "informix".boolean DEFAULT 't', id BIGSE…
Query using temp table is much faster then join/subquery
Thanks for suggestion. I tried various settings , in sql: SET ENVIRONMENT OPTCOMPIND '0/1/2'; SET OPTIMIZATION HIGH/LOW; (total 7) I tried with : onmode -wf OPTCOMPIND=0 I run with different settings for "update statistics high/medium/low " I always get same time (50s+-3s) Execut…
Automated Update Statistics and FORCE
Mark: You are not missing anything. This is the reason why I recommend to my clients that they disable AUS altogether, set AUTO_STAT and STATCHANGE (as well as the statchange levels for highly active and highly static tables appropriately) and run dostats without --force-run (aka…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
SQL query cost is very high
Hi Indika, There is a big difference between rows estimated and rows produced. Possibly your statistics are not up to date. You may like to run update statistics on tables involved in SQL and try. Regards, Nandkishor Singare -------------------------------…
index on timestamp & optimizer strategy failure
Hello Henri, I did not test against other statistics - that's a productive engine. And - thanks to directives - I can handle most of the cases where the optimizer fails. I'm seeking for a general best practice. Ithink it's a general problem that big tables having an indexed times…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
LAST ACCESS control
I am not clear about what you're trying to achieve here. You suggest using: select max(ustlowts) from systables The above shows the last time UPDATE STATISTICS (LOW) ran for a table, not sure that is what you want. I guess this could sort of work if you have AUTO_STAT_MODE 1 an…
CDR Sync for ER
Nevermind! I made a bad assumption: that statistics were updated on the Source side. I can see Art sorrowfully shaking his head. :-) Thanks, Michael…
-272 No SELECT permission for sysdistrib.ninserts
Hello Informix Fans, We've encountered the above error on 12.10.FC11X1. SCHAPI: [Auto Update Statistics Evaluation 55-4] Error -272 No SELECT permission for sysdistrib.ninserts. It seems to be a known issue that's supposed to be fixed in 11.70.xC8. IC92183: CONVERSION ADDING …
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
BUFFERPOOL
Thanks Mike for your valuable answer, and yes im running UPDATE STATISTICS HIGH on table with indexed columns…
UPDATE STATISTICS
Dear friends, As our application be running slow since DB migration is done. Informix version: 12.10 FC8 Application developed in Java and server running under JBOSS. OS: windows 2012 R2. I have done DB migration from old server to new server which is of same hardware and softw…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Cannot read from sysprocplan
I'm going to run the update statistics and set up a job to do that weekly. Hopefully that is the issue, but I can't find out why it is. Still looking.…
Misconceptions about Update Statistics
Well, kind of yes: Experience with Auto Update Statistics (AUS) https://informixdba.wordpress.com/2015/04/30/experience-with-auto-update-statist ics-aus/ The article doesn't just discuss AUS, much of what is in it is relevant no matter what method you use as they are all fundam…
"output to" question
Hi John. UNLOAD TO '/opt/gim2usr/scripts/nbupstat1.sql' DELIMITER ';' SELECT 'UPDATE STATISTICS MEDIUM FOR TABLE '||TRIM(tabname) FROM systables WHERE ... Regards, Doug…
Is it just me...?
Have you tried UPDATE STATISTICS ... ?…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Update Statistics
Hi, we took a database from Prod to a test server, and after a week, the following job is taking almost a day to complete. Can you give me a few ideas as to where to start looking for the possible culprit? update statistics low; update statistics medium; update statistics for pr…
UPDATE STATISTICS low in parallel?
Hi, Thanks to help from Jacques I got this working in a test system. Performance is excellent compared with single threaded performance. I can confirm that it appears to need in addition to what is in the manual, i.e. fragmented indices: - AUTO_STAT_MODE must be 1. - STATCHANG…
RE: Rebuild Distributions After an Upgrade - B....
Please vote on an RFE that requested the engine should do the automatic upgrade os the statistics... It makes little sense to force such a huge burden on an upgrade... I admit we may need to change the way we store the distributions, but how many times did it happen? And what was…
SQL return high query cost on ids 12.10
Hi, Yes, i already run update statistics high for this table. Thank You…
AUS - Update Statistics
Thank you for your help. That is what I was thinking. I will take a look at the link. Larry ________________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Stuart Brooks <stuart.brooks@ardenta.com> Sent: Thursday, May 12, 2016 7:46 AM To:…
update statistics
hi, for the leading column, i want to do the update statistics high, I have two method to run it. method one: update statistics high for <table name>(col1,col2); method two update statistics high for <table name>(col1); update statistics high for <table name>(col2); Do met…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Performance issue
Hi, Do you have statistics updated?…
Informix use the wrong index
ok, I will launch update statistics high for the 2 tables…
Performance issue after migrate to IDS from Online
Questions: 1. After the database was recreated and loaded did you run the recommended suite of Update Statistics commands as described in the Performance Guide manual (or as implemented by my dostats utility) or are you depending on Auto Update Statistics (AUS)? 2. So, you m…
Suggestions on AUS monitoring
Hi All, I was referring Bens blog on monitoring AUS: https://informixdba.wordpress.com/2015/04/30/experience-with-auto-update-statist ics-aus/ I am trying to gather details on AUS monitoring; apart from below points what else I have to consider for AUS monitoring: 1) The param…
Enable or Apply Auto Update Statistics
Hi All, Here is email communication between Ben and myself. I hope this will help someone who really want to play with AUS feature. -------------------------------------------------------------------------------- ---------------------------------------------------------- Hi Ben…
Update statistics
Hi All, Getting below error: update statistics low using sampling may generate inaccurate index statistics for index 'some column' due to data skew Thanks…
Creation of missing AUS related tables in sysadmin
Hi Pravin, I have blogged on this subject twice:: https://informixdba.wordpress.com/2013/05/31/working-with-auto-update-stats/ https://informixdba.wordpress.com/2015/04/30/experience-with-auto-update-statist ics-aus/ These provide some additional information to the manual on t…
Update statistics - which tables?
Ray: What about using dostats? Anyway, assuming you are using 11.50 or later, try this: select tabname from systables st, sysdistrib sd where st.tabid = sd.tabid and (sd.constructed + 7 units day) < current -- Obviously the '7' days aging is your choice union select tabname fr…
widows batch file for informix Update statistcs
Hello, does any one has windows batch file(script) to run update statistics and need to run it with schedule task. Thanks…
Update statistics for a table named "auto"
Hello, i have a slight problem with the update statistics (in ids 12.10.FC4_UE). We have a table named "auto" (which means "car" in french). I try to run the following queries but i get "-201 A syntax error has occurred": UPDATE STATISTICS FOR TABLE auto DROP DISTRIBUTIONS ; …
Re: Auto Update Statistics Evaluation Error
Hi Sascha. We are also getting this error. Have raised PMR 37045,019,866 with IBM. Will keep you informed on this forum thread. Regards, Doug Lawry…
aus_work_info
HI, Folks, 11.50 FC8, log has , 01:00:00 SCHAPI: [Auto Update Statistics Evaluation 68-7] Error -206 The specified table (aus_work_info) is not in the database. 01:00:00 SCHAPI: [Auto Update Statistics Evaluation 68-7] Error -111 ISAM error: no record found. Opinions ? Thanks…
query sqlexplain interpretation
I'm very sorry to bring the bad news, but AUTO_STAT_MODE does NOT activate automatic statistics gathering.... It activates SELECTIVE statistics gathering which is totally different. It means that whenever and however you run update statistics, the engine may decide to ignore you …
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Auto Update Statistics
Informix 11.50.FC8 - solaris environment After reading the documentation, it appears that AUS is scheduled to run over the weekend, by default, and all "UPDATE STATISTICS" commands that do not have time to execute are saved. My question is, "How configurable is AUS?". I would l…
Update statistics issue
tk_id 18 tk_name Auto Update Statistics Evaluation tk_enable f tk_next_execution 2014-06-28 00:30:28 tk_id 19 tk_name Auto Update Statistics Refresh tk_enable f tk_next_execution 2014-06-28 00:29:31 I have disable both jobs and will continue to run manually statistics but pleas…
Auto Update Statistics Evaluation Error
Hello, IBM Informix Dynamic Server Version 12.10.FC3 OS: SLES11 SP2 (x86_64) after succesfully inplace migration from 11.70.UC7W3(32-Bit) to 11.70.FC7W3(64-Bit) and then directly to 12.10.FC3 we see every night following error message in the online.log: 01:00:26 SCHAPI: [Auto …
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Auto Update Statistics Evaluation 39-87
Folks, IDS11.50 FC8, Redhat Linux 5/6 Just did a ontape level 0 backup in Redhat Linux 5, and then did a "ontape -r" full restore in Redhat Linux 6. It seems all is fine, except a error ( see attachment for more), 00:20:24 SCHAPI: [Auto Update Statistics Evaluation 39-87] Err…
aus_work_info
Original post: Folks, IDS11.50 FC8, Redhat Linux. A couple of days ago, we reverted IDS from 11.70 FC7 back to 11.50 FC8. Today we did a inplace upgrade of OS of Linux from Redhat Linux 5 to 6. When I started database, the error shows, SCHAPI: [Auto Update Statistics Evaluat…
Sysdistrib behavior: 11.50 versus 11.70
Thanks Art .... I appreciate it. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Monday, November 11, 2013 1:41 PM To: ids@iiug.org Subject: Re: Sysdistrib behavior: 11.50 versus 11.70 [31923] In v11.70 and later,…
IIUG website ...
... has seemed quite sluggish for a month or two. (Has it been ported to DB2? ;-)) Maybe we need to run UPDATE STATISTICS ...?…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
Update Statistics Problem
Hi, We have a installation in a client that have many databases, these databases have the origin in a Informix SE, v 2.10 ¿?, more than 20 years ago, we have migrated S.O. and Informix several times in this time... From SE we migrate to Online 9.40.UCx with dbexport/dbimport, th…
sysdistrib question
Those were the levels for the table at the time stats were last updated. They are compared to the values in sysptnhdr/sysactptnhdr to determine if stats need to be run. BTW, you do not need to use those numbers yourself, UPDATE STATISTICS does that for you automatically (unless …
Auto Update Stats
Hi, I want to implement AUS in informix 11.70.UC7X3. Here I have the below configuration set in mon_table_profile: sysadmin> select tk_id,tk_name,tk_result_table,tk_start_time,tk_stop_time,tk_frequency,tk_next_ex ecution,tk_total_executions,tk_total_time,tk_enable,tk_attributes …
tk_start_time column of ph_task not updated
Hi Team, I am running the below query to update the 'tk_start_time' column of ph_task in sysadmin. update ph_task set tk_start_time = TO_DATE("2013-06-28 00:30:00", "%Y-%m-%d %H:%M:%S") where tk_name='Auto Update Statistics Refresh'; After that when queried the ph_task as belo…
Auto Update Stats
To follow-up on my own post, Anil has asked me by email what the relationship is between STATCHANGE in the onconfig file and the AUS_CHANGE parameter of auto update stats. I don't think the Informix manuals make this very clear. My understanding is - and I'd appreciate it if som…
IDS 12.10 - dbimport very slow
Hi Markus, Is your import logged ? Regards, Henri MOUKOURI Le 25 juin 2013 à 10:45, "MARKUS BRINKBäUMER" <markus.brinkbaeumer@gmail.com> a écrit : > Hello, > > we have a new server (Windows 2012, 8 GB RAM, 4 x 600 GB SAS 15k HDD). On the > server we have installed an IBM Inf…
Finding the Bad Queries
Thank you Alexandre. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Alexandre Marini > Sent: Tuesday, 05 March 2013 01:41 PM > To: ids@iiug.org > Subject: RE: Finding the Bad Queries [29688] > > Hello. > In Informix, you al…
Performance Tuning Discussion
Ok it seems you have a big hardware, what´s your Informix version? What´s your box architecture? For performance tips, there is a good article in Andrew Ford´s blog, that should clarify your thoughts.... http://www.informix-dba.com/p/informix-innovator-c-tuning-basics.html This…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
update statistics comparison
Hello, Honestly, although doing update statistics for years :-) , still not in 100% clear on some results comparisons ( the optimizer likes one better than other ....) OK. What are the major possible differences of the following two sets of update statistics jobs for a table? H…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
onstat errors
Hi Art We are old dostats fans. Last version we compiled is: dostats: Features Version 6.00, Source Revision: 1.172 ! Copyright 1996-2009 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploita…
Error by Auto Update Statistics
Hallo, IBM Informix Dynamic Server Version 11.70.UC5X4 Linux 2.6.32.59-0.3-default #1 SMP 2012-04-27 11:14:44 +0200 x86_64 x86_64 x86_64 GNU/Linux I see every night this error in the online.log: 01:00:04 SCHAPI: [Auto Update Statistics Evaluation 32-41] Error -1265 Overflow o…
UPDATE STATISTICS may use indexes?
I'm chatting with a customer DBA about UPDATE STATISTICS HIGH and he's reporting some seemingly counterintuitive performance results... On a table having three columns (say A, B and C), he is reporting: UPDATE STATISTICS HIGH FOR TABLE tbl(A); UPDATE STATISTICS HIGH FOR TAB…
update statistics
Hi, Folks, IDS11.50 FC8 Assume a database has 100 tables: tab1,tab2,....tab100. What are the Major differences between the following two approaches for updating statistics? Approach 1: Just run a "update statistic" for whole database, update statistics; Approach 2: Run upda…
error in alter fragment
Also looks like the ~17 million page limit per dbspace was reached?.. Have many rows been deleted in the dbspace's tables?.. If so, and possible, would unloading all rows, delete/re-create tables, load rows back in, re-create indexes and update statistics reduce number of pages p…
Online.log error
Hello all, Can anyone shed any light on the following error..... Thanks in Advance.... HP-UX sleepy B.11.11 U 9000/800 2262126760 unlimited-user license IBM Informix Dynamic Server Version 11.50.FC3 -- On-Line -- Up 4 days 14:30:46 -- 6999772 Kbytes 01:09:40 SCHAPI: Err…
Oncheck interpretation problems
Could option 3 be: unload the table, drop it, re-create, load back in, create indexes and update its statistics?.. This would free up the pages used by the deleted rows, plus optimize the index files.…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
Stupid question
If Art, the data is already loaded, also constraints, stored procedures, etc.. He is now at the stage of updating statistics.…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Re: IDS shutting down by itself
Turn off the scheduler altogether? j. On Aug 22, 2011, at 3:00 PM, Bill Hamilton wrote: > This question relates to a Windows 2008 server running IDS 11.70.TC1IE . > > I keep getting this message every Monday morning (and other days sometimes) at about the same time in the IDS l…
IDS shutting down by itself
This question relates to a Windows 2008 server running IDS 11.70.TC1IE . I keep getting this message every Monday morning (and other days sometimes) at about the same time in the IDS log: “ 04:33:07 Service was shut-down externally. “ And then someone from that company has to …
why phantom pdq message in wee hours?
On Aug 15, 1:45 pm, "Bill Hamilton" <garage_...@hotmail.com> wrote: > This involves running IDS 11.70.TC1IE on Windows 2008 Server os. > I see this each morning at the same time in the ids log file: > > 01:11:01 Warning: PDQ functionality is not supported in IDS Innovator-C > Ed…
Re: Automatic Update Statistics
Hello, This topic was already discussed on IIUG forum, look for the old posts, and you´ll find the solution, ok? Best regards. Em 09/08/2011 05:04, Fernandez Garcia, Domingo escreveu: > Error -1284 -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hot…
Automatic Update Statistics
Good morning, We have installed IDS 11.70.FC1GE on Red Hat Enterprise Linux Server release 5.7 (Tikanga). Every day we see the next message in online.log: 01:00:17 SCHAPI: [Auto Update Statistics Evaluation 29-xx] Error -1284 Value will not fit in a BIGINT or an INT8. We don't …
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
how often update stats should be run
Hi, we are running IDS 11.5 FC7 on AIX 6.1 How often update statistics should be run against database & in which mode (high, medium, low, distribution only) We have schedule it via OATS tool. Below are the parameters selected for evaluator (Auto Update Statistics Evaluation) AU…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
update statistics generated automatically?
But that was my question: the 'update statistics' command is NOT programmed in the application, it must be generated somewhere automatically but I don't know where!!…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Performance issue
Hi, I tried your query and it has a bit improve, but still not normal speed. I will update statistic for the whole database with your advise, then run the query again. I will date. Thank you all for your advices. update statistics low drop distributions; .... .... update statis…
Update statistics low
Hi, I have a database on which we run update statistics daily thru a cron. The size of the database is 64GB and it contains around 342 tables.Update statistics HIGH takes only 5 mins while update statistics LOW takes almost 7 hours to complete. I have other databases in the same…
Performance difference between IN and OR ?
Art Kagel WROTE: ------------------------------------------------------------------------------- The big difference between actual and estimated rows (268 actual versus 28075460 estimated) is likely the problem. It indicates that your data distributions are not up-to-date. Art -…
Re: SCHAPI: [22938]
Hello. If you check the $INFORMIXDIR/etc/sysadmin/*.sql files (run to build sysadmin database on your engine), you´ll see that some indexes are created using online mode. You may just remove the ONLINE word from the statements, and rebuild your sysadmin database, as follows... (…
SCHAPI: [Auto Update Statistics Evaluation 18-6]
Hi All I am currently busy with an upgrade from informix 10.00 FC8 to informix 11.5 Growth Edition. However when we look at the logs for previous test machines that we have upgraded. The following errors always come up: ####### 01:00:01 SCHAPI: [Auto Update Statistics Evaluati…
Set tables activity
Hello anybody Other question. Update statistics modified that table? Thank Servio Velasco…
AUS issue - SQL error 1284
Hello, my friends. I am facing some strange issue here, on a 11.70.FC1GE running on linux_64 machine. My online.log says: SCHAPI: [Auto Update Statistics Evaluation 29-15] Error -1284 Value will not fit in a BIGINT or an INT8. My OAT Alerts page says something additional: TASK …
Scheduler Error
IDS 11.50.FC5 I have just noticed that none of my scheduled tasks seem to have executed since 11-29-10, when about half of the AUS statements executed. I have the following entry in my informix log: 20:34:05 SCHAPI: thread dbWorker1 task post_alarm_message(15-160390) shutting d…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
update statistics
How can i know which tables needs update statistics , Is there any query in sysmaster which can provide this information ?…
SQL slowdown. Index rebuild?
Sorry, forgot to mention that update statistics drop distributions was done and a re-creation of the statistics LOW and MEDIUM for the tables and HIGH for the indexes.…
Databases not showing up in AUS
I recently upgrade a Windows 2003 64bit IDS 11.50 FC5 system to 11.50 FC7. After the upgrade which went without incident we no longer see all the databases in the Auto Update Statistics. We thought it was OAT so upgrade that to 2.28 from 2.26 no change. We are only seeing the sys…
dostats - IDS 11.50
Yes, IDS 11.50 supports the dostats utility. In fact, we have shut off the AUS and opted to use our own scripts that update statistics using Art's dostats. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ANDREW CLARK Sent: Wednesd…
Update Statistics
If the AUS evaluator is run and says x number of tables need stats updated, then AUS runs and no-one touches the database, shouldn't the number that the evaluator says are needed decrease? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computi…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Alert in OAT
I have seen this show up every day after the update statistics refresh task runs. TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The specified table (aus_work_dist) is not in the database. ERROR -111 ISAM error: no record found. We don't have that table in our dat…
RE: SCHAPI error
Sysadmin DB was rebuilt. Error appears again, anyway: 08:56:08 Building 'sysadmin' database ... 08:56:31 'sysadmin' database built successfully. 08:56:31 SCHAPI: Started dbScheduler thread. 08:56:31 SCHAPI: Started 2 dbWorker threads. 08:56:31 Checkpoint Completed: d…
Re: SCHAPI error
Did you recently upgrade this server from an earlier 11.xx version? If so, you may have to drop sysadmin and rebuild it. Improperly rebuilt sysadmin databases after an upgrade were a problem in all but the most recent release of 11.50. You can find instructions for doing this …
SCHAPI error
Hi, each night there appears an message in the message log: ERROR -1266 Intervals or datetimes are incompatible Found this with select * from ph_alerts in sysadmin database: alert_id 1511 run_id 7786 task_id 16 task_name Auto U…
OAT and Auto Update Statistics
I am having a problem in OAT- when I click on Auto Update Statistics, it responds with: Error: -258 [Informix][Informix ODBC Driver][Informix]System error - invalid statement id received by the sqlexec process. (SQLExecute[-258] at ext\\\\pdo_informix\\\\informix_statement.c:755)…
Auto Update Statistics
Hi there, I'm currently evaluating upgrade procedure from version 10 to 11.50. First tests do not reveal any problems. So far so good. But: I upgraded a really large instance (~500 GB with ~600 databases with an overall more than 500000 database objects). I also have the latest …
messages at online.log
Hello We have Informix IDS 11.50FC5 on Solaris 10 Spark. I can see this messages at the online.log file but I can't realize how bad can it be that situation. Could anybody tell me some tips about what should I check on our system? Thanks in advance --Nestor 01:00:01 SCHAPI: …
Update Statistics
I've seen the recommendation to do update statistics on ids on this list over the last couple months in certain situations. Sadly I know little about administering IDS but I've muddle through so far. I was wondering if someone could do a quick tutorial about update statistics cov…
Update statistics after the upgrade
All, in a recent post on IIUG forum (http://www.iiug.org/forums/ids/ index.cgi/read/18706) Art and others explained why it's important to run update statistics after a major upgrade. I'd now like to ask how, or more precise, what is the most efficient way to do it in a 24/7 envi…
SDS & update statistics performance
Hi My situation: 1. I use MACH11 with IDS 11.50FC5W2 on Sun Solaris On Secondary server UPDATABLE_SECONDARY 0. 2. On SDS server assert and server stop: 15:56:34 Rollforward of log record failed. iserrno = 126 15:56:34 Log Record: log = 4807652, pos = 0x105558, type = OLDR…
running out of rootdbs space
One more things,online.log's messages list : 02:29:35 SCHAPI: Error -640 QPlan sanity failure (3778.105). 02:29:35 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh, Location: NULL. 02:29:35 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh, Error Message: Unabl…
views and update statistics
hi all how can one see the last time statistics were update for a view? or does it just relate back to when the tables within the view were last updated? thanks much -…
why update statistics after IDS upgrade ?
From the IDS11.5 Migration Guide pages 5-6 and 5-7 ............................. Completing Required Post-Migration Tasks ... 2. Optionally run UPDATE STATISTICS on your tables (not system catalog tables) and on UDRs that perform queries, if you have performance problems after mi…
IDS V11.50FC5: AUS error.
IDS 11.50FC5 for hp-ux 9000 the online.log information out every day 01:00 . the function aus_evaluator exist in database sysadmin . this page had mention the question, but did't give how to check the error, anyone can help? thank you! http://www.cniug.org/uploadfiles/IBM/2009…
Auto Update Statistics Evalution
Hi, I'm running 11.50.FC5 and I am getting the following messages in my online log when the "Auto Update Statistics Evalution" is running: 12/20/09 01:00:05 SCHAPI: Error -242 Could not open database table (informix.aus_work_info). 12/20/09 01:00:05 SCHAPI: Type: TASK, Name: Aut…
Doubt in Update statistics, resolution and confide
oopps... sorry.. I not read with attention the message ... after the Art answer I see.. the problem isn't in the execution of update statistics ... the issues is in the query *after* update statistics... my bad.. About the original question, I don't dare to answer, for this pro…
How to disable auto update statistics
Hello, I don't want to use this feature before I make sure IDS11.5 is stable, How to disable it? thanks for your help.…
OAT and AUS (Auto Update Statistics)
Is there a way within OAT to state a default RESOLUTION and confidence factor within AUS? Art, You mentioned there was a difference between UPDATE STATISTICS commands AUS generates vs. what the the seeding script (located at http://www-01.ibm.com/support/docview.wss?uid=swg211…
AUS - Auto Update Statistics how to
Hi Everyone, having fun trying to use Auto Update Statistics. After a call to IBM I registered the correct datablade in sysadmin database so at least it's working and we don't need UC6. I then read the manual on how to use AUD in the online documentation. : ) It doesn't seem to…
Auto Update Statstics
IDS 11.5 FC5 Linux (suse 10.2) I get the following errors when I try to run auto update stats... any ideas? (I have already restarted the instance.) 09:21:52 SCHAPI: Error -214 Cannot remove file for table (informix.aus_command). 09:21:52 SCHAPI: Type: TASK, Name: Auto Update S…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Sysadmin Database Errors
I was not at this particular client when they upgraded to 11.0 (now at 11.5.FC5, AIX 5.3); however, these errors continuously show up in their online.log: 01:00:00 SCHAPI: Error -214 Cannot remove file for table (informix.aus_command). 01:00:00 SCHAPI: Error -710 Table (informix…
update statistics
Hi, we renamed a column which have no index and its not referenced, Is there need to run update statistics on this table? Regards, Khurram.…
dostats error on procedure nvl
Hi, we uses the dostats from Art. With the Informix IDS 11.50UC3 we got the following error on the procedure nvl. # dostats -h ph450_tli -d pro_schul -p -v2 Verbose mode level 2 ENABLED.... PDQPRIORITY for table processing set to: 0. Stored Procedure processing ENABLED.... Def…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Alter statistics to trick the optimizer?
IDS 10.00.fc8 OS AIX 5.x Situation: Statistics updated low every night. Table is empty at time statistics are run every night. I have no control over SQL or schedule of the application tasks. Mass load occurs on table at time of end users choice. Automated task begins on interv…
UPDATE STATISTICS Performace Improvement
Hello, How can I improve the execution performance of 'Update Statistics'?? In our OLTP system we want to avoid any sysprocplan issue and for that purpose we need to execute update statistics as speedily as possible. Regards, Anees Ahmad…
update stats on syscdr database
Should we be running update statistics on syscdr database ? Currently we dont…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
Re: Update Statistics
Colin Dawson wrote: > IDS 9.40.FC8X3 > Solaris 10 > SUN M5000 16*4 core CPU 128Gb Mem > > dostats version on this server:- Features Version 5.10, Source Revision: > 1.125 > > > > Sorry to raise this topic again. > > We have a table with 654,484,092 rows, fragmentation is round ro…
Re: Update Statistics
Hello Colin, The "dostats" is a very fine product that would be hard to beat. The only things the might help are "LIGHT_SCANS=FORCE", creating multiple temp Dbspaces on ramdrive (you can use PSORT_DBTEMP for this), use PSORT_NPROCS, DS_TOTAL_MEMORY 4000000, MAX_PDQPRIORITY 100,…
Update Statistics
IDS 9.40.FC8X3 Solaris 10 SUN M5000 16*4 core CPU 128Gb Mem dostats version on this server:- Features Version 5.10, Source Revision: 1.125 Sorry to raise this topic again. We have a table with 654,484,092 rows, fragmentation is round robin in 8 fragments. Indexes a…
about update statistics performance ?
Hi , I have somw questions about update statistics from AnswerOnline 11.5 as following : Here from IDS11.5 : Example of UPDATE STATISTICS HIGH statements for the first column in each index that differs: For example, suppose you have the following indexes on table t1: CREATE …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
querying during update statistics
Our DBA has shoved doing update statistics on our sales table to be while I am doing some heavy duty queries. The queries are taking much longer. Could update statistics be causing this? Thanks JPS…
Override automated update statistics
While I find the automated update statistics feature and great addition to 11.5 I have a specific need to control or override the update statistics commands that are generated by the evaluator for certain tables. I've searched the documentation for customization paramaters that …
Automatic Update Statistics
I am using IDS 11.10.UC2 on Linux and would like to start using the AUS feature. Do you have to use OAT to use this feature? I can not find any documentation about this feature in the Information Center. If you know of any links or presentation please respond. Thanks Roy…
Error -23197 from scheduler
Using 11.50 X1, am seeing the following error in online log: ... 17:58:56 SCHAPI: Error -23197 Database locale information mismatch. 17:58:56 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. 17:58:56 SCHAPI: Type: TASK, Name: Auto Update Statistics…
stored procedure query vs dbaccess
ANTHONY JUDISH wrote: > > Yes OTC, we've run update statistics on the tables and sp. ;) Yes, but are you sure that the statistics you have are what you think they are? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Logical-logs filling fast on IDS 11.5FC1
Hello everybody. I decided to start a new subject ´cause I´ve found on my logical-log several informix transactions, and I need to know if the sql trace impacts on my logical-logs, or if a common error that´s on my online.log is impacting: ----------------------------------------…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
explain output for update statistics ?
Hi, following document shows an example of an explain output for an update statistics statement. http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/miller/0203miller.html I used following statement in dbaccess set explain on; update statistics for table …
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
update statistics
I want to demonstrate the potential effects of update statistics in a repeatable way but am having trouble doing so. This is for a customer using an elderly version of Informix SE. Here's what I did. 1) create table item (code integer, name char(30), type char(1), cost integ…
Re: Mysterious update statistics
Ahh, ok. The first (generating files) is what I did so far, the second (use of drive_dostats) is what I want to do in future. Sorry for the confusion. And thank you for your great assistance and patience. Reinhard. > -----Ursprüngliche Nachricht----- > Von: Art S. Kagel (Oninit…
Re: Mysterious update statistics
Habichtsberg, Reinhard wrote: > Hi Art. > > Thanks again for your answer. > > I'm afraid I don't grasp the following paragraph: > > >>> - I use -a -A 20 and -b -B 5 meaning tables are processed if the last run >>> > on > >>> the table is older than 20 days _or_ the number of row…
Re: Mysterious update statistics
Hi Art. Thanks again for your answer. I'm afraid I don't grasp the following paragraph: >> - I use -a -A 20 and -b -B 5 meaning tables are processed if the last run on >> the table is older than 20 days _or_ the number of rows has changed more >> than 5 percent. Is this true …
Re: Mysterious update statistics
Habichtsberg, Reinhard wrote: > Hi Art. > > First thank you for the detailed answer. I read the manuals and the paper of > John Miller now again but some questions remain. > > I use your dostats to generate UPDATE STATISTICS statements putting them in > a file which I run periodi…
Re: Mysterious update statistics
Hi Art. First thank you for the detailed answer. I read the manuals and the paper of John Miller now again but some questions remain. I use your dostats to generate UPDATE STATISTICS statements putting them in a file which I run periodically. I never used parallelism because th…
Re: Mysterious update statistics
Habichtsberg, Reinhard wrote: > Hi all. > Hi. First to answer your first direct question. No it doesn't make any difference. The UPDATE STATISTICS commands do not operate ONLY on the changes to the table but on the entire table (or a sample of the table if MEDIUM level stats …
Mysterious update statistics
Hi all. Once again a question to update statistics: Makes it a difference how many data had changed between two runnings e.g. UPDATE STATISTICS FOR TABLE xxx; In other words: Is update statistics aware of the difference or is it running on all data at all times? Would it make s…
[Q] update statistics for newbie???
We have Informix Dymanic server on DELL LINUX server and Informix version is 10UC4. Due to DBA out of town for couple weeks I need temporary take care the database. I have some questions relate to "update statistics" need help. we run "update statistics" batch job to update ar…
drop distributions
Habichtsberg, Reinhard wrote: > Hi. > > After upgrading from IDS 9.40.FC4W2 to 9.40.FC9W2 some queries run extremly > slow and I'm under the impression that the optimizer chooses the wrong way > especially when OPTCOMPIND is 1 or 2. > > My idea is to drop distributions. The probl…
update statistics at the same time
hi, everybody. can I run update statistics on different tables at the same time, then they will run Parallel, to save time. thanks…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Cannot drop stored proc after crash
you may update statistics for this procedure first, and then try again.…
Error in update stats
Version IDS 10: When I run update statistics I get error 255 on different tables at different times. Could it be because inside update statistics we are trying to commit something to sysdistrib database and it's just failing.…
generic question: update statistics low drop distr
Andreas.KUTSCHE@spar.at wrote: > Hi, > > why should anyone run > update statistics low drop distributions ? > (maybe except after database upgrades - and even there it is not > possible if the database has serveral terabytes) > Even on a large database you could run this table b…
Re: Kill Update Statistics
On 17 Oct, 16:31, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Oct 17, 8:05 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- > > emmendingen.de> wrote: > > Is there any way to kill a running update statistics. > > > UPDATE STATISTICS HIGH FOR TABLE foo (bar) DISTRIBUTIONS ONL…
Trouble with update statistics
We had/have some trouble with update statistics here. Because it's not so simple to describe in short I send the whole story: - IDS 9.40.FC4W2 - Solaris 5.9 Generic_117171-12 sun4u sparc SUNW,Netra-T12 - Table contains about 800,000,000 rows - Fragmented by expression 20 fragme…
Re: Kill Update Statistics
You cannot kill a running UPDATE STATISTICS statement. It will run to completion. I'm don't know why, I just know you can't. ----- Original Message ---- From: "Habichtsberg, Reinhard" <RHabichtsberg@arz-emmendingen.de> To: Informix-List (E-Mail) <informix-list@iiug.org>; Martin …
RE: Kill Update Statistics
Sure, I tried with onmode <sesid> (not with onstat -z, was a typo) without any success. > -----Ursprüngliche Nachricht----- > Von: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]Im Auftrag von Martin Fuerderer > Gesendet am: Mittwoch, 17. Oktober 2007 15…
Re: Kill Update Statistics
Hi, I think it should be "onmode -z <sesid>" (as user informix). "onstat -z" only zeroes internal statistic values (like what is displayed by "onstat -p"), but it does not have an effect on running sessions. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, …
Kill Update Statistics
Is there any way to kill a running update statistics. UPDATE STATISTICS HIGH FOR TABLE foo (bar) DISTRIBUTIONS ONLY. I tried with with onstat -z several times but it runs and runs and seems to do nothing anyway. Sorry, I forgot: IBM Informix Dynamic Server Version 9.40.FC4W2, …
Kill Update Statistics
Is there any way to kill a running update statistics. UPDATE STATISTICS HIGH FOR TABLE foo (bar) DISTRIBUTIONS ONLY. I tried with with onstat -z several times but it runs and runs and seems to do nothing anyway. Regards Reinhard…
update statistics on sysutils
I am reading about various things that could make backing up logical logs faster using onbar. One of the things that IBM recommends is running update statistics on sysutils database. So my question is: 1. What columns should the update stats run against. 2. Are there any other w…
Update Statistics
Hello, during the execution of UPDATE STATISTICS to the tables of my BD, as it is the impact that produces the execution. Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Update Statistics - Cost of using a Function as an Index...
Hi, I executed some tests here with function as an index. 1) I created an index , using a function: create index ix_dt on tst1 (dt_periodo(hora)); 2) Ran update statistics on the column where the function was applied : update statistics low for table tst1(h…
Re: Is IBM actually doing something with IDS?
david@smooth1.co.uk wrote: > "You may also have found many optimizer/statistics improvements > developed considering DB2 > experiences." > > No, what were they again? Statistics collection on index creation comes readily to mind. Our LEO (Learning optimizer) experience is a wide…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
DoStats ignoring stored procedures?
Hello, is there a flag within dostats to not have it update statistics on the stored procedures or is the -x @stored_procedure/path the only method? Thank you, Sean…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Update Statistics Guidelines
Superboer wrote: >> Sometimes not even this has been enough as we have one frequently-used >> transient table that can contain anything from 0 to 50000 rows. If >> update statistics was last ran when there were 0 rows the engine favours >> sequential scans which are very ineffici…
Re: Update Statistics Guidelines
Run Arts DoStats Paul Watson Tel: +44 1414161772 +1 913-400-2620 Mob: +44 7818003457 +1 913-636-2858 Web: www.oninit.com Failure is not as frightening as regret. Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more info…
Re: update statistics
informix-list-bounces@iiug.org wrote on 03/05/2007 12:47:55 AM: > The IBM web page at ... > ... says to update statistics thusly: > > 1. Run UPDATE STATISTICS LOW on all tables in the database. > > 2. Run UPDATE STATISTICS MEDIUM on all columns which are in an > index, but are n…
update statistics
The IBM web page at http://www-1.ibm.com/support/docview.wss?rs=0&context=SSGU5D&context=SSHMMC&context=SSGU8G&context=SSGKNY&context=SSGU5Y&context=SSCRW7&context=SSGHZP&context=SSVT2J&q1=update+statistics&uid=swg21137764&loc=en_GB&cs=utf-8&lang= says to update statistics thusl…
Slow onsmsync
It works about 1 hour. I tried update statistics on sysutils database, but it didnt help. What next? Informix version 9.4 on AIX.…
Bug in V10 FC5??
Hello Richard, Did you run any update statistics after upgrade to FC5? You may need to drop the data distributions after upgrade. -Sanjit…
Update statistics for large databases
Hi, how can I obtain a short time for my update statistics on a large databases. It's run on a machine with 8 processors, 32 Gb Ram, RHEL4 and IDS 10 FC4. My script for update statistics begins with update statistics medium on database and continue with update statistics low an…
Query Problem
Hi Got the solution for the problem We have to run Update statistics on all the tables involved in the query.…
problem with select count(distinct
Diego Morales wrote: > Update statistics??? As I said in my first post - I have tried that -- Clive…
The delete dosn't delete some records
Run 'update statistics high' and 'oncheck -cID' on that table. Also run 'oncheck -cc' to check the catalog. -Sanjit…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
update statistics
Hi, What are the best pratices to run update statistics? having: IBM p520 4 cpu's 16Gb AIX 5.3 IDS 9.40.FC8 tks Henrique Lima henrique_lima_2000@yahoo.com.br henriquelima@uol.com.br _______________________________________________________ Você quer respostas para suas pergunta…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Update statistics
Hi Gurus, When the system is running "update statistics", will it affect insert, update? We have some issue recently. We start to process business transaction at 6:00AM, when there is "update statistics" job running, some insert been rejected. The return code is "144","211". Any…
distribution only?
Hi teachers, I could not understand what is the meaning of "distribution only" in the update statistics statement. Kindly please teach me. Thanks a lot.…
Re: Impromptu and Progress Problem
Wrong database -- that I agree. But its not up to me to change, the management will have to approve and so on. How do I go about update statistics?…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: IDS 9.4 Slower then IDS 7.31
update statistics for procedure ?? Give this a try (just the first shot): $ onmode -C threshold 20000…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Re: IDS 9.4 Slower then IDS 7.31
Please run UPDATE STATISTICS LOW on your databases and report back if you still run into performance issues.…
update statistics
Hi, I have an error during executing the following command update statistics high for table tablename1 SQL Error(-567):Cannot write sorted rows ISAM error:no free disk space for sort Where it tries to find free disk space (tempdb or on the dbspace that the table resides)? The s…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
update statistics - distributions
Talk to IBM. Certainly update statistics with distributions will briefly take locks on system tables so you will need to set lock mode to wait 30 for applications and at the start of the update statistics script.…
DBDATE format issues
Make sure the session that creates the stored procedure or does update statistics on the stored procedure has the correct DBDATE setting.…
Update Statistics
This is some output from dostats TABLE(MEDIUM)...SUCCESSFUL (34.174 Secs) COL1(HIGH)...SUCCESSFUL (963.907 Secs) COL2(HIGH)...SUCCESSFUL (1061.096 Secs) COL3(HIGH)...SUCCESSFUL (1250.274 Secs) COL2, COL3(LOW)...SUCCESSFUL …
Update Statistics
This is some output from dostats TABLE(MEDIUM)...SUCCESSFUL (34.174 Secs) COL1(HIGH)...SUCCESSFUL (963.907 Secs) COL2(HIGH)...SUCCESSFUL (1061.096 Secs) COL3(HIGH)...SUCCESSFUL (1250.274 Secs) COL2, COL3(LOW)...SUCCESSFUL …
Re: Insider #65: Highlights: IIUG Board of 2006 elections, Informix
Have you tried UPDATE STATISTICS?…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Update Stats Question
hmm, firstly will that be possible? I guess the update statistics does a exclusive lock on some tables during updating the statistics, so I see it may not be a good idea. btw, what is the purpose behind doing this?…
Great Article on Oracle
"Data Goob" <datagoob@netscape.net> wrote in message news:MKKZe.1$n27.0@fe21.usenetserver.com... > http://www.businessweek.com/technology/content/sep2005/tc20050923_0725_tc024.htm Have you tried running UPDATE STATISTICS?…
Optimiser choice of index
1/ Bug in the optimiser 2/ The Update Statistics strategy you used did not obtain appropriate information to provide the optimser with enough detail to choose the right index…
update statistics
Hello, We recieved this message from a cron job over the weekend: 564: Cannot sort rows. 179: ISAM error: no free disk space for sort Error in line 50 Near character position 44 question - does Informix always go straight to disk (temp db spaces) for sorting? is it even a…
Statistics for temporary tables
Hi, When i update statistics from temporary tabels, where are they stored. Is there any systable like sysdistrib for normal tables which holds this statistics. Bye.…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: Re: No future for DB2
Jean Sagi wrote: > Quite interesting... I haven't used Oracle for years, but if > what you state is true, then it is wonderfull!. > > From a developer's view then the optimizer always choose > the best path and I figure it that _optimizer hints_ are > things of the past. I gues…
Re: IDS Next Version - features wanted.
How about 1 primary server to N secondary servers for HDR instead of just 1 primary to 1 secondary? Carlton Doe brought this up at IDUG 2005, would anyone else be interested in this feature? Andrew "Redden96" <Redden96@yahoo.com> wrote in message news:1119364729.758706.65940@g…
update statistics on system tables
IDS 9.4 on HPUX 11i Is it recommended to run update statistics on the system tables?…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
More Update Statistics
Ok. I think all but 2 of my questions relating to update statistics have been answered. If anyone knows the answers to the following 2 questions, I'd appreciate some feedback. 1. Do the update statistics performance enhancements appear in 9.30.XC2 or 9.30.XC3? I have 2 docum…
Update Statistics
For the following table on IDS versions 9.30xC2 and up create table t ( a integer, b integer, c integer, d integer, e integer ) create unique index idx1 on t (a, b); create index idx2 on t (b, c, d); create index idx3 on t (b, c, e); do update statistics low fo…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: FW: Update statistics performance
no, the dbexport would attempt to take an exclusive lock on the database. UPDATE STATISTICS would at least take a shared lock so whichever runs second will fail.…
Need help!! Sql to Informix Migration
did you run update statistics?…
update statistics
when update stats are run, is the table being locked? if so, is there a way to work around that? IDS ver 9.40_FC3 ----- HP-UX 11i Thanks, Tom…
update statistics
when update stats are run, is the table being locked? if so, is there a way to work around that? IDS ver 9.40_FC3 ----- HP-UX 11i Thanks, Tom…
Update statistics
Wayne, While yes, it does delete the distributions in the sys tables, it also performs an update statistics low on each table. Oddly enough, update statistics low (gathering basic table and column statistics, not distributions), can take longer than update statistics medium (sam…
Update statistics
Why would "update statistics drop distributions" take several hours.....? And it is still running.... I would have assumed that this would just basically be a delete in the sys tables. Am I wrong? Please do not transmit orders or instructions regarding a UBS account by email. Th…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Stupid Americans! -- Stupid... Stupid... STUPID!!! __________-+__ wemta
Madison Pruet wrote: > Try updating your statistics. That generally makes things run better. Way to go Madison, top post and quote the entire diatribe.…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: ODBC connection forces engine to hang
One thing to check and one thing to try: 1. make sure auto optimize is not turned on on the client side in your odbc config...if it is your database may be trying to update statistics in some cases due to it. I am not exactly sure what the name of this setting is at the moment, b…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
9.40 query optimiser problem
A client has IDS 9.40.FC1 on HP-UX with: OPTCOMPIND 0 # Nested loop joins preferred OPT_GOAL 0 # FIRST_ROWS UPDATE STATISTICS (no distributions) has been run. According to "sqexplain.out", queries involving several tables, with a fixed condition on one table for whic…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Is it good to run update statistics as follows for system tables ?
--0-1818311736-1085258509=:39755 Content-Type: text/plain; charset=us-ascii Hi all, I am dropping dustributions while updating statistics for sytem tables. Is this a good idea ? Examples : update statistics low for table sysaggregates drop distributions; update statistics lo…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Re: Query Permormance improvement: URGENT
>Nonsense. The order in which the optimiser decides >to do the processing is critical. I Agree, but as long as the optimizer give a plan wich has some _sense_ , which is certain almost all the the time... But in the cases when the optimizer plan is _nonsense_ (statistics et all…
RE: Whatcha' wanta have?????
Auto Update Statistics (i.e A set and forget option) To be done under some logical and meaningful circumstances - Change in number of rows by x% - Update of index columns by y% Optionally, this to be selectable so certain tables can be eliminated from the list of Auto Statis…
RE: Whatcha' wanta have?????
Auto Update Statistics (i.e A set and forget option) To be done under some logical and meaningful circumstances - Change in number of rows by x% - Update of index columns by y% Optionally, this to be selectable so certain tables can be eliminated from the list of Auto Statis…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: Auto Update Statistics
First of all - I've got to eat my words, sort of. My comment is accurate with respect to the server - there is no automatic system in the server for doing update statistics. However, in versions of ODBC prior to 3.82, the ODBC driver does automatic update statistics in response…
Auto Update Statistics
Hi, I had found some "USTB" events in the Informix auditing log for a newly purchased application use ODBC calls to access the database, but the vendor said that they didn't include "UPDATE STATISTICS" statments in their coding. Can anyone have idea on this case? Is there "auto …
UPDATE STATISTICS
Imagine a table tab1 with a bazillion rows and five columns. There is one index on the table, on column A. If I do: UPDATE STATISTICS LOW FOR TABLE tab1(col_a); ... it runs very quickly. But if I just do: UPDATE STATISTICS LOW FOR TABLE tab1; ... it takes hours, maybe days…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Update Statistics on a GK Index
Never proven anything around this idea, but I can't imagine that the update stats would be any different for a GK index than an index column for joins...the same rules should apply. I would think that the optimizer would still want to know as much about the index and columns incl…
Re: Update statistics low drop distributions
There is no record of when an update statistics low was executed at all. However, if the last update statistics was a low drop distributions there will be no records in the sysdistrib table for the tabid(s) concerned and no output for the table(s) from dbschema ... -hd. Art S. K…
Update statistics low drop distributions
Is there a way to determine if the last time an update statistics was executed was it an "update statistics low" or an "update statistics low drop distributions"? Clay Velut Database Administrator SCF of Arizona cvelut@scfaz.com http://www.scfaz.com 602-631-2486…
poor performance after IDS9.30 upgrade
Hallo! After upgrading to IDS9.30FC3X3 I got a performance problem on a query. I haved analysed the sqexplain.out file, and I saw, that that the query optimizer uses a other index. update statistics runs every day for this database. After a reorganization of the indizes, the qu…
Update Statistics question
7.x Is it possible to know somehow when the last time update statistics was run? Thanks…
Update statistics
This is a multi-part message in MIME format. ------=_NextPart_000_005F_01C08068.1A7BF7E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I have something that worries me a bit. I wrote a 4gl program that will run the update statistics on my syst…
Re: 7.31 performance problem
Yes I have. KT > Have you run update statistics? onstat -p shows a lot of sequential scans.…
RE: 7.31 performance problem
Yes! KT > did u run update statistics etc ???…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Update statistics
This is a multi-part message in MIME format. ------=_NextPart_000_0034_01C05A1D.1A715400 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I've read about this in the manuals, I've asked advise and looked at samples, but update statistics is still…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
stored procs and recompiling
Mike Talbot wrote: > The tables involved > are reindexed After this action You should 'update statistics for procedure <proc_name>'.…
When was update statistics run
Any one know how to determine when update statistics was last run for a particular table? thanks, Robert Walkup rdww@ti.com…
Update Statistics: Tell me the truth
Update statistics is kinda of an obscure subject with Informix. I can never get a straight answer on the correct way to run it and (most important) WHY ? Besides, there are some optimizer problems with version 7.3x and as far as I know, what the book recommends is not quite valid…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
update statistics
We are interested in getting some solid answers regarding the execution of the "update statistics" command against our Informix databases. Here is some background on our operating environment: 1. We are running Informix V731UC5 to V731UC7. 2. We are running an application tha…
Update Statistic
Should upate statistics be run at any time, or is it better to run update statistics when no user or batch processes are accessing the database? Sent via Deja.com http://www.deja.com/ Before you buy.…
Re:update statistics problem
Why after running 'update statistics high' performance of my application decrease dramatically? Anna Zygmunt…
Re: Hints in INFORMIX (Newbie)
Here's another hint. If the optimizer is making a bad choice, it's highly likely the statistics are non-existant, inaccurate, or inadequately detailed. Or the SQL is just plain garbage. Once in a great while you might legitimately need a hint, but it should be very rare. The …
Update statistics?
Please, Someone can tell me where I can find the reference for this ? I'am using Informix Online 7.30 Thanks. Lele…
Optimizing dbspace
Hello, I have a quite large table that acquires about 3 million rows a month. Every two weeks we purge the data by unloading it to a backup and deleting the "old" information. We do run 'update statistics' every time when deletes are performed. But it looks like it does not opt…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Informix Bug? 1206
As Paul suggests besides ALTER TABLE causing an SP to need to be recompiled sometimes UPDATE STATISTICS will cause this. So if you are not using my dostats utility to updates stats (as it already does this for you) add an UPDATE STATISTICS FOR PROCEDURE .... for each stored proc…
Performance comparison btn Informix and SQL Server
Thanks for all the suggestions, I will try them out, and give a summary about the results. P.S. One small question I have now is: optimizing one query brings another one down! :-( At least I have one query which takes double so long as it took before I run UPDATE STATISTICS.…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
RE: Update Statistics high vs medium/low
What release of Informix? I've seen many examples of update statistics killing some queries on versions 7.31 up to 7.31uc2xa. I've been running 7.3xuc2xa with a statistics plan of low/drop and medium on non-indexed columns, things are running great. Informix tells me to upgrad…
Update Statistics high vs medium/low
Hello gurus, Is it by any chance possible that executing update statistics high will slow down the queries and executing update statistics medium/low will improve the performance. Any kind of help is appreciated. Thanks in advance. Tony Woods. _________________________________…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
update statistics
Hi friends, 'Update statistics medium' is being executed from cron at 11.00 pm. It takes about 5 hours. DB size is 25 GB. Generally it executes successfully but sometimes it gives following errors : 211: Cannot read system catalog (sysprocauth) 144: ISAM error: key values locked…
update statistics
Hi friends, Update Statistics medium is executed from cron at night. Generally it runs succesfully but sometimes it gives following error : -647 Error evaluating math library function function-name. or sometimes it gives following error 211 : Cannot read system catalog (sysproc…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
Update statistics from "generation program" question
Stefan Weideneder wrote: > Hi all, > > isn't this schema of update statistics the recommandation > for SAP/R3 tables, where we have to perform an UPDATE > STATISTICS HIGH on the first indexed column and an > UPDATE STATISTICS MEDIUM for every other indexed column. > > I have ano…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Update Statistics
En plataforma Informix hago update statistics con HIGH y me fallan las querys lo cambio a MEDIUM y la query retoma los valores correctos Alguien sabe porue puede suceder esto gracias.…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
update statistics
Each night we run update statistics with the following sql statement: update systables set npused = nrows / (2020/(rowsize)+4) where npused < 0 and the result log file give us the following output: ============================ Mon Jan 24 22:30:03 EST 2000 0 row(s) updated. =…
update statistics
I am new to informix and need to know how to run update statistics on a per table basis from the command line. TIA dnk61@yahoo.com __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com…
Re: Smart upd_stats routine
"Art S. Kagel" wrote: > You might compare the number of rows reported in systables to the actual > number reported in sysmaster:sysptnhdr and if it differs by some percentage > then do the UPDATE STATISTICS otherwise skip it. Which number does optimizer uses: sysmaster:sysptnhd…
Update Statistic question
Hi all, Before exporting an Informix database, I usually do 'update statistic' this database. I'm curious if I need to run 'update statistic' again after import this database. What happen if I forget to do it? Thanks in advance for any advise. H.V…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Updating statistics
Greetings. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited basis on our databases. I've been gun shy about using them across the boa…
Update Statistics
Greetings. I'm sorry if this is a repeat, but was unsure if my email got through. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited …
Update Statistics
Greetings. I'm sorry if this is a repeat, but was unsure if my email got through. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited …
Update Statistics
Greetings. I'm sorry if this is a repeat, but was unsure if my email got through. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited …
Update Statistics
Greetings. I have a few questions regarding using distributions with IDS. We're currently using IDS 7.30.UC6 on Solaris 2.6. I've used Informix's prescribed algorithm for updating statistics on a limited basis on our databases. I've been gun shy about using them across the boa…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Re: tables with no indicies
Bridget Reitsma wrote: > > I was asked to post this on behalf of a collegue of mine - thanks for > all your replies and excellent help! > > For tables with no indices (I always expect to scan a majority of > rows), is > there any point to using a mode other than low for update s…
Update statistics
Hi This is going to sound heretical, but here goes. I've recently changed the statistics collected in our 50GByte database, from basically: high on first column on each index medium on other indexed columns low on the table We now collect the stats recommended for our version …
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Update statistics
Is it advisable to run update statistics on a Standard Engine database? Thanks g.muirhead@freeuk.com…
WHERE LIKE performance
Chris McKay wrote: > > <chris_mckay@hotmail.com> wrote in message > news:7uoeae$vur$1@nnrp1.deja.com... > > > I'm now looking at UPDATE STATISTICS HIGH etc on some of the columns and > > will drop and recreate the indexes. Any hints welcome! > > > For the information of any inter…
Re: Update Statistics Plan for IDS 7.31
Adam Bradley wrote: <snip> > 1. Run the "UPDATE STATISTICS MEDIUM" command for the whole database.It > will generate index,table, and distribution data for every table and will > re-optimize all stored procedures. > 2. Run the "UPDATE STATISTICS HIGH" command with "DISTRIBUTIONS …
Re: Update Statistics Plan for IDS 7.31
go to http://www.iiug.org/software/index_DBA.html and get utils2_ak by Art Kagel. This, among others, will automate the task of deciding what tables/columns need update statistics statements generated. Adam Bradley wrote: > Hi all, > > I am trying to formulate an "Update Statis…
Re: Update Statistics Plan for IDS 7.31
From: "Adam Bradley" <Adam.Bradley@ahmg.com.au> > >2. Run the "UPDATE STATISTICS HIGH" command with "DISTRIBUTIONS ONLY" for >all columns that head an index.This accuracy will give the optimizer the >best data about an index's selectivity. AFAIK: If you have two indexes index1 …
Update Statistics Plan for IDS 7.31
Hi all, I am trying to formulate an "Update Statistics Plan" for IDS - their is a plan that is suggested in the "Informix Unleashed" book that seems very simple and I would like to know if this sounds logical. (from Informix Unleashed) ... The following plan strikes a good bal…
SQL performance problem
Try replacing the indexes on table2 with composite keyindexes: lsystemsb@cix.compulink.co.uk wrote: > > I am having a performance problem with SQL similar to the following. Is > anyone able to suggest an alternative? The engine in question is Informix > DSA for NT v7.3.TC2 and T…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Re: Lock problem with sysprocplan???
Ok, I finally found the problem. It was because we were updating statistics. Each time the statistics were updated on an object that were used by a stored, on-line evaluate that it must rebuild the plan of excution. So the first program executing the stored proc. after an upd…
Re: Update statistics automatic ?
Pascale wrote: > Hi everybody, > > I will have more information about update statistics > > On a online informix database 7.23, does statistics updated automatically ?? No > > or must I have to "isql" update statistics ?? You must issue UPDATE STATISTICS explicitly. Note: if…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Update Statistics
I am using INFORMIX-SQL Version 7.20.UD1 running on a Sun-ultra enterprise. The problem I am having is with the update statistics high whenever it is done on a table of the following configuration for example Table Number name char(30), number char(15) Table Account number int…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Sqlexplain output
"Shevkar, Mukund" wrote: > > How to read sqlexplain out e.g. from following output - > > QUERY: > ------ > SELECT dist_name FROM district WHERE co_code = 38 ORDER BY dist_name This is an echo of your query. > Estimated Cost: 4 This an indicative of the I/O cost of the query us…
Complete database re-org
John... Don't forget UPDATE STATISTICS... ~tut…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
update statistics
i am running sql version 7.20.UD3 'update statistics' returns the following error: 689: Global variable (variable-name) declared inconsistently. this is the type of error i thought would only happen in 4GL code. i am at a loss as to what could cause it in an SQL stmt, run fr…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Re: UPDATE STATISTICS questions
>1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? Yes the distributions are created only by UPDATE STATISITICS MEDIUM or HIGH. Update statistics MEDIUM creates distribution by obtaining the random sample of the rows in the table. Whereas Update statistics …
RE: UPDATE STATISTICS questions
-----Original Message----- From: Dick.Brieck@chase.com [mailto:Dick.Brieck@chase.com] Sent: Monday, April 19, 1999 3:35 PM To: informix-list@iiug.org Subject: UPDATE STATISTICS questions I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS ME…
UPDATE STATISTICS questions
I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? 2) Is UPDATE STATISTICS HIGH or MEDIUM followed by dropping distributions the same result as just doing UPDATE STATISTICS LOW? If not, what are the differences? Thanks for…
UPDATE STATISTICS questions
I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? 2) Is UPDATE STATISTICS HIGH or MEDIUM followed by dropping distributions the same result as just doing UPDATE STATISTICS LOW? If not, what are the differences? Thanks for…
bug 105745
Has anyone else in 7.30 been bitten by this one? Statistics can mess up the optimizer and the main workaround is to drop distributions. Just checking . . . John Carlson Informix DBA WHSmith USA…
UPDATE STATISTICS
I am advised that I must NOT use update statistics on my live database. Apparently it *could* corrupt some tables. Is there any situation where update statistics can damage data? I believe that I am running SE 5.0. Cheers Robert Stuart…
Stored Procedure Optimizer Problem
In article <7d5m9o$kpi$1@nntp.gulfsouth.verio.net>, Drew <andrew.simpson @matcomcorp.com> writes >Readers, > >Why would the execution of a stored procedure continually >cause a re-optimization, locking sysprocplan in the process? > >Tried update statistics high on all tables and …
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
a slow query selection.
Have you ever tried an UPDATE STATISTICS FOR TABLE detail_table?…
Stored Procedures
Update Statistics for a stored procedure optimizes the procedure plan in the sysprocplan system table. "This optimization will also occur if any of the objects that the procedure references have changed." --from the answers online cd, SQL syntax. I interpret that to mean if you…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
UPDATE STATISTICS
Hello again everyone/ Another quick question (I hope) I'm slightly confused about the UPDATE STATISTICS command. If I do an UPDATE STATISTICS HIGH FOR TABLE tablename (col1, col2) then do an UPDATE STATISTICS MEDIUM FOR TABLE tablename (col3) then do and UPDATE STATISTICS LOW fo…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Indexing a Temporary Table...
Douglas Wilson wrote: > Aha! I just ran into this today. I created an index on a temp table > filled up the table, then indexed it (or maybe it was indexing and then > filling, oops), and had a select something like: > > select * from tmp_tbl > where rowid<>? > and indexed_field…
update statistics
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_000_01BE34C1.ECD08A98 Content-Type: text/plain Can I run 'update statistics' against a database while users are ac…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Update Statistics
Hi Admins, Is there any way I can automate update statistics for a given Informix envirnment? Regards Mike _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com…
Way to determine UPDATE STATISTICS
Hi All; Is there a method to determine the rule about update statistics ? For example, what kind of tables should be run "UPDATE STATISTICS HIGH" and others use "LOW". By the way, what is the "RESOLUTION" ? How it work ? Thanks Jung-Hui Cheng cheng@dbtel.com.tw…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Re: Matches not Work in 7.30
Petr Pomykacek wrote: > > Hi, > > I have IDS 7.30.UC2 on SCO Open server 3.2.5.0.2 and 7.30.UC3 with > Solaris 2.6 > After switch to 7.30 from 5.08 discontinued work MATCHES. > Follow example witt sqlexplain output. [SNIP] You need to update statistics to MEDIUM or HIGH level. …
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Update statistics
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_000_01BE0F40.AD4FB200 Content-Type: text/plain Can you run an update statistics high on multiple columns so that you do not …
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Re: informix does not use indexes?
You should run update statistics. It is up to Informix optimizer, if it will run index or sequential search. If data has only a few data types (M-male adn F-female) the optimizer use sequential search (index search would have no effect). And you should run update statistics to su…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Distributions
Art S. Kagel wrote: > > Stefan Weideneder wrote: > > > > Jay Aymond wrote: > [SNIP other stuff] > > > Do you think it's a good idea to give the optimizer detailled > > informations for columns, if the information will not cause > > a better query plan ? Don't you believe that it …
Re: Distributions
Stefan Weideneder wrote: > > Jay Aymond wrote: [SNIP other stuff] > Do you think it's a good idea to give the optimizer detailled > informations for columns, if the information will not cause > a better query plan ? Don't you believe that it will slow down > those queries that d…
Re: Distributions
Jay Aymond wrote: > > What is the difference in running the following two statements: > > (1) update statistics medium for table xzy distributions only; > > or > > (2) update statistics medium for table xyx (col1) distributions only; > update statistics medium…
Re: how to force the use of an index?
possibly using set optimization low would cause the cost estimate to be lowered and the optimizer would try to be less efficient, and get your index path. m. pfadenhauer wrote: > hello there, > yes indeed the most trivial case is a missing 'update statistics'. but i > can tell…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Q: Update statistics
Howdy folks, What is the effect to the users if they are using the system while running update statistics is running ? What is, if any is the effect to my update statistics ?? TIA Suze…
Informix database - memory recommendations
We have a 1.1 GB database on an HPUX machine. One of our clients is interested in finding out the optimal or recommended physical mem size required for a database of this size. I called customer service and they didnt have an answer to that. They talked about monitoring the swap…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
update statistics
I am trying to run update statistics from cron. I keep getting database closed messages. But I can connect to the database and run update statistics interactively. do I have to submit a password when I connect to the database?…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
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_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: query optimizator
>Something strange happened to me (is not the first time) with >Informix OnLine 7.2 on UnixWare 2.1.1 with dual Pentium 133. >A query that we use frequently, suddendly stopped working. >The query optimizer decided to change something, and the query now >do not use anymore the rig…
Re: query optimizator
Marco Traini wrote: > > Something strange happened to me (is not the first time) with > Informix OnLine 7.2 on UnixWare 2.1.1 with dual Pentium 133. > A query that we use frequently, suddendly stopped working. > The query optimizer decided to change something, and the query now >…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Update statistics high vs medium
Hi, we are running Informix ODS v7.23 on AIX 4.2. There is a table with 27000 records look like this: TABLE dot ( dot_serial_num char(11) not null PK, dot_title char(82), create_dt date indexed) We have several queries that join multiple tables including this DOT t…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Update Statistics
A necessity but taking out a table is a pain Does anyone know of a tool that eases the pain. I'm trying to run 24 x 7 but... Thanks, Robert…
Update statistics question
Hi Everybody, I have been doing some investigation into update statistics and was wondering if any one has similar experiences. Environment DEC OSF 3.2g Informix v7.20uc1 table: columns 25 rowsize 168 rows 3000000 I did the following:…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: Optimizing..
Know your schema, update statistics, and read sqexplain.out.…
Re: slow performance
> I am running ODS 7.23 u4 on HP 10.20 > So many users complained about slow performance...I looked at "top".... > IDLE has been around 21% > %WCPU 36% == (command) oninit > %CPU 35% == (command) oninit If this slow performance occurs when running a query it may be because of …
Re: Info on sysptntab table
Tim Owens wrote: > > Anyone know where I can get information on the sysptntab table in the > sysmaster database (Informix 7.22)? > > There seems to be some useful data there, but I can't find any reference to > it in the Informix documentation. It contains current statistical an…
Update Statistics
All, I have been left a large script by the Informix DBA to run. It does an update statistics (low, medium and high) on all of the tables in the db. Is there any way I can monitor how this is doing as at the moment it is just sat in dbaccess and I can't tell how much progress i…
Re: Update statistics of the informix.xxx tables.
>Is the update statistics scenario of the informix.systables alike tables >of a database the same as for the users tables. ? For the most part the access to these tables use a "fixed plan". Since this information is mainly needed by the optimizer to generate the query plan, we …
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: update statistics medium/high: how often?
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---1607792580-1099951567-884736134=:11568 Content-Type: TEXT/PLA…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: DELETE does not use index
>Sorry for my stupid question, but what does UPDATE STATISTICS do in detail? No such thing as a stupid question. UPDATE STATSTICS updates information in the database catalogue, such as systables, sysindexes, sysdistributions. Information from these catalogue tables is read by …
Re: DELETE does not use index
Sorry for my stupid question, but what does UPDATE STATISTICS do in detail? cu Reiner pharia@erols.com schrieb in Nachricht <881057475.21169@dejanews.com>... > >Try "update statistics on table table_1"…
Re: Does anybody developed a PB 4-5-6 application and Informix 7.2 with SUCCESS
Santiago wrote: > > Hello! > I've finished a PB 4.02 application that access to Infomix. > One of the window insert customer orders and it call to an stored procedure > to validate the data. The window MUST BE working all DAY and the user are > entering orders one for a minute. >…
Re: Running UPDATE STATISTICS on a table being used
In article <652nqa$3ho@cssun.mathcs.emory.edu>, sujata_soman_at_omm-la2-infotech-001@internet.omm.com says... > > >Hi. > It is me again with another question related to UPDATE STATISTICS. >Yesterday, I ran UPDATE STATISTICS high on 6 of my largest tables WHILE they >were being…
Re: Running UPDATE STATISTICS on a table being used
sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > Since the update statistics was going on parallelly with the query, will the > query use the new plan once the update statistics is over or does it still go > with the old plan ?? The query is just taking for eve…
Update statistics Questions
Subject: Update Statistics Confusion Date: 10/9/97 9:08 PM We are running On-Line v7.23. I ran some test evaluating update statistics using the following SQL and we got some very strange behavior. Why? select count(*) from x_forms x,prdct_END e w…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: Update Statistics - 7.23
Art S. Kagel wrote: > > Mark Taylor wrote: > > > > Hi, > > > > We are looking for input on running Update Statistics on some > reasonably > > large tables (approximately 80 million rows) and are looking for a > > combination of reasonable speed and reasonably accruate res…
Re: Update Statistics - 7.23
In article <33FC6D7D.66CA@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >Mark Taylor wrote: >> >> Hi, >> >> We are looking for input on running Update Statistics on some reasonably >> large tables (approximately 80 million rows) and are looking for a >> combination …
Re: Update Statistics - 7.23
Mark Taylor wrote: > > Hi, > > We are looking for input on running Update Statistics on some reasonably > large tables (approximately 80 million rows) and are looking for a > combination of reasonable speed and reasonably accruate results. We > have the methods in the Informix D…
Re: Update Statistics Question
> I understand the need for running UPDATE STATISTICS for the tables >in a database. The recalculated data from this command is going to be >placed in the systables, syscolumns, sysindexes and sysdistrib system >catalog tables. After updating statistics for user created t…
Update Statistics Question
I understand the need for running UPDATE STATISTICS for the tables in a database. The recalculated data from this command is going to be placed in the systables, syscolumns, sysindexes and sysdistrib system catalog tables. After updating statistics for user created table…
Re: Query Optimization question
On Thu, 10 Jul 1997, Ignatius Cristina Michelle wrote: > Hi. > > What statistical information can Informix draw upon to determine how > many rows will be satisified by a query coondition of the form "column = > value", for example, "department = 'D'" where "department" may or ma…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
UPDATE STATISTICS
Why doesn't the engine UPDATE STATISTICS automatically? Does anyone have any ideas regarding the logistics of running of UPDATE STATISTICS in a 24 hour environment? Thank you and please also reply via email.…
Re: SQL Optimizer
Emil Sarkissian wrote: > > Does anyone know what "Estimated Cost" really > means, when the sqexplain.out file is generated > by OnLine 5.1? > > When I add silly conditions like: > > SELECT ps.ln > WHERE ps.sheet_date BETWEEN BeginDate AND EndDate > AND ps.ln = ps.ln -- ??? …
Re: Help with composite indices
Peter Whittleton wrote: > > Irwin Goldstein wrote: Hi all, I'm wondering whether the recommendations below are really from Informix. UPDATE STATISTICS HIGH and MEDIUM generate data distributions for the optimizer. This information must be read if they are available. If the optim…
RE: Optimizing Select count distinct statement
Also, try setting the OPTCOMPIND variable to 0, bounce the server, rerun update statistics, then rerun the query. You can change this variable through the menus : onmonitor/Parameter/pdQ/ Optimizer Hint: 0 Let me know if that changes the performace. ALSO- 7.12 versions have me…
Re: when to 'update statistics' ???
Leo_Chen@usc.com.tw wrote: > > Hi all: > if anyone knows when to do the 'update statistics' ? > Or, if there is any information (some ratios, for example) indicates > that the engine needs 'update statistics'?? > > leo If you have a very active tables (many inserts an…
when to 'update statistics' ???
Hi all: if anyone knows when to do the 'update statistics' ? Or, if there is any information (some ratios, for example) indicates that the engine needs 'update statistics'?? leo…
UPDATE STATISTICS
1. Can someone tell me if the UPDATE STATISTICS command generates an output file for the DBA to read? 2. How often should you run this procedure? TIA, /Patrick TV Corp. Singapore…
Re: understanding On-Line's Optimizer
sromankiw@execrisk.com (Steve Romankiw) wrote: :I am new the Informix On-Line engine. I am looking for information on :On-Line v7.13 Cost Based Optimizer. We are migrating to Informix from :SQLBase and the optimizers work differently. In informix, we often get :sequential sca…
Re: understanding On-Line's Optimizer
On 19 Dec 96 at 10:05, Steve Romankiw wrote: > I am new the Informix On-Line engine. I am looking for information on > On-Line v7.13 Cost Based Optimizer. We are migrating to Informix from > SQLBase and the optimizers work differently. In informix, we often get > sequential s…
Re: Dynamic Optimizer problems??
Ronald E. White <ronwhite@erols.com> wrote in article <328BAF1B.1805@erols.com>... > Has anyone had any problems with Informix's dynamic optimizer? We're > running Informix with PeopleSoft and seem to be having problems with the > dynamic optimizer going to the BIG table to do it…
Re: Dynamic Optimizer problems??
Ronald E. White wrote: > > ...seem to be having problems with the > dynamic optimizer going to the BIG table to do its first search, then > going to the little table last. Have you tried doing an update statistics medium on both the big and little tables? It sounds like the opt…
UPDATE STATISTICS, good?
I have several stored procedures that use "update statistics for procedure..." to update some other procedures that this procedure need to reference. That works fine in INFORMIX 7.1.1, but crash database in INFORMIX 7.1.3. So, is UPDATE STATISTICS really important, or I can ignor…
Re: Update Statistics Low, Medium & High
billy@west.co.za (Billy Wheeler) wrote: :> >In our system, we discover sometimes some tables in index searching is much :> >faster while we update their statistics low or medium instead of high. :> I heard a discussion the other day which indicated that when you update :> stati…
Re: Update Statistics Low, Medium & High
Clem Akins wrote: > > >In our system, we discover sometimes some tables in index searching is much > >faster while we update their statistics low or medium instead of high. > > > >We have an idea that update all tables high statistics with reference to the > >server admin. guide.…
Update Statistics Low, Medium & High
In our system, we discover sometimes some tables in index searching is much faster while we update their statistics low or medium instead of high. We have an idea that update all tables high statistics with reference to the server admin. guide. Is this correct ? Regards, Dani…
Re: error in update statistics
Bug #56524 is an UPDATE STATISTICS HIGH bug for SE 7.12.uc1 on SCO 3.2.5.0. There may be a similar bug for ONLINE. Patrick Preuss wrote: > > Hi, > > we are experiencing an error in update statistics high. it > results in an internal server error, and sometimes the > server crash…
Re: Can UPDATE STATISTICS screw up the optimizer?
Bashar, Chalabi wrote: > If we do the following: > > delete all rows in the table > update statistics > load 100 rows > update statistics > run the procedure > ----- I'm curious, why are you updating the statistics BEFORE you load in the data? I thought statistics were used by…
Re: Can UPDATE STATISTICS screw up the optimizer?
What is setting of OPTCOMPIND ? Although 'by the book' indicates 2 should be best ... we've gotten some odd 'optimizations' we can't seem to explain. -Lin BasharChalabi wrote: : He have a stored procedure that updates all records in a table in a : foreach loop. Within the loop, …
Can UPDATE STATISTICS screw up the optimizer?
Are rows inserted to the table prior to the deletion? IS update STATS occuring before you do the deletion? ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTS…
Re: Can UPDATE STATISTICS screw up the optimizer?
In article <837693419.22432.0@basharlp.ctl.com>, Bashar Chalabi <?@?.?> writes >He have a stored procedure that updates all records in a table in a >foreach loop. Within the loop, it selects records from the table it is >updating as well as other (static) tables, all with less th…
Re 2 queries 2 suns 1 takes too long
Thanks everybody for your responses. Update statistics worked to sovle this problem. Interesting thing happended in sqexplain.out. The optimizer chose the same path as before. It did not create temporary files as what happened on Sparc 2. The sparc 1000 has more memory. …
Can UPDATE STATISTICS screw up the optimizer?
He have a stored procedure that updates all records in a table in a foreach loop. Within the loop, it selects records from the table it is updating as well as other (static) tables, all with less than 1000 rows. If we do the following: delete all rows in the table update statis…
Re: Informix Optimiser: Should I use it?
Cheryl Kendricks, molten keyboard in hand, chimes in with: > > Good 2cents Sally!!! Avoid forcing the query with DUMMY stuff if at all > possible. Let the Engine do the WORK you paid ($$$$$$) for! Again version > is critical when you talk this subject, as well as, the DB DESIGN!!…
Re: DBSchema on informix 5.01
Have you ran UPDATE STATISTICS ? also run bcheck on all your tables...…
Update statistics
Thanks to all that offered help for the update statistics... Turned out to be a combination of problems. 1) The update statistics statement had to be prepared. 2) Update stats high was resulting in a tablespce overflow We now have stats for our database, and things are moving …
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Query Performance Problem SE 5.06.UC1
tolis, } is facing following problem: } The optimizer doesn't select the appropriate index and the response time } varies from seconds to 30 minutes as also the no of rows found in the same } SQL statement. } The update statistics statement has been run. } The index is checked w…
Q: optimizer does the wrong thing on join
Hi, we have a join with several tables, written with the most restricting table stands at the top (the right thing, I guess). What does the optimizer do? He just flips the order, and scans the biggest table first, sequentially!!! Is this a problem for Update Statistics? Thanks,…
Optimizer problem
Dear noname, Just a suggestion are you updating statistics after creation ??? ================================================================ Terry Boyland :^{}) Proverb: Once a king always a king But once a knight is enough !…
RE: Set Explain with SP's
> > Jon, > > Because procedures are optimized when they are stored in the database, > that is when you need to set explain on. For example: > > SET EXPLAIN ON; > CREATE PROCEDURE... > > The "SET EXPLAIN ON" must appear outside of your create procedure. Its my impressio…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: Distributed Join
>I remain very sceptical. To optimize a join across multiple vendor databases >requires that your 'joining' product must fully familiar with all >the individual optimizers in each database to understand how they will process >their portion of the query. Next it must be familiar…
UPDATE STATISTICS.
> From: "shawn raymond" <shawn.raymond@CCGATEWAY.AMC.EDU> > Is it possible that UPDATE STATISTICS could slow down access to a > database? I ran it on our database this morning and after it was > finished things got real slow. We are running Online 5.03UC The…
Update statistics.
Hello all, Is it possible that UPDATE STATISTICS could slow down access to a database? I ran it on our database this morning and after it was finished things got real slow. We are running Online 5.03UC2. Any feedback would be appreciated. Thanks! …
Re: The truth behind UPDATE STATISTICS...
} From: rizzo@fourgee.demon.co.uk (Rus Ambler) } Subject: The truth behind UPDATE STATISTICS... } Date: Wed, 26 Apr 1995 19:33:50 +0000 } Reply-To: rizzo@fourgee.demon.co.uk } Organization: 4GEE Computer Systems } } H'ok, you probably think this is a dumbarse question, but apart …
Re: Cost-based Optimizers
> Hi, > > Its worth looking at the techie manuals for V6.* and above as these > give a reasonable explanation of the costs / histograms that > informix has in its optimiser, as far as I am aware this is > just as powerful as Ingres's if not more so with various > confidence level…
npused showing negative values
Hi all, can someone explain what's the use of the "npused" field in the systables. I think it has to do with cost optimizing because UPDATE STATISTICS allways changed the values in this field. But i think that there is a bug somewhere because nearly all npused fields in our dat…
Re: Query Optimiser
>I know that the Informix optimizer uses statistics for part of its >optimization. Does it also use statistics for re-ordering the evaluation >of ANDed joins in the WHERE clause? Someone said in a meeting that the Informix 5.x optimizer is very sensitive to "update statistics".…
Update Statistics
%UNIPLEX %TO informix-list@rmy.emory.edu %FROM rridley %SYSTEM DHLNET %SUBJECT Update Statistics %VERIFY y %DATE 26/03/93 18:35 %REFERENCE 16917 I have a question regarding the necessity of running 'update statistics' regularl…
Re: Online V4.0 Optimizer
In article <1428@ixos.de> jochen@ixos.de (Jochen Hager) writes: >Hello Informix Specialists! > >Again and again we encounter optimizing unpredictables with >Informix Online V4.0. > >I know this is a very vague question but: > > Does anybody know which strategies are used by the >…
QUERY Optimizer
Christian Hansen write: >I have observed that the optimizer (SQL 4.0 and an On-Line 4.0 DB) is >very often guessing wrong, even if we run update statistics. > >The estimated number of rows returned does very much depend on the >sequence in which you enter the SELECT statement. …
QUERY Optimizer
Hi netters I have observed that the optimizer (SQL 4.0 and an On-Line 4.0 DB) is very often guessing wrong, even if we run update statistics. The estimated number of rows returned does very much depend on the sequence in which you enter the SELECT statement. In one case we had …
Re: Update Statistics
> > Does anyone have a recommendation on how often the update statistics > command should be run? 'update statistics' only updates the system catalogs with the correct number of rows and the 'next-to-highest' and 'next-to-lowest' values so that the optimizer can make an educated…
Re: Update Statistics
Harry Bochner, in your mail you wrote: > > My suspicion is that the command is obsolete, but my only reason for [...] Wrong, at least according to my Informix-Online instructor. The UPDATE STATISTICS command not only updates "nrows" in the "systables" catalog (the query optimiz…
Update Statistics
Does anyone have a recommendation on how often the update statistics command should be run? Should it be run as an adminstrative routine, or started up at the beginning of each .4gi(.4go for some) Thanks in advance ===============================================================…