http://www.ibm.com/developerworks/data/library/techarticle/dm-1011reopt/   REOPT is a bind option for IBM® DB2® for Linux®, UNIX®, and Windows® that influences the optimizer to re-optimize so that it can consider values passed to the applic...(more)

DB2中的prepare和bind(转) 要解释这些还关系到好几个概念呢: 1. 动态SQL和静态SQL：在程序运行的时候才能确定执行计划的SQL是动态的；在程序编译的时候就已经可能知道执行计划的是静态的 2. prep/precompile：不要把prep看成是prepare了，这里是预编译 3. 嵌入式SQL：这个就没办...(more)

CATALOG DB ON MVS ############# db2 catalog tcpip node stf1q remote stfmvs1q.pok.ibm.com server 5010 ostype os390db2 catalog dcs database adw as USIBMVRDP2Hdb2 catalog database adw at node stf1q authentication server_encryptdb2 connect to adw user co...(more)