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
11  10330 
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
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
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
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
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
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
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?
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?
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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. }
|
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...
|
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?...
|
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...
|
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....
| | |
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...
|
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...
|
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"
|
by: lopina |
last post by:
Can somebody help me!!!
=================================
Cannot connect to IVICA-\SQLEXPRESS.
===================================
|
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 !
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |
