Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    1

    Unanswered: Urgent db2 question

    Db2 insert load's data slowly if we have load scheduled for tables in parallel. There is no such situation that one table being accessed by another table and lock issues. All are independent tables. Individually completes data load fast soon than in parallel.Is there any parameter or Performance improvent tip.

    We have following parameters set
    DB2_PARALLEL_IO=*
    MUlti page allocation parameter is yes

    Any input ??

  2. #2
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by infodb
    Db2 insert load's data slowly if we have load scheduled for tables in parallel. There is no such situation that one table being accessed by another table and lock issues. All are independent tables. Individually completes data load fast soon than in parallel.Is there any parameter or Performance improvent tip.

    We have following parameters set
    DB2_PARALLEL_IO=*
    MUlti page allocation parameter is yes

    Any input ??

    1- increase UTIL_HEAP_SZ ten times from default value
    2- turn on INTRA_parallel parametes
    3- look at load command you can turn off some feature for better performance

Posting Permissions

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