db2licm -l
Product name: "DB2 Advanced Enterprise Server Edition"
License type: "Terabyte"
Expiry date: "Permanent"
Product identifier: "db2aese"
Version information: "10.5"
Enforcement policy: "Soft Stop"
数据库启动后， 列表数据访问很慢 （1分钟）， 行表数据访问正常（1秒钟）， count 倒是很快。
行表
>># time db2 "select * from richard.CMRM_PROD_DIM_Rfetch first 10 rows only with ur"
10 record(s) selected.
real 0m0.09s
user 0m0.01s
sys 0m0.00s
列表
>># time db2 "select * from richard.CMRM_PROD_DIM fetch first 10 rows only with ur"
10 record(s) selected.
real 0m50.76s
user 0m0.00s
sys 0m0.01s
行表
>># time db2 "select count(1) from richard.CMRM_PROD_DIM_R with ur"
1
-----------
11075304
1 record(s) selected.
real 3m34.39s
user 0m0.01s
sys 0m0.01s
列表
>># time db2 "select count(1) from richard.CMRM_PROD_DIM with ur"
1
-----------
11075304
1 record(s) selected.
real 0m0.39s
user 0m0.00s
sys 0m0.00s
收起