Results 1 to 4 of 4

Thread: Load failing

  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: Load failing

    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

  2. #2
    Join Date
    Nov 2005
    Location
    Malaysia
    Posts
    2

    Cool LOAD options CPU_PARALLELISM & DISK_PARALLELISM

    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.
    Last edited by KillerBob; 11-11-05 at 05:01.

  3. #3
    Join Date
    Nov 2005
    Location
    Toronto
    Posts
    65
    I also seen the problem solved by increase NOFILES at OS level.

  4. #4
    Join Date
    Jan 2004
    Posts
    49

    Load Fail Issue

    Quote Originally Posted by KillerBob
    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.

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •