在linux用静默方式安装iq 15.2

〇〇 · 发表于 2011-2-7 14:27

sybase iq 对日期的处理方式与众不同，费了不少时间修改查询脚本

〇〇 · 发表于 2011-2-7 15:08

表现一般，对日期取年份的3个查询789较慢
一个sql文件包含多个语句，貌似只执行最后1个，只好单独执行，22不知如何修改
语法改成下面的还是出错
中文支持不佳，错误提示乱码
第10个诡异的错误
(DBA)> read /user1/app/tpch10
C_CUSTKEY C_NAME                   REVENUE                                  C_ACCTBAL       N_NAME                   C_ADDRES
S                               C_PHONE       C_COMMENT

------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------
----------------------------------
There was an error reading the results of the SQL statement.
  The displayed results may be incorrect or incomplete.
  Hash Insert thrashing detected at Node #6: rolling back.
  --
  (dfjo_Hash.cxx 1195)
  SQLCODE=-1001047, ODBC 3 State="HY000"

(0 rows)

Execution time: 184.532 seconds

(DBA)> select substring('aaabb',3,2);
substring('aaabb',3,2)
----------------------
ab

（1 行）

执行时间: 0.005 秒
  sybase152
01(4 rows)Execution time: 98.357 seconds
02(10 rows)Execution time: 8.137 seconds
03(10 rows)Execution time: 31.214 seconds
04(5 rows)Execution time: 12.433 seconds
05(5 rows)Execution time: 174.12 seconds
06(1 rows)Execution time: 2.068 seconds
07(4 rows)Execution time: 11.891 seconds
08(2 rows)Execution time: 78.905 seconds
09(10 rows)Execution time: 127.545 seconds
10*
11(0 rows)Execution time: 1.957 seconds
12(2 rows)Execution time: 10.199 seconds
13(10 rows)Execution time: 23.218 seconds
14(1 rows)Execution time: 2.66 seconds
15**
16(10 rows)Execution time: 5.738 seconds
17(1 rows)Execution time: 79.959 seconds
18(10 rows)Execution time: 34.495 seconds
19(1 rows)Execution time: 5.634 seconds
20(10 rows)Execution time: 16.862 seconds
21(10 rows)Execution time: 172.829 seconds
22***

(DBA)> read /user1/app/tpch15a
无法执行语句。
  ????????????±í 'REVENUE0'
  SQLCODE=-141，ODBC 3 状态="42S02"
  文件: 第 7 行第 1 列的 "tpch15a.sql"
  SELECT top 10
      S_SUPPKEY,
      S_NAME,
      S_ADDRESS,
      S_PHONE,
  ...
  您可以继续执行或停止。
1. 停止(S)
2. 继续(O)
请选择选项: 1

(DBA)> read /user1/app/tpch15b
执行时间: 0.013 秒

(DBA)> read /user1/app/tpch15a
S_SUPPKEY S_NAME                   S_ADDRESS                               S_PHONE       TOTAL_REVENUE
----------------------------------------------------------------------------------------------------------------------------------------
18895    Supplier#000018895       IfdWdHbljSZYKvQffVI b                   24-596-385-3044 2100645.6801

（1 行）

执行时间: 6.345 秒

cliser · 发表于 2011-2-7 18:06

在tpch库中，请问iq的内存，您是怎么配置的？-iqmc和iqtc设置多大？能否贴出sql查询计划？

第22个查询：
select
cntrycode,
count(*) as numcust,
sum(c_acctbal) as totacctbal
from
(
select
substring(c_phone,1,2) as cntrycode,
c_acctbal
from
customer
where
substring(c_phone,1,2) in
('13', '31', '23', '29', '30', '18', '17')
and c_acctbal > (
select
avg(c_acctbal)
from
customer
where
c_acctbal > 0.00
and substring(c_phone,1,2) in
('13', '31', '23', '29', '30', '18', '17')
)
and not exists (
select
*
from
orders
where
o_custkey = c_custkey
)
) as custsale
group by
cntrycode
order by
cntrycode;

[ 本帖最后由 cliser 于 2011-2-7 18:26 编辑 ]

〇〇 · 发表于 2011-2-7 20:40

关坏了

[root@redflag11012601 ~]# stop_iq

Checking system ...

The following 1 server(s) are owned by 'root'

## Owner       PID Started  CPU Time  Additional Information
-- ---------  -------  --------  --------  ------------------------------------
1: root       30770    Feb06  01:07:01
            /opt/sybase/IQ-15_2/bin64/iqsrv15 @iqdemo.cfg iqdemo.db -ti 4400 -gn 25 -o /opt/sybase/IQ-15_2/logfiles/redflag11012601_iqdemo.0001.srvlog -hn 9
--

      Please note that 'stop_iq' will shut down a server completely
      without regard for users, connections, or load process status.
      For more control, use the 'dbstop' utility, which has options
      that control stopping servers based on active connections.

Do you want to stop the server displayed above <Y/N>? Y

Shutting down server (30770) ...
Checkpointing server (30770) ...
Server shutdown.

[root@redflag11012601 ~]# cp /opt/sybase/IQ-15_2/demo/iqdemo.cfg /opt/sybase/IQ-15_2/demo/iqdemo.cfg.org
[root@redflag11012601 ~]# vi /opt/sybase/IQ-15_2/demo/iqdemo.cfg

# iqdemo.cfg
# ------------------------------------------------------------
# Default startup parameters for the ASIQ demo database
# ------------------------------------------------------------

-n  redflag11012601_iqdemo
-x  tcpip{port=2638}

# The following parameters are also found in the configuration file
# /opt/sybase/IQ-15_2/scripts/default.cfg.  Any parameters not specified below
# and not in the start up parameter list, will be added by start_iq
# using default.cfg as a guide.

-c  348m
-gc 120
-gd all
-gl all
-gm 510
-gp 4096

-iqmc 32768
-iqtc 24576
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"/opt/sybase/IQ-15_2/demo/iqdemo.cfg" 22L, 572C 已写入
[root@redflag11012601 ~]# cat /opt/sybase/IQ-15_2/demo/iqdemo.cfg
# iqdemo.cfg
# ------------------------------------------------------------
# Default startup parameters for the ASIQ demo database
# ------------------------------------------------------------

-n  redflag11012601_iqdemo
-x  tcpip{port=2638}

# The following parameters are also found in the configuration file
# /opt/sybase/IQ-15_2/scripts/default.cfg.  Any parameters not specified below
# and not in the start up parameter list, will be added by start_iq
# using default.cfg as a guide.

-c  348m
-gc 120
-gd all
-gl all
-gm 510
-gp 4096

-iqmc 32768
-iqtc 24576
[root@redflag11012601 ~]# start_iq @iqdemo.cfg iqdemo.db

Starting server  on redflag11012601 at port  (02/07 19:43:24)

Run Directory    : /root
Server Executable : /opt/sybase/IQ-15_2/bin64/iqsrv15
Server Output Log : /opt/sybase/IQ-15_2/logfiles/.0004.srvlog
Server Version    : 15.2.0.5604/GA
Open Client Version : 15.0/P-EBF16082 ESD #15
User Parameters    : '@iqdemo.cfg' 'iqdemo.db'
Default Parameters  : -c 48m -gc 20 -gd all -gl all -gm 10 -gp 4096 -ti 4400 -gn 25

DBSPAWN 错误: -81
无效的数据库服务器命令行

Server failed to start (Return Code 1)

[root@redflag11012601 ~]# cat /opt/sybase/IQ-15_2/demo/iqdemo.cfg.org
# iqdemo.cfg
# ------------------------------------------------------------
# Default startup parameters for the ASIQ demo database
# ------------------------------------------------------------

-n  redflag11012601_iqdemo
-x  tcpip{port=2638}

# The following parameters are also found in the configuration file
# /opt/sybase/IQ-15_2/scripts/default.cfg.  Any parameters not specified below
# and not in the start up parameter list, will be added by start_iq
# using default.cfg as a guide.

-c  48m
-gc 20
-gd all
-gl all
-gm 10
-gp 4096

-iqmc 32
-iqtc 24
[root@redflag11012601 ~]# start_iq @iqdemo.cfg.org  iqdemo.db

Starting server  on redflag11012601 at port  (02/07 19:47:44)

Run Directory    : /root
Server Executable : /opt/sybase/IQ-15_2/bin64/iqsrv15
Server Output Log : /opt/sybase/IQ-15_2/logfiles/.0005.srvlog
Server Version    : 15.2.0.5604/GA
Open Client Version : 15.0/P-EBF16082 ESD #15
User Parameters    : '@iqdemo.cfg.org' 'iqdemo.db'
Default Parameters  : -c 48m -gc 20 -gd all -gl all -gm 10 -gp 4096 -ti 4400 -gn 25

DBSPAWN 错误: -81
无效的数据库服务器命令行

Server failed to start (Return Code 1)

[root@redflag11012601 ~]# start_iq iqdemo.db

Starting server  on redflag11012601 at port  (02/07 19:49:27)

