File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Ant, Maven and Other Build Tools and the fly likes DB2 v9 slower than DB2 v8 while inserting DDL and DML Scripts using Ant script Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Engineering » Ant, Maven and Other Build Tools
Bookmark "DB2 v9 slower than DB2 v8 while inserting DDL and DML Scripts using Ant script" Watch "DB2 v9 slower than DB2 v8 while inserting DDL and DML Scripts using Ant script" New topic
Author

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

Mahesh Srinivas
Greenhorn

Joined: Nov 22, 2008
Posts: 6
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

Joined: May 14, 2008
Posts: 5836
    
    7

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.


JBoss In Action
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB2 v9 slower than DB2 v8 while inserting DDL and DML Scripts using Ant script