473,902 Members | 4,620 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

CONNECT TO DB2 VIA TCP/IP PROBLEM

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_ST R) =
Java Development Kit installation path (JDK_PATH) = E:\Program
Files\IBM\SQLLI B\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_BUFPOO L) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMEST AMP) = 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_PLUGI N) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGI N) =
Server Plugin Mode (SRV_PLUGIN_MOD E) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUG IN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUG IN) =
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_MEMOR Y) = 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_THRES H) = 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_COORDAGENT S) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTION S) = 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_INTERVA L) = 180
SPM name (SPM_NAME) = SAFE01
SPM log size (SPM_LOG_FILE_S Z) = 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_QUERYDEGRE E) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL ) = NO
No. of int. communication buffers(4KB)(FC M_NUM_BUFFERS) = 1024

Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC

Number of FCM connection entries (FCM_NUM_CONNEC T) = AUTOMATIC

Number of FCM message anchors (FCM_NUM_ANCHOR S) = AUTOMATIC

Dec 20 '06 #1
11 10341
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\system 32\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.goo glegroups.com.. .
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_ST R) =
Java Development Kit installation path (JDK_PATH) = E:\Program
Files\IBM\SQLLI B\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_BUFPOO L) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMEST AMP) = 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_PLUGI N) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGI N) =
Server Plugin Mode (SRV_PLUGIN_MOD E) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUG IN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUG IN) =
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_MEMOR Y) = 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_THRES H) = 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_COORDAGENT S) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTION S) = 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_INTERVA L) = 180
SPM name (SPM_NAME) = SAFE01
SPM log size (SPM_LOG_FILE_S Z) = 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_QUERYDEGRE E) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL ) = NO
No. of int. communication buffers(4KB)(FC M_NUM_BUFFERS) = 1024

Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC

Number of FCM connection entries (FCM_NUM_CONNEC T) = AUTOMATIC

Number of FCM message anchors (FCM_NUM_ANCHOR S) = AUTOMATIC

Dec 20 '06 #2

Mikael Arhelger wrote:
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_ST R) =
Java Development Kit installation path (JDK_PATH) = E:\Program
Files\IBM\SQLLI B\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_BUFPOO L) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMEST AMP) = 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_PLUGI N) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGI N) =
Server Plugin Mode (SRV_PLUGIN_MOD E) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUG IN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUG IN) =
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_MEMOR Y) = 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_THRES H) = 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_COORDAGENT S) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTION S) = 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_INTERVA L) = 180
SPM name (SPM_NAME) = SAFE01
SPM log size (SPM_LOG_FILE_S Z) = 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_QUERYDEGRE E) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL ) = NO
No. of int. communication buffers(4KB)(FC M_NUM_BUFFERS) = 1024

Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC

Number of FCM connection entries (FCM_NUM_CONNEC T) = AUTOMATIC

Number of FCM message anchors (FCM_NUM_ANCHOR S) = AUTOMATIC
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

Dec 20 '06 #3
Mikael Arhelger wrote:
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.
Try checking the hosts file on the client. I had a similar problem
with a bad hosts file on an XP client.

-Philip
Dec 20 '06 #4
Hello!

Tks for this quick reply and help. Still have problem:

db2 catalog db SBO_DB at node NDED8814
SQL1005N The database alias "SBO_DB" already exists in either the
local database directory or system database directory

db2 terminate
DB20000I The TERMINATE command completed successfully.

db2 connect to SBO_DB user db2admin using SECRET
.... hang ...

Mikael


On Dec 20, 7:45 pm, "Knokmans" <knokm...@nospa m.comwrote:
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\system 32\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" <mikaelarhel... @gmail.comwrote in messagenews:11* *************** ******@t46g2000 cwa.googlegroup s.com...
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_ST R) =
Java Development Kit installation path (JDK_PATH) = E:\Program
Files\IBM\SQLLI B\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_BUFPOO L) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMEST AMP) = 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_PLUGI N) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGI N) =
Server Plugin Mode (SRV_PLUGIN_MOD E) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUG IN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUG IN) =
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_MEMOR Y) = 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_THRES H) = 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_COORDAGENT S) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTION S) = 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_INTERVA L) = 180
SPM name (SPM_NAME) = SAFE01
SPM log size (SPM_LOG_FILE_S Z) = 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_QUERYDEGRE E) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL ) = NO
No. of int. communication buffers(4KB)(FC M_NUM_BUFFERS) = 1024
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNEC T) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHOR S) = AUTOMATIC
Dec 20 '06 #5
Hello,