Run Directory    : /root
Server Executable : /opt/sybase/IQ-15_2/bin64/iqsrv15
Server Output Log : /opt/sybase/IQ-15_2/logfiles/.0006.srvlog
Server Version    : 15.2.0.5604/GA
Open Client Version : 15.0/P-EBF16082 ESD #15
User Parameters    : 'iqdemo.db'
Default Parameters  : -c 48m -gc 20 -gd all -gl all -gm 10 -gp 4096 -ti 4400 -gn 25

DBSPAWN 错误: -83
未找到指定的数据库
I. 02/07 19:49:29。    Sybase IQ
I. 02/07 19:49:29。    15.2 版
I. 02/07 19:49:29。    （64 位模式）
I. 02/07 19:49:29。版权所有 1992-2010 Sybase, Inc. 保留所有权利
I. 02/07 19:49:29。
I. 02/07 19:49:29。检测到 8 个物理处理器。
I. 02/07 19:49:29。服务器将使用的物理处理器的最大数量: 8
I. 02/07 19:49:29。在 Linux 2.6.18-194.1.AXS3 #1 SMP Fri May 7 10:03:53 CST 2010 上运行 X86_64
I. 02/07 19:49:29。为 X86_64 处理器体系结构建立的服务器
I. 02/07 19:49:29。49152K 内存已用于高速缓存
I. 02/07 19:49:29。最小高速缓存大小: 49152K，最大高速缓存大小: 262144K
I. 02/07 19:49:29。使用 4096 字节的最大页面大小
E. 02/07 19:49:29。无法访问 "iqdemo.db": 文件不存在
I. 02/07 19:49:29。数据库服务器因启动错误而关闭
I. 02/07 19:49:29。数据库服务器在 Mon Feb 07 2011 19:49 停止

Ｎ薹ǚ梦?"iqdemo.db": 文件不存在
Server failed to start

[root@redflag11012601 ~]# mv /opt/sybase/IQ-15_2/demo/iqdemo.cfg /opt/sybase/IQ-15_2/demo/iqdemo.cfg.bad
[root@redflag11012601 ~]# mv /opt/sybase/IQ-15_2/demo/iqdemo.cfg.org /opt/sybase/IQ-15_2/demo/iqdemo.cfg
[root@redflag11012601 ~]# start_iq @iqdemo.cfg iqdemo.db

Starting server  on redflag11012601 at port  (02/07 20:35:40)

Run Directory    : /root
Server Executable : /opt/sybase/IQ-15_2/bin64/iqsrv15
Server Output Log : /opt/sybase/IQ-15_2/logfiles/.0007.srvlog
Server Version    : 15.2.0.5604/GA
Open Client Version : 15.0/P-EBF16082 ESD #15
User Parameters    : '@iqdemo.cfg' 'iqdemo.db'
Default Parameters  : -c 48m -gc 20 -gd all -gl all -gm 10 -gp 4096 -ti 4400 -gn 25

DBSPAWN 错误: -81
无效的数据库服务器命令行

Server failed to start (Return Code 1)

[root@redflag11012601 ~]# tail /opt/sybase/IQ-15_2/logfiles/.0007.srvlog

[root@redflag11012601 ~]# head /opt/sybase/IQ-15_2/logfiles/redflag11012601_iqdemo.0001.srvlog

I. 02/06 14:40:47。    Sybase IQ
I. 02/06 14:40:47。    15.2 版
I. 02/06 14:40:47。    （64 位模式）
I. 02/06 14:40:47。版权所有 1992-2010 Sybase, Inc. 保留所有权利
I. 02/06 14:40:47。
I. 02/06 14:40:47。检测到 8 个物理处理器。
I. 02/06 14:40:47。服务器将使用的物理处理器的最大数量: 8
I. 02/06 14:40:47。在 Linux 2.6.18-194.1.AXS3 #1 SMP Fri May 7 10:03:53 CST 2010 上运行 X86_64
I. 02/06 14:40:47。为 X86_64 处理器体系结构建立的服务器
[root@redflag11012601 ~]# tail /opt/sybase/IQ-15_2/logfiles/redflag11012601_iqdemo.0001.srvlog
I. 02/07 19:21:10。在 Mon Feb 07 2011 19:21 启动检查点 "iqdemo" (iqdemo.db)
I. 02/07 19:21:10。在 Mon Feb 07 2011 19:21 完成了 "iqdemo" (iqdemo.db) 的检查点
I. 02/07 19:27:50。在 Mon Feb 07 2011 19:27 启动检查点 "iqdemo" (iqdemo.db)
I. 02/07 19:27:50。在 Mon Feb 07 2011 19:27 完成了 "iqdemo" (iqdemo.db) 的检查点
I. 02/07 19:34:31。在 Mon Feb 07 2011 19:34 启动检查点 "iqdemo" (iqdemo.db)
I. 02/07 19:34:31。在 Mon Feb 07 2011 19:34 完成了 "iqdemo" (iqdemo.db) 的检查点
I. 02/07 19:35:38。数据库服务器因 HUP 信号而关闭
I. 02/07 19:35:38。在 Mon Feb 07 2011 19:35 启动检查点 "iqdemo" (iqdemo.db)
I. 02/07 19:35:38。在 Mon Feb 07 2011 19:35 完成了 "iqdemo" (iqdemo.db) 的检查点
I. 02/07 19:35:39。数据库服务器在 Mon Feb 07 2011 19:35 停止
[root@redflag11012601 ~]#

