DB2 ist ein Produkt der
IBM Corporation. Bitte Copyright- und Trademark-Hinweise beachten!
Installation parameter considerations for parallel LOAD processing
Problem
Running concurrent LOAD jobs, returned the following error messages:
DSNU028I DSNUTILB - UNABLE TO CONNECT TO DB2, REASON=X'00F30055'
DSNU012I DSNUTILB - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
Solution
>From the DB2 Installation Guide:
Because utilities can use additional threads, you should consider increasing the IDBACK and CTHREAD subsystem parameters. Increasing these parameters can help you avoid failure of some utilities due to increased thread usage. An increase also supports the additional parallelism to be performed by the utilities.
If you run into the above error messages, we recommend increasing IDBACK first.
In V8 additional threads might be needed for inline statistics during LOAD if any of the indexes are DPSIs. Also, in V8, SORTKEYS is the default, so additional threads might be needed to build indexes in parallel (this situation is the most likey reason that a higher IDBACK would be needed). Additional threads might be needed in other utilities, such as RUNSTATS or CHECK LOB.
P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.
With kind regards
Michael Dewert, Software Group
DB2 Information Management Software
