Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    13

    Unanswered: DB2 performance problem

    I have low tps in db2 , when i inserted 100000 records in table, it finished after 400 seconds but in informix it finished after 50 second. why?????

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    ??? We would need a lot more info. What platform? what Release? Memory? Table declaration? Indexes? DB config? DBM Config? How are you inserting? Are you inserting from a select statement? from a flat file? Why are you inserting(vs. loading)? Is HADR involved? Q/REP? Are there any triggers? Disk i/o issues? What type of data?
    Your question is kind of like asking a blind person to describe the color green.
    Dave

Posting Permissions

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