〇〇 · 发表于 2011-2-7 20:44

原来是路径问题

[root@redflag11012601 ~]# cd /opt/sybase/IQ-15_2/demo/
[root@redflag11012601 demo]# start_iq @iqdemo.cfg.bad iqdemo.db

Starting server redflag11012601_iqdemo on redflag11012601 at port 2638 (02/07 20:42:52)

Run Directory    : /opt/sybase/IQ-15_2/demo
Server Executable : /opt/sybase/IQ-15_2/bin64/iqsrv15
Server Output Log : /opt/sybase/IQ-15_2/logfiles/redflag11012601_iqdemo.0002.srvlog
Server Version    : 15.2.0.5604/GA
Open Client Version : 15.0/P-EBF16082 ESD #15
User Parameters    : '@iqdemo.cfg.bad' 'iqdemo.db'
Default Parameters  : -ti 4400 -gn 515

I. 02/07 20:42:54。    Sybase IQ
I. 02/07 20:42:54。    15.2 版
I. 02/07 20:42:54。    （64 位模式）
I. 02/07 20:42:54。版权所有 1992-2010 Sybase, Inc. 保留所有权利
I. 02/07 20:42:54。
I. 02/07 20:42:54。检测到 8 个物理处理器。
I. 02/07 20:42:54。服务器将使用的物理处理器的最大数量: 8
I. 02/07 20:42:54。在 Linux 2.6.18-194.1.AXS3 #1 SMP Fri May 7 10:03:53 CST 2010 上运行 X86_64
I. 02/07 20:42:54。为 X86_64 处理器体系结构建立的服务器
I. 02/07 20:42:54。356352K 内存已用于高速缓存
I. 02/07 20:42:54。最小高速缓存大小: 356352K，最大高速缓存大小: 356352K
I. 02/07 20:42:54。使用 4096 字节的最大页面大小
I. 02/07 20:42:54。在 Mon Feb 07 2011 20:42 启动数据库 "iqdemo" (/opt/sybase/IQ-15_2/demo/iqdemo.db)

=============================================================
IQ server starting with:
510 connections       (    -gm )
   26 cmd resources    ( -iqgovern )
955 threads          (    -iqmt )
512 Kb thread stack size ( -iqtss  )
  488960 Kb thread memory size ( -iqmt * -iqtss )
   8 IQ number of cpus  ( -iqnumbercpus )
   0 MB maximum size of IQMSG file ( -iqmsgsz )
   0 copies of IQMSG file archives ( -iqmsgnum )
=============================================================

I. 02/07 20:42:55。事务日志: iqdemo.log
I. 02/07 20:42:55。在 Mon Feb 07 2011 20:42 启动检查点 "iqdemo" (iqdemo.db)
I. 02/07 20:42:55。在 Mon Feb 07 2011 20:42 完成了 "iqdemo" (iqdemo.db) 的检查点
I. 02/07 20:42:55。数据库 "iqdemo" (iqdemo.db) 在 Mon Feb 07 2011 20:42 启动
I. 02/07 20:42:55。IQ Server redflag11012601_iqdemo.
I. 02/07 20:42:55。数据库服务器在 Mon Feb 07 2011 20:42 启动
I. 02/07 20:42:55。正在尝试启动 SharedMemory 链接...
I. 02/07 20:42:55。 SharedMemory 链接已成功启动
I. 02/07 20:42:55。正在尝试启动 TCPIP 链接...
I. 02/07 20:42:55。正在端口 2638 启动
新的进程 ID 是 14870
I. 02/07 20:43:00。 TCPIP 链接已成功启动
I. 02/07 20:43:00。立即接受请求

Server started successfully

[root@redflag11012601 demo]#

〇〇 · 发表于 2011-2-7 21:02

谢谢cliser

修改缓存后果然提高很大

[root@redflag11012601 ~]# cd /opt/sybase/IQ-15_2/demo/
[root@redflag11012601 demo]# start_iq @iqdemo.cfg.bad iqdemo.db

