I have been using db2batch for a while now. The more I use it, the more I like it. It can give you very useful information about your query that can help you tune it. \u00c2\u00a0It can give you execution \/ run time information, run it under certain optimization level, give you explain information, database snapshot , dbm snapshot, table snapshot information while the query is running. \u00c2\u00a0There is one\u00c2\u00a0caviar\u00c2\u00a0to it, by default db2batch execute the query in RR isolation level. This is not desirable if the query is long running and is run against production system as it may cause locking issue and might even hang the system. So I suggest you change the\u00c2\u00a0isolation\u00c2\u00a0level of the db2batch to CS \u00c2\u00a0if you are going to run it against production or against any system which is busy. \u00c2\u00a0You can do so by binding the db2batch.bnd found on \/sqllib\/bin directory with isolation cs :<\/p>\n
db2 bind db2batch.bnd isolation cs blocking all grant public<\/em><\/address>\ndb2batch does a good job of benchmarking the sqls. \u00c2\u00a0There are several options you can use in db2batch, I am not going to mention all of it here. You can find it on DB2 manuals<\/a>, but here is a basic one I always use :<\/p>\n db2batch -d rajudb -f \u00c2\u00a0sqlfile1.sql \u00c2\u00a0-r result_sqlfile1.txt \u00c2\u00a0-o p 1 e 2<\/p>\n This will connect to the database rajudb , run the sql in the file sqlfil1.sql and send the output to result_sqlfile1.txt . The -o options enables me to specify the level of performance detail and explain done on the table. Refer to the manual<\/a> to find details about it.\u00c2\u00a0<\/p>\n Here is sample output I got from the above run :\u00c2\u00a0<\/p>\n
![\"result_sqlfile1.png\"](\"https:\/\/techsatwork.com\/blog\/wp-content\/uploads\/2009\/04\/picture-3-1024x596.png\" "\\"result_sqlfile1.png\\"")
<\/a>