Oninit® Archive
Results for “USTLOW_SAMPLE”
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
Ben: You are correct that this was a message in the message log. I had it in my head that it was coming from dostats as one of the warnings that it puts out, but it is not. I'm not convinced that the engine will have regenerated the LOW stats without sampling when you have seen t…
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…
v11 to v12 upgrade and update stats
Do you have USTLOW_SAMPLE turned on on 11.7 and off on 12.1? The environment variables like DBUPSPACE are the same? PDQ settings etc? On Tue, Feb 14, 2017 at 5:11 PM, TOM LEHR <lehr@werner.com> wrote: > after converting to v12 over the weekend, we have noticed update stats is >…
Long lasting dostats
Normally I would just recommend doing this at a quiet time, but in your case this table is so big that it's going to overrun any quiet period. It's always a trade off. Do you go for PDQ 80 or 100 to get this done as quickly as possible to limit impact on production or go with PDQ…
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…
Update statistics
It's not an error but a warning. You can get rid of the warning by turning LOW mode sampling off by setting the ONCONFIG variable USTLOW to zero (0). Or you can disable it for this single table by setting the environment variable USTLOW_SAMPLE to 0 either in the session's environ…
Optimising index builds
Is most of the index build time spent automatically collecting statistics after building the index? This would look like a lot of data page reads, a lot of index page writes and then a lot of index page reads. I had a similar situation when doing some testing against version 11.…
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…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
SQL_FEAT_CTRL
As Art mention it's an undocumented variable. And what this means is that it really shouldn't be used (and mentioned in blogs) without a proper recommendation from tech support. This parameter (and another one) is a bitmap where each bit has a specific function. So setting it to …
Aggregates
Very interesting situation.... But before I loose myself in my thoughts, can you make sure you run proper (no offense) update stats on the tables (something like Art's dostats). If not,can you change the queries? I know that's not what you want to hear/read, but if it's possible …