Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: load performance help

    I have two identical udb 8.1 servers running under aix 5.3.
    Both servers are 2 node logical part.
    On Server A the load of half million rows runs in 30 secs and
    On Server B the load of same half million rows runs in 200 secs.

    I checked the db and dbm cfg parms and they are identical on each node.
    also the db2set parameters are identical.


    Is there anything I am missing. How do I debug and rectify problem on Server B?

    Any help is appreciated.

    Thanks,
    toby

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    I wish my load ran in 200 seconds.

    Interesting that there's a difference like that, a few things possible, like REORG'ing might help get the pages in the right order. Could also be fragmentation on your filesystem if you're using SMS or DMS with file containers.

    Are you specifying the INDEXING MODE, or letting db2 AUTOSELECT? (default) If the default, maybe it's doing an INCREMENTAL on one node and a REBUILD on the other?

    Just a few thoughts.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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