Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
John Miller — — source: Usenet: comp.databases.informix
You should change the DBUPSPACE to the following:
DBUPSPACE=0:50:1
0 Unlimited disk space usage for sorts
50 50 MB of memory for sorting in memory. This
is the maximum that can be giving to memory
sorting without PDQ.
1 Do not use index paths and print additional
info in sqexplain.out
I am guessing the problem is with using index paths. If an index path
is choosen for a large index this can really slow down update statistics.
Also make sure that when you run update statistics with PDQPRIORITY
that you only update tables and not procedures.
John Miller
hatricom wrote:
> 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 and high for the
> tables which are most used.
>
> I use PDQPRIORITY 80 for tables and 1 for procedures.
> DBUPSPACE=25000:1000
> The script finish in about 5 hours, the database is 70 Gb large.
>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.