473,883 Members | 1,839 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
11 10340
Hello,

We will look into it. Tks!

Mikael

Gert van der Kooij wrote:
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 #11

"Mikael Arhelger" <mi************ @gmail.comwrote in message
news:11******** **************@ t46g2000cwa.goo glegroups.com.. .
Hello,
Hello:
>
1)verify on the db2 server in the services file located in
C:\WINDOWS\syst em32\drivers\et c
that the corresponding port for the service : db2c_DB2

2) On the server , after the db2start, netstat -nA shows the corresponding
port number in listening status.

3)On the client open the db2 command window :
db2 Catalog TCPIP NODE <nodename remote <Db2 server host nameSERVER
<port number for poin 1 and

db2 Catalog database <db name ALIAS <alias nameat node <nodename for
point 3>

db2 DB2 terminate.

4)Try th connect

5)If it doesn't work try from the client fromt dos prompt:
telnet <db2 server host name <port number>
If the screen become blak it means that you can reach the host in the
specific port, it it hangs, there is a firwall that block the port or the
protocol in the network.

Ciao!
Dec 21 '06 #12

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
1450
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
3560
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
9944
marktang
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...
0
11152
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
10420
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9582
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
7134
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5997
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4620
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
4225
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3239
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.