Starting server redflag11012601_iqdemo on redflag11012601 at port 2638 (02/07 20:42:52)

Run Directory    : /opt/sybase/IQ-15_2/demo
Server Executable : /opt/sybase/IQ-15_2/bin64/iqsrv15
Server Output Log : /opt/sybase/IQ-15_2/logfiles/redflag11012601_iqdemo.0002.srvlog
Server Version    : 15.2.0.5604/GA
Open Client Version : 15.0/P-EBF16082 ESD #15
User Parameters    : '@iqdemo.cfg.bad' 'iqdemo.db'
Default Parameters  : -ti 4400 -gn 515

I. 02/07 20:42:54。    Sybase IQ
I. 02/07 20:42:54。    15.2 版
I. 02/07 20:42:54。    （64 位模式）
I. 02/07 20:42:54。版权所有 1992-2010 Sybase, Inc. 保留所有权利
I. 02/07 20:42:54。
I. 02/07 20:42:54。检测到 8 个物理处理器。
I. 02/07 20:42:54。服务器将使用的物理处理器的最大数量: 8
I. 02/07 20:42:54。在 Linux 2.6.18-194.1.AXS3 #1 SMP Fri May 7 10:03:53 CST 2010 上运行 X86_64
I. 02/07 20:42:54。为 X86_64 处理器体系结构建立的服务器
I. 02/07 20:42:54。356352K 内存已用于高速缓存
I. 02/07 20:42:54。最小高速缓存大小: 356352K，最大高速缓存大小: 356352K
I. 02/07 20:42:54。使用 4096 字节的最大页面大小
I. 02/07 20:42:54。在 Mon Feb 07 2011 20:42 启动数据库 "iqdemo" (/opt/sybase/IQ-15_2/demo/iqdemo.db)

=============================================================
IQ server starting with:
510 connections       (    -gm )
   26 cmd resources    ( -iqgovern )
955 threads          (    -iqmt )
512 Kb thread stack size ( -iqtss  )
  488960 Kb thread memory size ( -iqmt * -iqtss )
   8 IQ number of cpus  ( -iqnumbercpus )
   0 MB maximum size of IQMSG file ( -iqmsgsz )
   0 copies of IQMSG file archives ( -iqmsgnum )
=============================================================

I. 02/07 20:42:55。事务日志: iqdemo.log
I. 02/07 20:42:55。在 Mon Feb 07 2011 20:42 启动检查点 "iqdemo" (iqdemo.db)
I. 02/07 20:42:55。在 Mon Feb 07 2011 20:42 完成了 "iqdemo" (iqdemo.db) 的检查点
I. 02/07 20:42:55。数据库 "iqdemo" (iqdemo.db) 在 Mon Feb 07 2011 20:42 启动
I. 02/07 20:42:55。IQ Server redflag11012601_iqdemo.
I. 02/07 20:42:55。数据库服务器在 Mon Feb 07 2011 20:42 启动
I. 02/07 20:42:55。正在尝试启动 SharedMemory 链接...
I. 02/07 20:42:55。 SharedMemory 链接已成功启动
I. 02/07 20:42:55。正在尝试启动 TCPIP 链接...
I. 02/07 20:42:55。正在端口 2638 启动
新的进程 ID 是 14870
I. 02/07 20:43:00。 TCPIP 链接已成功启动
I. 02/07 20:43:00。立即接受请求

Server started successfully

[root@redflag11012601 demo]# dbisql -c "uid=dba;pwd=sql;eng=redflag11012601_iqdemo" -nogui

(DBA)> read /user1/app/tpch01
L_RETURNFLAG L_LINESTATUS SUM_QTY                SUM_BASE_PRICE          SUM_DISC_PRICE                         SUM_CHARGE                                              AVG_QTY                                     AVG_PRICE                                     AVG_DISC                                     COUNT_ORDER
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
A          F          377518399.00             566065727797.25          537759104278.0656                      559276670892.116819                                     25.50097510300709730164197                   38237.15100895854567630254827                0.05000657454024320462532                   14804077
N          F          9851614.00             14767438399.17          14028805792.2114                         14590490998.366737                                     25.52244830284094736242156                   38257.81066008114031678920616                0.04997336773765667179622                   385998
N          O          733123780.00             1099304906498.07       1044335077295.6306                      1086120726300.933136                                     25.49752487962626730952243                   38233.04463501343158807491862                0.04999940144841137417741                   28752743
R          F          377732830.00             566431054976.00          538110922664.7677                      559634780885.086257                                     25.50838478968013833972743                   38251.21927355976084304198563                0.04999679231408742044854                   14808183

（4 行）

执行时间: 14.278 秒

(DBA)> read /user1/app/tpch02
S_ACCTBAL       S_NAME                   N_NAME                   P_PARTKEY P_MFGR                   S_ADDRESS                               S_PHONE       S_COMMENT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
9999.21          Supplier#000081559       IRAQ                   756551    Manufacturer#1          YplAwJxhoHNeIyqDv3kgzv x2dymRYx       21-345-604-7861 bold packages cajole blithely pinto beans. carefully special
9994.67          Supplier#000048146       EGYPT                   1573100    Manufacturer#4          uq4pbng1m ,bHziSHWDqTi0mOSiqCn          14-860-865-5070 iously bold excuses x-ray evenly. even, regular accounts are daringly. even, ironic pack
9994.10          Supplier#000047385       SAUDI ARABIA             722377    Manufacturer#3          pbRKuJaBXBl,5bOv9UhB8SDR cuz 8          30-427-545-5707 nic dependencies nag fluffily across the blithely special foxes. furiously silent deposit
9993.98          Supplier#000044588       IRAN                   644587    Manufacturer#1          6ngm52IsynVhNvng3WcsklhC5q             20-744-248-3365 l gifts. regular, final depos
9991.67          Supplier#000044257       EGYPT                   294252    Manufacturer#5          j1EpaDRhzjUzsAlrOhKsPGjH3ZDkADsZff    14-247-888-5033 accounts: furiously ironic deposits wake quickl
9991.00          Supplier#000009966       IRAN                   1634917    Manufacturer#1          f7UB YWpwxkecW40I07kFYA9Ytnwg          20-100-554-8091 ts haggle quietly. quickly regular patterns cajole regular, bold pinto beans. excuses so
9989.63          Supplier#000059340       SAUDI ARABIA             709325    Manufacturer#3          YMtHuz2B0Kbf 55RoaKTIV,gENgg1KEnBlNF    30-638-385-6121 furiously silent courts. slyly pending pinto beans haggle. ev
9988.54          Supplier#000058678       IRAN                   1233665    Manufacturer#5          a99NyaA2,tkvFZl,B38W6tLG0MgB1z7QUBT7NEs  20-836-702-5861 fluffily special requests sleep fluffily. platelets
9987.33          Supplier#000019289       SAUDI ARABIA             1369262    Manufacturer#2          GfvMke994gcpiYKqYjE7f3xTMTSlKLQO3pwavsSk 30-178-276-8355 o the quickly silent requests cajole furiously according to the
9985.28          Supplier#000015471       JORDAN                   590465    Manufacturer#4          KkxpZ4X9ZvrUTzWnoKNdJlyT7CHM          23-910-981-9900 sual deposits should are furiously furiously bold foxes--

（10 行）

执行时间: 5.803 秒

(DBA)> read /user1/app/tpch03
L_ORDERKEY  REVENUE                                  O_ORDERDATE O_SHIPPRIORITY
--------------------------------------------------------------------------------
45428128 447475.7806                            1995-02-09  0
54341126 433150.2614                            1995-03-11  0
34026084 427506.4113                            1995-03-12  0
51780900 424669.2294                            1995-03-06  0
2160291    423756.2783                            1995-03-18  0
33596868 422720.3699                            1995-02-02  0
36874080 416533.9131                            1995-03-22  0
59467682 414953.3259                            1995-01-26  0
49723591 414763.1045                            1995-03-13  0
34400391 414330.1070                            1995-03-16  0

（10 行）

执行时间: 5.538 秒

(DBA)> read /user1/app/tpch04
O_ORDERPRIORITY ORDER_COUNT
------------------------------------
1-URGENT       105410
2-HIGH       105334
3-MEDIUM       104993
4-NOT SPECIFIED 105168
5-LOW          105034

（5 行）

执行时间: 3.365 秒

(DBA)> read /user1/app/tpch05
N_NAME                   REVENUE
-------------------------------------------------------------------
MOROCCO                540038731.8977
KENYA                   536052927.7305
ETHIOPIA                520384942.7652
MOZAMBIQUE             520109603.6710
ALGERIA                519498315.2213

（5 行）

执行时间: 11.166 秒

(DBA)> read /user1/app/tpch06
REVENUE
----------------------------------------
895636948.8390

（1 行）

执行时间: 1.36 秒

(DBA)> read /user1/app/tpch07
SUPP_NATION             CUST_NATION             L_YEAR    REVENUE
---------------------------------------------------------------------------------------------------------
CHINA                   INDIA                   1995       539884881.2107
CHINA                   INDIA                   1996       530534048.7849
INDIA                   CHINA                   1995       539795028.3182
INDIA                   CHINA                   1996       540354168.0976

（4 行）

