Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB2 v9 slower than DB2 v8 while inserting DDL and DML Scripts using Ant script

 
Mahesh Srinivas
Greenhorn
Posts: 6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can anyone suggest why execution of DDL and DML Scripts using Antscript in DB2 v9 is slower than DB2 v8 even though I am using DB2 v9 drivers in the Ant classpath? Execution of DDL and DML Scripts using DB2 v9 through Ant script is taking 103 minutes to complete whereas same execution takes only 23 minutes in DB2 v8. I am using ant 1.6.5 in the classpath. What is the root cause and solution for this problem?
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to use DB2 tools to monitor the SQL and how DB2 is handling the statements. That should tell you what the issue is.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic