Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    2

    Unanswered: db2 set integrity performance issue

    During the set integrity phase associated with a db2 load, the set integrity on a table containing 30 million rows is taking approximatly one hour per million rows to complete. There is plenty of free physical memory and we bumped the application control heap, db heap, sort heap, utility heap. It runs again ok for a while and then just bogs down. auto configure says we need more heap but it does not help keep a sustained throughput.
    We are running db2 8.2.1 fix pack 9 on aix 64 bit 5.2.05
    Has anyone run into a case like this and what has been done to fix/tune to resolve this category of issue?
    thanks

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    How many constraints do you have and what indexes exist to match the constraints?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2006
    Posts
    2

    db2 wait states

    7 indexes including PK. However, the processing speed was hugely abnormal in that most of the CPU was in wait state. I have observed this to be the case in both cases where there was a lot of disk I/O and cases where there is very little.

Posting Permissions

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