执行时间: 2.768 秒

(DBA)> read /user1/app/tpch08
O_YEAR    MKT_SHARE
-----------------------------------------------------------------------------------------------
1995       0.0374702321547545682017630054278820630774
1996       0.0398228503369259665501796762710272964208

（2 行）

执行时间: 7.207 秒

(DBA)> read /user1/app/tpch08
O_YEAR    MKT_SHARE
-----------------------------------------------------------------------------------------------
1995       0.0374702321547545682017630054278820630774
1996       0.0398228503369259665501796762710272964208

（2 行）

执行时间: 6.987 秒

(DBA)> read /user1/app/tpch09
NATION                   O_YEAR    SUM_PROFIT
----------------------------------------------------------------------------------
ALGERIA                1998       257238329.1579
ALGERIA                1997       431431688.8825
ALGERIA                1996       439000815.8198
ALGERIA                1995       440599567.4112
ALGERIA                1994       439263711.7631
ALGERIA                1993       435246558.5421
ALGERIA                1992       430292007.6740
ARGENTINA                1998       265125830.4923
ARGENTINA                1997       449246764.2741
ARGENTINA                1996       450732312.8905

（10 行）

执行时间: 13.902 秒

(DBA)> read /user1/app/tpch10
C_CUSTKEY C_NAME                   REVENUE                                  C_ACCTBAL       N_NAME                   C_ADDRESS                               C_PHONE       C_COMMENT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
361891    Customer#000361891       859221.0378                            3273.34          SAUDI ARABIA             wKPyClaA8FXzVmOE7OH68Cn ujxyP          30-105-377-1699 y unusual foxes against the deposits affix slyl
927328    Customer#000927328       788417.4868                            9945.26          JAPAN                   30q6Amp,lQg                            22-271-703-3829 sly final instructions are. slyly pending deposits haggle slyly. final dolphins since the ide
156019    Customer#000156019       784377.8833                            7762.50          KENYA                   7L26WVLAXK7GbxgSp 0VWF0oGE17          24-935-589-6925  special pinto beans nag. dolp
1367704    Customer#001367704       782901.1809                            4843.02          GERMANY                pzMZxFX37HvdGtN8HxZek4916XA7PlJlTQEi    17-358-626-1768 . blithely final somas nag qui
1116802    Customer#001116802       772560.7705                            772.17          JORDAN                   JpGQT3IHoogqB3ZMrSrzhBrVFObr          23-199-655-3770 ests. quickly ironic deposits along the special requests a
705604    Customer#000705604       771091.3207                            2551.13          ARGENTINA                FmxH89Z2Gz4L9pY6AHfo7U,3                11-760-333-8978 l ideas affix about the slyly final accounts. ideas haggle fur
909427    Customer#000909427       755162.5835                            8837.74          IRAN                   oJXjfKXPK,8qUUDwWViXC5tMcooD          20-484-919-7055 ilent, regular requests wake slyly regular pinto beans. slyly unusual reque
751294    Customer#000751294       749723.0605                            9740.35          UNITED STATES          5F2ineLPS2QGuZh                         34-217-742-7285 elets across the sly, special braids ha
871684    Customer#000871684       734706.0411                            753.52          VIETNAM                4rySemfILqIalTHd8IZ                   31-454-346-5315 es dazzle slyly around the furiously final packages. blithely express deposits sleep
365548    Customer#000365548       731459.5844                            7653.46          KENYA                   DoUESYrKsrcAkIoIxLSAQVxDl5qsz6dx2U5qy 24-489-592-4454 sts affix across the blithely regular somas. final, ironic theodolites wake. slyly f

（10 行）

执行时间: 15.6 秒

(DBA)> read /user1/app/tpch11
PS_PARTKEY  VALUE
----------------------------------------------

（0 行）

执行时间: 1.015 秒

(DBA)> read /user1/app/tpch12
L_SHIPMODE HIGH_LINE_COUNT    LOW_LINE_COUNT
----------------------------------------------------
AIR       62364             93578
FOB       62403             93310

（2 行）

执行时间: 2.855 秒

(DBA)> read /user1/app/tpch13
C_COUNT             CUSTDIST
-----------------------------------------
0                   500021
10                66157
9                   65243
11                62072
8                   58350
12                55821
13                49811
7                   46847
19                46641
18                46259

（10 行）

执行时间: 9.263 秒

(DBA)> read /user1/app/tpch14
PROMO_REVENUE
--------------------------------------------------------------------------------------
16.6071446356549153807981793093943028227551

（1 行）

执行时间: 1.194 秒

