通过TCP / IP问题连接到DB2 [英] CONNECT TO DB2 VIA TCP/IP PROBLEM
问题描述
您好，
这已经发布了几次，但我找不到通过
连接到我们的数据库的方法。我们使用XP
客户端在WIN2K服务器上运行DB2 Express。我可以通过
服务器在网络内部和Internet上ping，因此TCP / IP就可以了。 DB2COMM = TCPIP也被设置了。
现在已经好几天了。
这里有一些额外的数据（我们正在运行SAP业务一）：
数据库管理器配置
节点类型=具有本地和远程客户端的数据库服务器
数据库管理器配置发布级别= 0x0a00
打开的最大文件总数（MAXTOTFILOP）= 16000
CPU速度（毫秒/指令）（CPUSPEED）=
6.101113e-007
最大并发活动数据库数（NUMDB）= 6
数据链接支持（DATALINKS）=否
联合数据库系统支持（FEDERATED）=否
交易处理器监控名称（TP_MON_NAME）=
默认退款帐户（DFT_ACCOUNT_STR）=
Java开发套件安装路径（JDK_PATH）= E：\Program
Files \\ IBM \ SQLLIB\java\jdk
诊断错误捕获级别（DIAGLEVEL）= 3
通知级别（NOTIFYLEVEL）= 2
诊断数据目录路径（DIAGPATH）=
默认数据库监视器开关
缓冲池（DFT_MON_BUFPOOL）= OFF
锁定（DFT_MON_LOCK）= OFF < br $>
排序（DFT_MON_SORT）= OFF
对帐单（DFT_MON_STMT）= OFF
表（DFT_MON_TABLE）= OFF
时间戳（DFT_MON_TIMESTAMP）= ON
工作单元（DFT_MON_UOW）= OFF
监控实例和数据库的运行状况（HEALTH_MON）= ON
SYSADM组name（SYSADM_GROUP）=
SYSCTRL组名（SYSCTRL_GROUP）=
SYSMAINT组名（SYSMAINT_GROUP）=
SYSMON组名（SYSMON_GROUP）=
客户端用户名 - 密码插件（CLNT_PW_PLUGIN）=
客户端Kerberos插件（CLNT_KRB_PLUGIN）=
组插件（GROUP_PLUGIN）=
用于本地授权的GSS插件（LOCAL_GSSPLUGIN）=
服务器插件模式（SRV_PLUGIN_MODE）= UNFENCED
GSS插件的服务器列表（SRVCON_GSSPLUGIN_LIST）=
服务器用户ID密码插件（SRVCON_PW_PLUGIN）=
服务器连接验证（SRVCON_AUTH）=
NOT_SPECIFIED
数据库管理员验证（AUTHENTICATION）=服务器
无权限编目（CATALOG_NOAUTH）=否
信任所有客户端（TRUST_ALLCLNTS）= YES
可信客户端身份验证（TRUST_ CLNTAUTH）=客户
绕过联邦身份验证（FED_NOAUTH）=否
默认数据库路径（DFTDBPATH）= E：
数据库监视器堆大小（ 4KB）（MON_HEAP_SZ）= 90
Java虚拟机堆大小（4KB）（JAVA_HEAP_SZ）= 256
审计缓冲区大小（4KB）（AUDIT_BUF_SZ）= 0
实例共享内存的大小（4KB）（INSTANCE_MEMORY）= AUTOMATIC
备份缓冲区默认大小（4KB）（BACKBUFSZ）= 1024
恢复缓冲区默认大小（4KB）（RESTBUFSZ）= 1024
代理堆栈大小（AGENT_STACK_SZ）= 16
最小承诺私有内存（4KB）（MIN_PRIV_MEM）= 32
私有内存阈值（4KB）（PRIV_MEM_THRESH）= 20000
排序堆阈值（4KB）（SHEAPTHRES）= 10000
目录缓存支持（DIR_CACHE）= YES
应用程序支持ort层堆大小（4KB）（ASLHEAPSZ）= 15
最大请求者I / O块大小（字节）（RQRIOBLK）= 32767
DOS请求者I / O块大小（字节）（DOS_RQRIOBLK）= 4096
查询堆大小（4KB）（QUERY_HEAP_SZ）= 1000
受限制的实用程序对工作负载的影响（UTIL_IMPACT_LIM）= 10
代理商的优先级（AGENTPRI）=系统
现有代理商的最大数量（MAXAGENTS）= 400
代理商池大小（NUM_POOLAGENTS）=
200（计算）
池中代理商的初始数量（NUM_INITAGENTS）= 0
协调代理商的最大数量（MAX_COORDAGENTS）= MAXAGENTS
最大号码并发协调代理（MAXCAGENTS）=
MAX_COORDAGENTS
最大客户端连接数（MAX_CONNECTIONS）= 6000
保持隔离进程（KEEPFENCED）=是
池化隔离进程数（FENCED_POOL）=
MAX_COORDAGENTS
隔离进程的初始数量（NUM_INITFENCED）= 0
索引重新创建时间和重做索引构建（INDEXREC）= RESTART
事务管理器数据库名称（TM_DATABASE）= 1ST_CONN
事务重新同步间隔（秒）（RESYNC_INTERVAL ）= 180
SPM名称（SPM_NAME）= SAFE01
SPM日志大小（SPM_LOG_FILE_SZ）= 128
SPM重新同步代理限制（SPM_MAX_RESYNC）= 20
SPM日志路径（SPM_LOG_PATH）=
NetBIOS工作站名称（NNAME）=
TCP / IP Serv ice name（SVCENAME）= db2c_DB2
发现模式（DISCOVER）= SEARCH
发现服务器实例（DISCOVER_INST）= ENABLE
最大查询度parallelism（MAX_QUERYDEGREE）= ANY
启用分区内并行性（INTRA_PARALLEL）= NO
int的数量。通信缓冲区（4KB）（FCM_NUM_BUFFERS）= 1024
FCM请求块数（FCM_NUM_RQB）= AUTOMATIC
FCM连接条目数（ FCM_NUM_CONNECT）=自动
FCM消息锚的数量（FCM_NUM_ANCHORS）=自动
Hello,
This has been posted a few times but still I could not find a way to
connect to our database. We run DB2 Express on WIN2K server with XP
clients. I can ping inside network and to the Internet from the
server, so TCP/IP is ok. The DB2COMM=TCPIP is set also.
Have been scratching my head for days now.
Here some additional data (we are running SAP Business One):
Database Manager Configuration
Node type = Database Server with local and remote clients
Database manager configuration release level = 0x0a00
Maximum total of files open (MAXTOTFILOP) = 16000
CPU speed (millisec/instruction) (CPUSPEED) =
6.101113e-007
Max number of concurrently active databases (NUMDB) = 6
Data Links support (DATALINKS) = NO
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = E:\Program
Files\IBM\SQLLIB\java\jdk
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 2
Diagnostic data directory path (DIAGPATH) =
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = ON
SYSADM group name (SYSADM_GROUP) =
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) =
NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = E:
Database monitor heap size (4KB) (MON_HEAP_SZ) = 90
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 256
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Agent stack size (AGENT_STACK_SZ) = 16
Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000
Sort heap threshold (4KB) (SHEAPTHRES) = 10000
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
DOS requester I/O block size (bytes) (DOS_RQRIOBLK) = 4096
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 400
Agent pool size (NUM_POOLAGENTS) =
200(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) = 6000
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) =
MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time and redo index build (INDEXREC) = RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) = SAFE01
SPM log size (SPM_LOG_FILE_SZ) = 128
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
NetBIOS Workstation name (NNAME) =
TCP/IP Service name (SVCENAME) = db2c_DB2
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC
推荐答案
在db2服务器上，确保dbm cfg中提到的SVCENAME位于
服务文件中。像这样：
db2c_DB2 50000 / tcp
W2K中的
这个文件是c：\ winnt \ system32 \drivers \ etc \ service / /
50000是我选择的套接字编号（但db2默认）
重新启动db2实例
然后在你的客户端编目节点和db
db2 catalog tcpip node< MYNODEremote< server-ipserver 50000
db2 catalog db< DBat node< MYNODE>
db2 terminate
db2连接到< DBuser< userusing< password>
Knokmans
ps
你提到过ping正在工作，但这并不意味着所有TCP套接字
都是打开
也许在网上某处有一些防火墙问题。这也可以是你服务器或客户的价格......
" Mikael Arhelger" < mi ************ @ gmail.comwrote in message
news：11 ****************** ****@t46g2000cwa.googlegr oups.com ...
on your db2 server, be sure the SVCENAME mentioned in the dbm cfg is in the
services file. Like this:
db2c_DB2 50000/tcp
in W2K this file is c:\winnt\system32\drivers\etc\services
50000 is a socket numer i choose for example (but db2 default)
restart the db2 instance
then on you client catalog the node and db
db2 catalog tcpip node <MYNODEremote <server-ipserver 50000
db2 catalog db <DBat node <MYNODE>
db2 terminate
db2 connect to <DBuser <userusing <password>
Knokmans
p.s.
You mentioned "ping" is working, but that doens''t imply that all TCP sockets
are "open"
maybe there is some firewall issue somewhere on yout net. This CAN also be
you server or client....
"Mikael Arhelger" <mi************@gmail.comwrote in message
news:11**********************@t46g2000cwa.googlegr oups.com...
你好，
这已发布了一些时间，但我仍然无法找到一种方法来连接我们的数据库。我们使用XP
客户端在WIN2K服务器上运行DB2 Express。我可以通过
服务器在网络内部和Internet上ping，因此TCP / IP就可以了。 DB2COMM = TCPIP也被设置了。
现在已经好几天了。
这里有一些额外的数据（我们正在运行SAP业务一）：
数据库管理器配置
节点类型=具有本地和远程客户端的数据库服务器
数据库管理器配置发布级别= 0x0a00
打开的最大文件总数（MAXTOTFILOP）= 16000
CPU速度（毫秒/指令）（CPUSPEED）=
6.101113e-007
最大并发活动数据库数（NUMDB）= 6
数据链接支持（DATALINKS）=否
联邦数据库系统支持（联邦）=否
交易处理器监控名称（TP_MON_NAME）=
默认退款账户（DFT_ACCOUNT_STR）=
Java Development Kit安装路径（JDK_PATH）= E：\Program
文件s\IBM\SQLLIB\java\jdk
诊断错误捕获级别（DIAGLEVEL）= 3
通知级别（NOTIFYLEVEL）= 2
诊断数据目录路径（DIAGPATH）=
默认数据库监视器开关
缓冲池（DFT_MON_BUFPOOL）= OFF
锁定（DFT_MON_LOCK） = OFF
排序（DFT_MON_SORT）= OFF
对帐单（DFT_MON_STMT）= OFF
表（DFT_MON_TABLE）= OFF
时间戳（DFT_MON_TIMESTAMP）= ON
工作单元（DFT_MON_UOW）= OFF
监控实例和数据库的健康状况（HEALTH_MON）= ON
SYSADM组名（SYSADM_GROUP）=
SYSCTRL组名（SYSCTRL_GROUP）=
SYSMAINT组名（SYSMAINT_GROUP）=
SYSMON组名（SYSMON_GROUP）=
客户端用户ID密码插件（CLNT_PW_PLUGIN） =
客户端Kerberos插件（CLNT_KRB_PLUGIN）=
组插件（GROUP_PLUGIN）=
用于本地授权的GSS插件（LOCAL_GSSPLUGIN）=
服务器插件模式（SRV_PLUGIN_MODE）= UNFENCED
GSS插件的服务器列表（SRVCON_GSSPLUGIN_LIST）=
服务器用户ID密码插件（SRVCON_PW_PLUGIN）=
服务器连接身份验证（SRVCON_AUTH）=
NOT_SPECIFIED
数据库管理员身份验证（AUTHENTICATION）=服务器
无权限编目（ CATALOG_NOAUTH）=否
信任所有客户（TRUST_ALLCLNTS）= YES
值得信赖的客户端身份验证ion（TRUST_CLNTAUTH）=客户
绕过联邦身份验证（FED_NOAUTH）=否
默认数据库路径（DFTDBPATH）= E：
数据库监控堆size（4KB）（MON_HEAP_SZ）= 90
Java虚拟机堆大小（4KB）（JAVA_HEAP_SZ）= 256
审计缓冲区大小（4KB）（AUDIT_BUF_SZ）= 0
实例共享内存的大小（4KB）（INSTANCE_MEMORY）= AUTOMATIC
备份缓冲区默认大小（4KB）（BACKBUFSZ）= 1024
恢复缓冲区默认大小（4KB）（RESTBUFSZ）= 1024
代理堆栈大小（AGENT_STACK_SZ）= 16
最小提交私有内存（4KB）（MIN_PRIV_MEM）= 32
私有内存阈值（4KB）（PRIV_MEM_THRESH）= 20000
排序堆阈值（4KB）（SHEAPTHRES）= 10000
目录缓存支持（DIR_CACHE）= YES
应用程序支持层堆大小（4KB）（ASLHEAPSZ）= 15
最大请求者I / O块大小（字节）（RQRIOBLK）= 32767
DOS请求者I / O块大小（字节）（DOS_RQRIOBLK）= 4096
查询堆大小（4KB）（QUERY_HEAP_SZ）= 1000
受限制的实用程序对工作负载的影响（UTIL_IMPACT_LIM）= 10
代理商的优先级（AGENTPRI）=系统
现有代理商的最大数量（MAXAGENTS）= 400
代理商池大小（NUM_POOLAGENTS）=
200（计算）
池中代理的初始数量（NUM_INITAGENTS）= 0
协调代理的最大数量（MAX_COORDAGENTS）= MAXAGENTS
最大数量并发协调代理（MAXCAGENTS）=
MAX_COORDAGENTS
最大客户端连接数（MAX_CONNECTIONS）= 6000
保持隔离进程（KEEPFENCED）=是
池化隔离进程数（FENCED_POOL）=
MAX_COORDAGENTS
隔离进程的初始数量（NUM_INITFENCED）= 0
索引重新创建时间和重做索引构建（INDEXREC）= RESTART
事务管理器数据库名称（TM_DATABASE）= 1ST_CONN
事务重新同步间隔（秒）（RESYNC_INTERVAL ）= 180
SPM名称（SPM_NAME）= SAFE01
SPM日志大小（SPM_LOG_FILE_SZ）= 128
SPM重新同步代理限制（SPM_MAX_RESYNC）= 20
SPM日志路径（SPM_LOG_PATH）=
NetBIOS工作站名称（NNAME）=
TCP / IP Serv ice name（SVCENAME）= db2c_DB2
发现模式（DISCOVER）= SEARCH
发现服务器实例（DISCOVER_INST）= ENABLE
最大查询度parallelism（MAX_QUERYDEGREE）= ANY
启用分区内并行性（INTRA_PARALLEL）= NO
int的数量。通信缓冲区（4KB）（FCM_NUM_BUFFERS）= 1024
FCM请求块数（FCM_NUM_RQB）= AUTOMATIC
FCM连接条目数（ FCM_NUM_CONNECT）=自动
FCM消息锚点数量（FCM_NUM_ANCHORS）=自动
Hello,
This has been posted a few times but still I could not find a way to
connect to our database. We run DB2 Express on WIN2K server with XP
clients. I can ping inside network and to the Internet from the
server, so TCP/IP is ok. The DB2COMM=TCPIP is set also.
Have been scratching my head for days now.
Here some additional data (we are running SAP Business One):
Database Manager Configuration
Node type = Database Server with local and remote clients
Database manager configuration release level = 0x0a00
Maximum total of files open (MAXTOTFILOP) = 16000
CPU speed (millisec/instruction) (CPUSPEED) =
6.101113e-007
Max number of concurrently active databases (NUMDB) = 6
Data Links support (DATALINKS) = NO
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = E:\Program
Files\IBM\SQLLIB\java\jdk
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 2
Diagnostic data directory path (DIAGPATH) =
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = ON
SYSADM group name (SYSADM_GROUP) =
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) =
NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = E:
Database monitor heap size (4KB) (MON_HEAP_SZ) = 90
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 256
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Agent stack size (AGENT_STACK_SZ) = 16
Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000
Sort heap threshold (4KB) (SHEAPTHRES) = 10000
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
DOS requester I/O block size (bytes) (DOS_RQRIOBLK) = 4096
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 400
Agent pool size (NUM_POOLAGENTS) =
200(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) = 6000
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) =
MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time and redo index build (INDEXREC) = RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) = SAFE01
SPM log size (SPM_LOG_FILE_SZ) = 128
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
NetBIOS Workstation name (NNAME) =
TCP/IP Service name (SVCENAME) = db2c_DB2
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC
Mikael Arhelger写道：
Mikael Arhelger wrote:
您好，
这已发布几次但仍然我找不到通过
连接数据库的方法。我们使用XP
客户端在WIN2K服务器上运行DB2 Express。我可以通过
服务器在网络内部和Internet上ping，因此TCP / IP就可以了。 DB2COMM = TCPIP也被设置了。
现在已经好几天了。
这里有一些额外的数据（我们正在运行SAP业务一）：
数据库管理器配置
节点类型=具有本地和远程客户端的数据库服务器
数据库管理器配置发布级别= 0x0a00
打开的最大文件总数（MAXTOTFILOP）= 16000
CPU速度（毫秒/指令）（CPUSPEED）=
6.101113e-007
最大并发活动数据库数（NUMDB）= 6
数据链接支持（DATALINKS）=否
联邦数据库系统支持（联邦）=否
交易处理器监控名称（TP_MON_NAME）=
默认退款账户（DFT_ACCOUNT_STR）=
Java Development Kit安装路径（JDK_PATH）= E：\Program
Files \IBM\SQLLIB\java\jdk
诊断错误捕获级别（DIAGLEVEL）= 3
通知级别（NOTIFYLEVEL）= 2
诊断数据目录路径（DIAGPATH）=
默认数据库监视器开关
缓冲池（DFT_MON_BUFPOOL）= OFF
锁定（DFT_MON_LOCK）= OFF
排序（DFT_MON_SORT）= OFF
对帐单（DFT_MON_STMT）= OFF
表（DFT_MON_TABLE）= OFF
时间戳（DFT_MON_TIMESTAMP）= ON
工作单元（DFT_MON_UOW）= OFF
监控实例和数据库的运行状况（HEALTH_MON）= ON
SYSADM组名（SYSADM_GROUP）=
SYSCTRL组na我（SYSCTRL_GROUP）=
SYSMAINT组名（SYSMAINT_GROUP）=
SYSMON组名（SYSMON_GROUP）=
客户端用户ID密码插件（CLNT_PW_PLUGIN） ）=
客户端Kerberos插件（CLNT_KRB_PLUGIN）=
组插件（GROUP_PLUGIN）=
用于本地授权的GSS插件（LOCAL_GSSPLUGIN）=
服务器插件模式（SRV_PLUGIN_MODE）= UNFENCED
GSS插件的服务器列表（SRVCON_GSSPLUGIN_LIST）=
服务器用户ID密码插件（SRVCON_PW_PLUGIN）=
服务器连接验证（SRVCON_AUTH）=
NOT_SPECIFIED
数据库管理员验证（AUTHENTICATION）=服务器
无权限编目（CATALOG_NOAUTH）=否
信任所有客户（TRUST_ALLCLNTS）= YES
可信客户端身份验证（TRUST_CLNTAUTH）=客户端
绕过联合身份验证（FED_NOAUTH）=否
默认数据库路径（DFTDBPATH）= E：
数据库监视器堆大小（4KB）（MON_HEAP_SZ）= 90
Java虚拟机堆大小（4KB）（JAVA_HEAP_SZ）= 256
审计缓冲区大小（4KB）（AUDIT_BUF_SZ）= 0
实例共享内存的大小（4KB）（INSTANCE_MEMORY）= AUTOMATIC
备份缓冲区默认大小（4KB）（BACKBUFSZ）= 1024
恢复缓冲区默认大小（4KB）（RESTBUFSZ）= 1024
代理堆栈大小（AGENT_STACK_SZ）= 16
最小提交私有内存（4KB） （MIN_PRIV_MEM）= 32
私有内存阈值（4KB）（PRIV_MEM_THRESH）= 20000
排序堆阈值（4KB）（SHEAPTHRES）= 10000
目录缓存su pport（DIR_CACHE）= YES
应用程序支持层堆大小（4KB）（ASLHEAPSZ）= 15
最大请求者I / O块大小（字节）（RQRIOBLK）= 32767
DOS请求者I / O块大小（字节）（DOS_RQRIOBLK）= 4096
查询堆大小（4KB）（QUERY_HEAP_SZ）= 1000
受限制的实用程序对工作负载的影响（UTIL_IMPACT_LIM）= 10
代理的优先级（AGENTPRI）= SYSTEM
现有代理的最大数量（MAXAGENTS）= 400
代理池大小（NUM_POOLAGENTS）=
200（已计算）
池中代理的初始数量（NUM_INITAGENTS）= 0
最大数量协调代理人（MAX_COORDAGENTS）= MAXAGENTS
最大数量并发协调代理（MAXCAGENTS）=
MAX_COORDAGENTS
最大客户端连接数（MAX_CONNECTIONS）= 6000
保持隔离进程（KEEPFENCED）=是
池化隔离进程数（FENCED_POOL）=
MAX_COORDAGENTS
隔离进程的初始数量（NUM_INITFENCED）= 0
索引重新创建时间和重做索引构建（INDEXREC）= RESTART
事务管理器数据库名称（TM_DATABASE）= 1ST_CONN
事务重新同步间隔（秒）（RESYNC_INTERVAL ）= 180
SPM名称（SPM_NAME）= SAFE01
SPM日志大小（SPM_LOG_FILE_SZ）= 128
SPM重新同步代理限制（SPM_MAX_RESYNC）= 20
SPM日志路径（SPM_LOG_PATH）=
NetBIOS工作站名称（NNAME）=
TCP / IP服务名称（SVCENAME）= db2c_DB2
发现模式（DISCOVER）= SEARCH
发现服务器实例（DISCOVER_INST）= ENABLE
最大值查询并行度（MAX_QUERYDEGREE）= ANY
启用分区内并行性（INTRA_PARALLEL）=否
int的数量。通信缓冲区（4KB）（FCM_NUM_BUFFERS）= 1024
FCM请求块数（FCM_NUM_RQB）= AUTOMATIC
FCM连接条目数（ FCM_NUM_CONNECT）=自动
FCM消息锚点数（FCM_NUM_ANCHORS）= AUTOMATIC
Hello,
This has been posted a few times but still I could not find a way to
connect to our database. We run DB2 Express on WIN2K server with XP
clients. I can ping inside network and to the Internet from the
server, so TCP/IP is ok. The DB2COMM=TCPIP is set also.
Have been scratching my head for days now.
Here some additional data (we are running SAP Business One):
Database Manager Configuration
Node type = Database Server with local and remote clients
Database manager configuration release level = 0x0a00
Maximum total of files open (MAXTOTFILOP) = 16000
CPU speed (millisec/instruction) (CPUSPEED) =
6.101113e-007
Max number of concurrently active databases (NUMDB) = 6
Data Links support (DATALINKS) = NO
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =
Default charge-back account (DFT_ACCOUNT_STR) =
Java Development Kit installation path (JDK_PATH) = E:\Program
Files\IBM\SQLLIB\java\jdk
Diagnostic error capture level (DIAGLEVEL) = 3
Notify Level (NOTIFYLEVEL) = 2
Diagnostic data directory path (DIAGPATH) =
Default database monitor switches
Buffer pool (DFT_MON_BUFPOOL) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMESTAMP) = ON
Unit of work (DFT_MON_UOW) = OFF
Monitor health of instance and databases (HEALTH_MON) = ON
SYSADM group name (SYSADM_GROUP) =
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
Client Kerberos Plugin (CLNT_KRB_PLUGIN) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
Server Connection Authentication (SRVCON_AUTH) =
NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER
Cataloging allowed without authority (CATALOG_NOAUTH) = NO
Trust all clients (TRUST_ALLCLNTS) = YES
Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
Bypass federated authentication (FED_NOAUTH) = NO
Default database path (DFTDBPATH) = E:
Database monitor heap size (4KB) (MON_HEAP_SZ) = 90
Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 256
Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0
Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC
Backup buffer default size (4KB) (BACKBUFSZ) = 1024
Restore buffer default size (4KB) (RESTBUFSZ) = 1024
Agent stack size (AGENT_STACK_SZ) = 16
Minimum committed private memory (4KB) (MIN_PRIV_MEM) = 32
Private memory threshold (4KB) (PRIV_MEM_THRESH) = 20000
Sort heap threshold (4KB) (SHEAPTHRES) = 10000
Directory cache support (DIR_CACHE) = YES
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
DOS requester I/O block size (bytes) (DOS_RQRIOBLK) = 4096
Query heap size (4KB) (QUERY_HEAP_SZ) = 1000
Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10
Priority of agents (AGENTPRI) = SYSTEM
Max number of existing agents (MAXAGENTS) = 400
Agent pool size (NUM_POOLAGENTS) =
200(calculated)
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) = 6000
Keep fenced process (KEEPFENCED) = YES
Number of pooled fenced processes (FENCED_POOL) =
MAX_COORDAGENTS
Initial number of fenced processes (NUM_INITFENCED) = 0
Index re-creation time and redo index build (INDEXREC) = RESTART
Transaction manager database name (TM_DATABASE) = 1ST_CONN
Transaction resync interval (sec) (RESYNC_INTERVAL) = 180
SPM name (SPM_NAME) = SAFE01
SPM log size (SPM_LOG_FILE_SZ) = 128
SPM resync agent limit (SPM_MAX_RESYNC) = 20
SPM log path (SPM_LOG_PATH) =
NetBIOS Workstation name (NNAME) =
TCP/IP Service name (SVCENAME) = db2c_DB2
Discovery mode (DISCOVER) = SEARCH
Discover server instance (DISCOVER_INST) = ENABLE
Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL) = NO
No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = 1024
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNECT) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHORS) = AUTOMATIC
尝试从客户端到服务器的telnet在db2上的端口是
听。 Aka，如果db2正在监听50000：
#telnet< server50000
/ Lennart
Try telnet from the client to the server on the port that db2 is
listening to. Aka, if db2 is listening on 50000:
#telnet <server50000
/Lennart
Mikael Arhelger写道：
Mikael Arhelger wrote:
您好，
已发布几次但我仍然无法找到一种方法将
连接到我们的数据库。我们使用XP
客户端在WIN2K服务器上运行DB2 Express。我可以通过
服务器在网络内部和Internet上ping，因此TCP / IP就可以了。 DB2COMM = TCPIP也被设置。
Hello,
This has been posted a few times but still I could not find a way to
connect to our database. We run DB2 Express on WIN2K server with XP
clients. I can ping inside network and to the Internet from the
server, so TCP/IP is ok. The DB2COMM=TCPIP is set also.
尝试检查客户端上的hosts文件。我有一个类似的问题
在XP客户端上有一个糟糕的主机文件。
-Philip
Try checking the hosts file on the client. I had a similar problem
with a bad hosts file on an XP client.
-Philip
这篇关于通过TCP / IP问题连接到DB2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
