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.
Rick Bernstein — — source: Informix-list mailing list archive (1991-1998)
At 04:47 PM 1/13/98 -0500, you wrote:
}
}1) UPDATE STATS on individual tables NEVER databases.
}2) Follow the rules in SERVERS_7.2 (if you do not have that file or your
} release was one of those that is just a clone of SERVERS_7.1 let me
} know I have extracted the text and can post it.)
}3) Set PDQPRIORITY to at least 10 (go for 40 if you can run during light
} user load.
}4) Set PSORT_NPROCS>=40
}5) Set PSORT_MAXALLOC=10240
}6) Either use AT LEAST 4 TEMPDBspaces equally sized or set PSORT_DBTEMP
} to list AT LEAST 3 different file systems on different drives again
} keeping in mind that the one with the least available space limits
} sort space.
} (clip)
}
}Art S. Kagel
}
}
What does item 4 (Set PSORT_NPROCS>=40) accomplish?
My Informix documentation states that the upper limit for the
PSORT_NPROCS environment variable is 10.
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.