(DBA)> read /user1/app/tpch15a
S_SUPPKEY S_NAME                   S_ADDRESS                               S_PHONE       TOTAL_REVENUE
----------------------------------------------------------------------------------------------------------------------------------------
18895    Supplier#000018895       IfdWdHbljSZYKvQffVI b                   24-596-385-3044 2100645.6801

（1 行）

执行时间: 1.648 秒

(DBA)> read /user1/app/tpch16
P_BRAND P_TYPE                   P_SIZE    SUPPLIER_CNT
---------------------------------------------------------------------
Brand#55 ECONOMY BURNISHED NICKEL  21       104
Brand#32 LARGE BURNISHED NICKEL 25       100
Brand#14 LARGE PLATED BRASS       24       96
Brand#34 MEDIUM BRUSHED STEEL    23       96
Brand#11 STANDARD BRUSHED TIN    23       92
Brand#13 PROMO BRUSHED STEEL    7          92
Brand#22 LARGE PLATED TIN       24       92
Brand#23 ECONOMY BURNISHED BRASS 24       92
Brand#24 SMALL PLATED STEEL       17       92
Brand#31 STANDARD ANODIZED STEEL 24       92

（10 行）

执行时间: 1.837 秒

(DBA)> read /user1/app/tpch17
AVG_YEARLY
---------------------------
3181939.6457

（1 行）

执行时间: 32.503 秒

(DBA)> read /user1/app/tpch18
C_NAME                   C_CUSTKEY O_ORDERKEY  O_ORDERDATE O_TOTALPRICE    SUM(LINEITEM.L_QUANTITY)
---------------------------------------------------------------------------------------------------------
Customer#001287812       1287812    42290181 1997-11-26  558289.17       318.00
Customer#001172513       1172513    36667107 1997-06-06  550142.18       322.00
Customer#000571654       571654    21213895 1992-01-03  549380.08       327.00
Customer#000667882       667882    2199712    1996-09-30  542154.01       327.00
Customer#001471966       1471966    1263015    1997-02-02  540476.80       320.00
Customer#001101754       1101754    46794464 1992-04-28  532623.90       320.00
Customer#000591466       591466    55799200 1996-02-11  524209.45       327.00
Customer#001196317       1196317    34509573 1995-10-15  522897.01       318.00
Customer#000634048       634048    36327201 1992-04-25  519634.30       315.00
Customer#001308376       1308376    28077922 1996-10-27  518711.99       319.00

（10 行）

执行时间: 36.809 秒

(DBA)> read /user1/app/tpch19
REVENUE
-----------------------------------------
108438660.4735

（1 行）

执行时间: 4.434 秒

(DBA)> read /user1/app/tpch19
REVENUE
-----------------------------------------
108438660.4735

（1 行）

执行时间: 2.777 秒

(DBA)> read /user1/app/tpch20
S_NAME                   S_ADDRESS
------------------------------------------------------------------
Supplier#000000016       YjP5C55zHDXL7LalK27zfQnwejdpin4AMpvh
Supplier#000000139       2mQLQsVJ8WLBSnl0R bXrcyTgqXKrplgxb
Supplier#000000174       e1NMjwAq6RdyIKeA
Supplier#000000199       k,8F8FGDuN 3udblO
Supplier#000000311       yjGDnCKi4Wmtim H3n9p
Supplier#000000323       0LEOmcTTomY1F0y
Supplier#000000330       MUxmICc8xS41A
Supplier#000000331       VkdMTxXHy22069CWmK658
Supplier#000000408       qcor1u,vJXAokjnL5,dilyYNmh
Supplier#000000466       HEW3DIL,Aw0Ud

（10 行）

执行时间: 3.794 秒

(DBA)> read /user1/app/tpch21
S_NAME                   NUMWAIT
----------------------------------------------
Supplier#000010955       21
Supplier#000011842       21
Supplier#000042197       21
Supplier#000079330       21
Supplier#000091300       21
Supplier#000011184       20
Supplier#000016757       20
Supplier#000025245       20
Supplier#000034129       20
Supplier#000052664       20

（10 行）

执行时间: 25.926 秒

(DBA)> put tpch22a.sql
无法执行语句。
  ???????????????????? 'put'
  SQLCODE=-265，ODBC 3 状态="42S02"
  第 1 行，第 1 列
  put tpch22a.sql
按 ENTER 键可继续...

(DBA)> read /user1/app/tpch22a
CNTRYCODE NUMCUST             TOTACCTBAL
-------------------------------------------------------
12       9050                67863719.22
13       9026                67597464.64
17       9071                68104650.88
27       9017                67655904.30
29       9203                69035427.65
32       9107                68445187.26
34       9130                68395221.91

（7 行）

执行时间: 4.927 秒

(DBA)>