Hitachi

Hitachi Advanced Database Messages


KFAA40290-E

The number of threads that can be used is insufficient. (required no. of threads = aaaa, available no. of threads = bbbb, command = cc....cc) (E+M)

The number of threads is insufficient to execute the cc....cc command.

aaaa:

Number of threads to be used by the command cc....cc

bbbb:

Available number of processing real threads

cc....cc:

Name of the command for which the number of threads is insufficient

S:

Terminates processing.

Action:

The number specified for the option# of the command cc....cc (the number specified as the number of threads to be used for the command) has exceeded either of the following specified values.

  • The value specified for the adb_sys_rthd_num operand in the server definition

  • The value specified for the -r option of the adbcltgrp operand in the server definition (the value specification of the command group)

In such a case, take one of the following corrective actions:

  • For the option# of the command cc....cc, set a smaller number of threads to be used for command execution.

  • Specify a larger value for the adb_sys_rthd_num operand or for the -r option of the adbcltgrp operand in the server definition.

Make sure that number-of-threads-to-be-used-by-command is equal to or less than available-number-of-processing-real-threads. Once this is done, re-execute the command.

#

The following tables shows the relevant option of each command and the minimum number of threads required for command execution.

Command name

Command option name

Minimum number of threads required

adbimport

adb_import_rthd_num

2

adbidxrebuild

adb_idxrebuild_rthd_num

3

adbgetcst

adb_getcst_rthd_num

2

adbexport

adb_export_rthd_num

3

adbmergechunk

adb_mergechunk_rthd_num

3

adbarchivechunk

adb_arcv_rthd_num

3

adbunarchivechunk

adb_unarcv_rthd_num

2