db2cmd参数

最近在弄自动初始化数据库的ant脚本，个人感觉挺好玩，结合之前自动构造OA的脚本一起使用，以后的工作少了一大截。。呵呵，幻想着一边喝茶一边工作的休闲日子。

 

先贴段代码

<target name="DB2" if="isDB2"> <echo message="正在执行DB2数据库初始化" /> <echo message="正在建立文件夹,存储数据库文件" /> <mkdir dir="${db2_dbfile_path}" description="建立文件夹,存储数据库文件" /> <echo message="正在生成数据库初始化脚本" /> <copy file="./rebuild_db2_bak.bat" tofile="./rebuild_db2.bat" overwrite="true" /> <replace file="./rebuild_db2.bat" token="数据库名" value="${db2_dbname}" /> <replace file="./rebuild_db2.bat" token="数据库路径" value="${db2_dbfile_path}" /> <echo message="正在执行数据库初始化脚本" /> <exec executable="db2cmd" failonerror="true" description="执行重新建立数据库的脚本" failifexecutionfails="true" > <arg line="rebuild_db2.bat" /> </exec> <echo message="正在执行数据库文件" /> <sql driver="${db2_driver}" password="${db2_password}" userid="${db2_username}" url="${db2_url}" autocommit="true" encoding="gbk" onerror="continue" keepformat="false"> <classpath> <pathelement path="${db2_driverfile1_path}" /> <pathelement path="${db2_driverfile2_path}" /> </classpath> <transaction src="${db2_sqlfile_basepath}/1.oabz51_frame.sql"/> <transaction src="${db2_sqlfile_basepath}/2.oabz51_base.sql"/> <transaction src="${db2_sqlfile_basepath}/3.oabz51_flow.sql"/> <transaction src="${db2_sqlfile_basepath}/4.oabz51_新公文基础配置.sql"/> <transaction src="${db2_sqlfile_basepath}/5.oabz51_新闻公告.sql"/> <transaction src="${db2_sqlfile_basepath}/6.oabz51_标准收发文.sql"/> <transaction src="${db2_sqlfile_basepath}/7.oabz51_表单菜单初始化脚本.sql" /> </sql> </target>

 

程序运行到exec的时候，db2cmd这个程序就总是新弹出一个窗口，然后下面“正在生成数据库初始化脚本”的话就打印出来了，问题是我上面的db2cmd还没执行完呢（里面去重新建数据库，时间比较久）。。后面执行数据库初始化脚本的时候就报错。早知道db2比较严格，凡事都比较特殊，也不用这么特别吧。。

 

在网上搜索ant db2cmd，可能没人像我这么懒的吧。不过也有遇到类似的问题，有人给了下面的结果

db2cmd -i -w rebuild_db2.bat，问题解决。其实只要添加-i就够了。

http://www.mydatabasesupport.com/forums/ibm-db2/83399-ant-db2-2.html

 

If Ant has some mechanism where it can interface to a database (through JDBC I guess since it's a Java app), you could use that - though you wouldn't be able to run DB2 utilities like RUNSTATS, IMPORT or LOAD since they're not SQL commands. I've come across a similar sitation when writing bash scripts for DB2 with Cygwin under Windows (which needed to run such utilities). The problem is the peculiar "db2cmd" application. Under Linux/UNIX this doesn't exist, and you'd be able to do what you're trying to. I'm not 100% sure what's going on with it, but the following theory seems to fit: The "db2cmd" application holds some sort of session or connection handle open which the "db2" application uses. Therefore all SQL commands which require an open connection must happen within a series of "db2" commands running within a *continuous* "db2cmd" session. I got around this in my bash scripts by generating a load of commands, dumping them to a temporary text file, then running something like db2cmd -iw -c db2 -tv -f some_temp_file.sql To ensure that all the commands are run within a single "db2cmd" session. I'm guessing you could resort to something similar with Ant. Either get your script to write out the SQL to a temporary file and remove it after it's done, or have an SQL file which accompanies the Ant script, and use something like: BTW, the -i and -w switches just ensure that the db2cmd session runs under the same console and inherit the same stdin/stdout handles as Ant is using - but you may not need them (under bash they were useful as I could then use redirects for logging purposes, or pipe SQL commands through stdin instead of using an input file). HTH, Dave.

 

 

 

 

补充十分权威的资料：

http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/core/r0002036.htm

 

 

另外db2clpex.exe似乎可以替代db2cmd.exe，测试了一下，感觉不怎么好，前台不输出任何东西，但是似乎也可以成功运行，运行效果无法追究，在官方资料里面也查找不到它的资料。反正已经有了解决方案，不管了。

db2clpex <clp command line>
 ie. db2clpex DB2 -z c:/log.txt -tvf c:/batch.clp