Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2003
    Posts
    39

    Arrow Unanswered: performance problem while running extract(IMP)

    One API runs long on production when there are <a1> and <a2> in the input. When these tags are sent in, it adds association of the fault management servers to the organizations (org1 table). Without these tags the response time is usually within 5-15 seconds. With these tags in the verb ran from 55 to 70 seconds on average.

    however, testing on the UAT when input was sent with or without the 2 tags, the verb ran 11-14 seconds only.

    I compared the db2 system catalog how the indexes for org and org1 are defined among between UAT and prod db, attached is the spreadsheet for reference.
    If you find any problem in the attched sheet ,need a brief details

    The OS=AIX ,Db2 v7.1 ,

    need yours help immediately
    Thanks

    with regards

    ashaq
    Attached Files Attached Files

Posting Permissions

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