DPF环境下链接问题
目前准备测试DPF环境，前期准备是双机4节点，每台机器上2个节点。 现在测试环境已经搭建起来。 我看 infocenter上面介绍上默认连接到node 0 节点。但是我在测试的时候发现我的四个节点上面都存在连接。
望各路大侠帮忙解惑：
1：为什么应该默认连接node 0， 我其他的三个节点还有连接在上面呢。 DPF的数据源应该怎么配置，需要注意什么？
2：DPF环境中，用户发起了SQL请求，数据库处理机制是什么样的？
3：DPF环境，各个节点中查出来的数据是否都需要通过协调节点来进行排序然后返回给用户，那如果这样，协调节点的sortheap就是需要大于其他的节点？
4：DPF环境中，如果一个查询业务逻辑特别复杂，需要join10几张表，那么各个节点之间的数据交互的时间该怎么评估？
/CatchF761(09-02-14-54-21).jpg)
望各路大侠帮忙解惑：
1：为什么应该默认连接node 0， 我其他的三个节点还有连接在上面呢。 DPF的数据源应该怎么配置，需要注意什么？
2：DPF环境中，用户发起了SQL请求，数据库处理机制是什么样的？
3：DPF环境，各个节点中查出来的数据是否都需要通过协调节点来进行排序然后返回给用户，那如果这样，协调节点的sortheap就是需要大于其他的节点？
4：DPF环境中，如果一个查询业务逻辑特别复杂，需要join10几张表，那么各个节点之间的数据交互的时间该怎么评估？
7 同行回答
回复 5# 匪徒易真
这么难的问题还是一个一个问吧:P
先针对你的标题问题吧
你先品味下下面的例子（在我的test系统上做的）:
标红的地方是重点
[db2inst1@s3 ~]$ db2start
09/06/2015 15:39:00 1 0 SQL1063N DB2START processing was successful.
09/06/2015 15:39:02 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[db2inst1@s3 ~]$ db2 connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 10.5.5
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
[db2inst1@s3 ~]$ db2_all "db2 list applications"
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2bp 53 *N0.db2inst1.150906153930 SAMPLE 1
s3: db2 list applications completed ok
SQL1611W No data was returned by Database System Monitor.
s3: db2 list applications completed rc=2
[db2inst1@s3 ~]$ db2 "SELECT count(*) from employee"
1
-----------
42
1 record(s) selected.
[db2inst1@s3 ~]$ db2_all "db2 list applications"
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2bp 53 *N0.db2inst1.150906153930 SAMPLE 2
s3: db2 list applications completed ok
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2bp 53 *N0.db2inst1.150906153930 SAMPLE 1
s3: db2 list applications completed ok
收起
这么难的问题还是一个一个问吧:P
先针对你的标题问题吧
你先品味下下面的例子（在我的test系统上做的）:
标红的地方是重点
[db2inst1@s3 ~]$ db2start
09/06/2015 15:39:00 1 0 SQL1063N DB2START processing was successful.
09/06/2015 15:39:02 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[db2inst1@s3 ~]$ db2 connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 10.5.5
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
[db2inst1@s3 ~]$ db2_all "db2 list applications"
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2bp 53 *N0.db2inst1.150906153930 SAMPLE 1
s3: db2 list applications completed ok
SQL1611W No data was returned by Database System Monitor.
s3: db2 list applications completed rc=2
[db2inst1@s3 ~]$ db2 "SELECT count(*) from employee"
1
-----------
42
1 record(s) selected.
[db2inst1@s3 ~]$ db2_all "db2 list applications"
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2bp 53 *N0.db2inst1.150906153930 SAMPLE 2
s3: db2 list applications completed ok
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2bp 53 *N0.db2inst1.150906153930 SAMPLE 1
s3: db2 list applications completed ok
收起
for connections, 用
db2_all “。。。”
or
export DB2NODE=n
db2 terminate
...
才给出应该的结果
另外， IBM文档像天书一样，自己绕的都不知道在说什么
http://www-01.ibm.com/support/kn ... _9.7.0%2F3-6-2-4-62
“
AT DBPARTITIONNUM db-partition-number
Specifies the database partition for which the status of the monitor switches is to be displayed.
”
I tend to think it is both programming and documentation bug. 收起
db2_all “。。。”
or
export DB2NODE=n
db2 terminate
...
才给出应该的结果
另外， IBM文档像天书一样，自己绕的都不知道在说什么
http://www-01.ibm.com/support/kn ... _9.7.0%2F3-6-2-4-62
“
AT DBPARTITIONNUM db-partition-number
Specifies the database partition for which the status of the monitor switches is to be displayed.
”
I tend to think it is both programming and documentation bug. 收起