My host file only shows:

Win XP client:
127.0.0.1 localhost

WIN2K Server:
127.0.0.1 localhost
192.168.0.1 safe01.safe.com .hk

All looks ok.

Mikael

On Dec 20, 11:42 pm, Philip Wright <pvws...@bellso uth.netwrote:
Mikael Arhelger wrote:
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.Try checking the hosts file on the client. I had a similar problem
with a bad hosts file on an XP client.

-Philip
Dec 20 '06 #6
Hello,

The last entry in 'services' shows (on WinXP ws and WIN2K server):

db2c_DB2 50000/tcp

but when I do netstat -a on the WIN2K server, the port 50000 is nowhere
listed although 'db2c_DB2' is. So, I think ok.

BUT: when I telnet 192.168.0.1 50000 it hangs.

Q: Am I heading the correct direction now to see the light in the
tunnel?
Mikael

On Dec 20, 11:41 pm, "Lennart" <Erik.Lennart.J ons...@gmail.co mwrote:
Mikael Arhelger wrote:
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_ST R) =
Java Development Kit installation path (JDK_PATH) = E:\Program
Files\IBM\SQLLI B\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_BUFPOO L) = OFF
Lock (DFT_MON_LOCK) = OFF
Sort (DFT_MON_SORT) = OFF
Statement (DFT_MON_STMT) = OFF
Table (DFT_MON_TABLE) = OFF
Timestamp (DFT_MON_TIMEST AMP) = 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_PLUGI N) =
Group Plugin (GROUP_PLUGIN) =
GSS Plugin for Local Authorization (LOCAL_GSSPLUGI N) =
Server Plugin Mode (SRV_PLUGIN_MOD E) = UNFENCED
Server List of GSS Plugins (SRVCON_GSSPLUG IN_LIST) =
Server Userid-Password Plugin (SRVCON_PW_PLUG IN) =
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_MEMOR Y) = 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_THRES H) = 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_COORDAGENT S) = MAXAGENTS
Max no. of concurrent coordinating agents (MAXCAGENTS) =
MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTION S) = 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_INTERVA L) = 180
SPM name (SPM_NAME) = SAFE01
SPM log size (SPM_LOG_FILE_S Z) = 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_QUERYDEGRE E) = ANY
Enable intra-partition parallelism (INTRA_PARALLEL ) = NO
No. of int. communication buffers(4KB)(FC M_NUM_BUFFERS) = 1024
Number of FCM request blocks (FCM_NUM_RQB) = AUTOMATIC
Number of FCM connection entries (FCM_NUM_CONNEC T) = AUTOMATIC
Number of FCM message anchors (FCM_NUM_ANCHOR S) = AUTOMATICTry 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
Dec 20 '06 #7
In article <11************ **********@80g2 000cwy.googlegr oups.com>,
mi************@ gmail.com says...
Hello,

The last entry in 'services' shows (on WinXP ws and WIN2K server):

db2c_DB2 50000/tcp

but when I do netstat -a on the WIN2K server, the port 50000 is nowhere
listed although 'db2c_DB2' is. So, I think ok.

BUT: when I telnet 192.168.0.1 50000 it hangs.

Q: Am I heading the correct direction now to see the light in the
tunnel?
Do you have a firewall runnning in your network and/or on the W2K
server?

Dec 20 '06 #8
Hello,

We do have a firewall running on 192.168.0.3 but not on W2K server
192.168.0.1

....

Mikael

On Dec 21, 1:03 am, Gert van der Kooij <nom...@invalid .nlwrote:
In article <1166633497.140 576.176...@80g2 000cwy.googlegr oups.com>,
mikaelarhel...@ gmail.com says...
Hello,
The last entry in 'services' shows (on WinXP ws and WIN2K server):
db2c_DB2 50000/tcp
but when I do netstat -a on the WIN2K server, the port 50000 is nowhere
listed although 'db2c_DB2' is. So, I think ok.
BUT: when I telnet 192.168.0.1 50000 it hangs.
Q: Am I heading the correct direction now to see the light in the
tunnel?Do you have a firewall runnning in your network and/or on the W2K
server?
Dec 20 '06 #9
In article <11************ **********@i12g 2000cwa.googleg roups.com>,
mi************@ gmail.com says...
On Dec 21, 1:03 am, Gert van der Kooij <nom...@invalid .nlwrote:
In article <1166633497.140 576.176...@80g2 000cwy.googlegr oups.com>,
mikaelarhel...@ gmail.com says...
Hello,
The last entry in 'services' shows (on WinXP ws and WIN2K server):
db2c_DB2 50000/tcp
but when I do netstat -a on the WIN2K server, the port 50000 is nowhere
listed although 'db2c_DB2' is. So, I think ok.
BUT: when I telnet 192.168.0.1 50000 it hangs.
Q: Am I heading the correct direction now to see the light in the
tunnel?Do you have a firewall runnning in your network and/or on the W2K
server?


