Hi all,

We are trying to load few tables on 6 node partitioned database using autoloader. UDB ver 8.1 AIX 5.1

Some tables get loaded properly, but few gave following error
"SQL2043N Unable to start a child process or thread."

What are we supposed to do to load these tables.

Thanks,
toby

Your LOAD table may have spawns prcoesses that exceeded the limit of maxuprc or total number of spwaned processes exceeded the shared memory configuration.

try LOAD option CPU_PARALLELISM & DISK_PARALLELISM will small value, i.e.
LOAD FROM ... INSERT INTO .... CPU_PARALLELISM 2 DISK_PARALLELISM 4;
(Machine has 2 CPUs, 4 containers on tablespace.)

No. Process = No. Connection + CPU_PARALLELISM + DISK_PARALLELISM
No. Process = 1 + 2 + 4
No. Process = 7


if option CPU_PARALLELISM & DISK_PARALLELISM are not specify in LOAD command, default value is taken. CPU_PARALLELISM will be the no. of CPU of machine, while DISK_PARALLELISM will be the no. of containers of tablespace which target table located.

I also seen the problem solved by increase NOFILES at OS level.

It seems there may not be enough available memory to create the new process or thread. On AIX-based systems, the maxuproc value set by the chdev command may be too low.

User Response: Ensure the system limit for number of processes or threads has not been reached (either increase the limit or reduce the number of processes or threads already running). Ensure that there is sufficient memory for the new process or thread. Resubmit the utility command

With Regards

Bala