V10.5 通过命令行直接连接数据库还比较快,通过脚本形式连接数据库较慢,db2diag.log没有报错等信息,这是什么原因?
通过命令行直接连接数据库还比较快具体如下所示: db2 connect to $DBNAME user $DBUSER using $DBPASS;
Database Connection Information
Database server = DB2/AIX64 10.5.2
SQL authorization ID = CBSSTD
Local database alias = CBSSTD
real 0m1.64s
user 0m0.00s
sys 0m0.00s
通过脚本形式连接数据库较慢,具体如下:
vi sql
$ vi sql
db2 connect to $DBNAME user $DBUSER using $DBPASS;
$ sql
Database Connection Information
Database server = DB2/AIX64 10.5.2
SQL authorization ID = CBSSTD
Local database alias = CBSSTD
real 0m6.98s
user 0m0.00s
sys 0m0.01s
附件:
trcrpt.out (6.3 MB)
收起