Hello,

We do have a firewall running on 192.168.0.3 but not on W2K server
192.168.0.1

...
Is this firewall filtering all the network traffic? Then maybe it has to
be adjusted to let pass all traffic on port 50000 between the XP clients
and the W2K server.
Dec 20 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4164
by: Ralphie | last post by:
Hello everyone, I was wonerding if anybody has a problem that when you try and instantiate DB class it just returns a blank page ... my code is function session() { 1. $this->_oConn =& DB::connect(DSN); 2. if (DB::isError($this->_oConn) ) { 3. catchExc($this->_oConn->getMessage()); 4. }
2
3548
by: Gazchurchend | last post by:
I am trying to connect to a legacy system running on VMS using the Attunity Connect ODBC driver from within PHP. I know the System DSN works because SQL Server has been using it successfully for years. I want to access the info on VMS from within PHP and this is when all goes pear shaped! I have tried various ways... 1) If I am in query analyser and type 'SELECT * FROM DNSNAME...TABLENAME' etc. This works fine. But if I try putting...
4
1186
by: yfng | last post by:
I build a web service in a server(A) and can connect to it successfully in my local computer(B) by using SoapHttpClientProtocol as client. However, when I move the same code(local computer (B)) to another computer (C). It (C) can view the web service through browser but not success in code. Is there anything that I need to notice to use SoapttpClientProtocol, i.e. which port to use and what else service or software that I need to enable?...
0
1436
by: Ashish Kulkarni | last post by:
Hi Ppl, Here's the problem definition:- As a part of a J2EE Application that we are developing, we have a functionality for uploading and viewing gif images. Everything is working fine but for the fact that we are not able to upload image data greater that 4088 bytes! At the front end, we are using Multipart form data to get the image data into a byte array. In the callable statement, the image data is set using setString. At the...
0
1698
by: JenU | last post by:
Hi! Running DB2 Connect EE 8.1 on Windows 2000. When we execute a web app with a small amount of data returned, we do not have a problem. But, when we widen the criteria, we get errors... web app shows: Exception caught in TFBDB, DoDB2Dataset - DotNet Provider. Exception Message - SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command....
3
1451
by: yes_its_just_me | last post by:
Hi everyone, I haven't used PHP since version 4 and am trying to use it for a new project. All I'm trying to do is connect to a MySQL database and show the contents of that database (as a start). However, nothing seems to be working. When I execute the script it does nothing, no error messages, nothing. I know that PHP is working because I've done the phpinfo(); thing and it works. I also know my database is working because I can access it...
9
2573
by: Peter Lux | last post by:
I'm fairly new to c#, but not new to programming. I'm tasked with rewriting our Gupta/Sqlwindows apps (5 years worth of development) in dot Net. The main reason is that virtually no one knows the language, which is unfortunate because it's very simple to get windows created and rolled out. I downloaded C# (orcas) express and had created a SqlServer 2005 database (locally, ie not on a server) and moved some of our production data into it...
1
1505
by: Daniel Loose | last post by:
Hello, I try to get an asp site to work on my local machine. Using ASP Studio 2005 and mssql server 2005 eval on win xp, and ms management studio. I'm new to mssql and asp and just want to get the site to run (not edit). have a simple connect script like set conn = server.CreateObject("adodb.connection") conString ="PROVIDER=SQLOLEDB;DATA SOURCE=DANIEL;DATABASE=nano;User ID=sa;Password=yyy"
1
1325
by: lopina | last post by:
Can somebody help me!!! ================================= Cannot connect to IVICA-\SQLEXPRESS. ===================================
3
3562
by: chendurkumar | last post by:
HI ! I have a strange problem with UDPClient.Connect method. When I create a udpclient and connect the client with Local IP address (say 10.0.0.10)and a local port (4569) , the client LocalEndPoint and Remoteendpoint are always localhost ( for LocalEndPoint 127.0.0.1:4569 and RemoteEndPoint is 127.0.0.1:50512) . Its so strange , why its creates these incorrent Endpoints ? Please help me out of this problem ! Thanks !
0
9845
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11279
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10872
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9675
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5893
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6085
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4725
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4307
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3323
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.