至于结果，可以自己研究一下。
[@more@]1) update MINCOMMIT to 25 and recycle the instance
$ db2 get db cfg for sample|grep -i COM
Group commit count (MINCOMMIT) = 25
2) prepare following shell
$ more test.sh
db2 "update command options using c off"
db2 connect to sample
i=0
db2 "select current timestamp from sysibm.sysdummy1"
while [ $i -lt 25 ]
do
db2 "insert into t1 values ($i)"
db2 commit
let i=i+1
done
db2 "select current timestamp from sysibm.sysdummy1"
db2 connect reset
db2 "update command options using c on"
3) execute shell
$ sh test.sh
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.
Database Connection Information
Database server = DB2/AIX64 8.2.5
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
1
--------------------------
2007-12-24-15.41.14.673927
1 record(s) selected.
DB20000I The SQL command completed successfully.
......
DB20000I The SQL command completed successfully.
1
--------------------------
2007-12-24-15.41.15.924833
1 record(s) selected.
DB20000I The SQL command completed successfully.
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8481986/viewspace-995638/ ，如需转载，请注明出处，否则将追究法律责任。
