I've done this before, but apparently I didn't keep my notes..
I have DB2 Personal Edition on my Windows XP box to talk to our DB2
database on our AS/400. This HAS been working fine. Until this
morning, that is. It was working Friday afternoon, and this morning,
it was broken. It was giving me some error message about an invalid
license file. So I uninstalled it (FP 4a) and have installed FP 5.
When using the Configuration Assistant to set up the db, it asks for
the port number. It's coming up as 446. I believe because in my
"services" file on my PC, I have an entry for "DB2COMM" on port 446.
(BUT I have a faint recollection of the port number being 630, when I
did this the last time.)
I don't know how to look on the AS/400 to check and see what port DB2
is using. The guys here don't know either. (The last time I did
this, I was fortunate enough to be able to ask an IBM guy who had come
to upgrade some other software. In just a couple minutes he had my
answer.) I remember something about "DRDA".
Apparently the AS/400 is not set up for discovery, as this method
never finds anything. Only me telling Connect what the port number
is, is what works.
Any help is greatly appreciated.
Thanks,
Tom 2 18402
Tom wrote: I've done this before, but apparently I didn't keep my notes..
I have DB2 Personal Edition on my Windows XP box to talk to our DB2 database on our AS/400. This HAS been working fine. Until this morning, that is. It was working Friday afternoon, and this morning, it was broken. It was giving me some error message about an invalid license file. So I uninstalled it (FP 4a) and have installed FP 5.
When using the Configuration Assistant to set up the db, it asks for the port number. It's coming up as 446. I believe because in my "services" file on my PC, I have an entry for "DB2COMM" on port 446. (BUT I have a faint recollection of the port number being 630, when I did this the last time.)
I don't know how to look on the AS/400 to check and see what port DB2 is using. The guys here don't know either. (The last time I did this, I was fortunate enough to be able to ask an IBM guy who had come to upgrade some other software. In just a couple minutes he had my answer.) I remember something about "DRDA".
Apparently the AS/400 is not set up for discovery, as this method never finds anything. Only me telling Connect what the port number is, is what works.
Any help is greatly appreciated.
On the AS/400, use the WRKRDBDIRE command to get a list of configured
RDBs. Locate the RDB entry in the list with *LOCAL remote location and
use option 5 (Display). If the remote location type is *IP, the port
number should be shown. If the port shown is *DRDA, it is using 446.
Additional info is available in the Distributed Database Programming book: http://publib.boulder.ibm.com/iserie...rbal1mst02.htm
This site is also sometimes helpful when configuring DB2 Connect: http://www.ibm.com/servers/eserver/i...2/db22drda.htm
--
Karl Hanson
Tom wrote: I've done this before, but apparently I didn't keep my notes..
I have DB2 Personal Edition on my Windows XP box to talk to our DB2 database on our AS/400. This HAS been working fine. Until this morning, that is. It was working Friday afternoon, and this morning, it was broken. It was giving me some error message about an invalid license file. So I uninstalled it (FP 4a) and have installed FP 5.
When using the Configuration Assistant to set up the db, it asks for the port number. It's coming up as 446. I believe because in my "services" file on my PC, I have an entry for "DB2COMM" on port 446. (BUT I have a faint recollection of the port number being 630, when I did this the last time.)
I don't know how to look on the AS/400 to check and see what port DB2 is using. The guys here don't know either. (The last time I did this, I was fortunate enough to be able to ask an IBM guy who had come to upgrade some other software. In just a couple minutes he had my answer.) I remember something about "DRDA".
Apparently the AS/400 is not set up for discovery, as this method never finds anything. Only me telling Connect what the port number is, is what works.
Any help is greatly appreciated.
On the AS/400, use the WRKRDBDIRE command to get a list of configured
RDBs. Locate the RDB entry in the list with *LOCAL remote location and
use option 5 (Display). If the remote location type is *IP, the port
number should be shown. If the port shown is *DRDA, it is using 446.
Additional info is available in the Distributed Database Programming book: http://publib.boulder.ibm.com/iserie...rbal1mst02.htm
This site is also sometimes helpful when configuring DB2 Connect: http://www.ibm.com/servers/eserver/i...2/db22drda.htm
--
Karl Hanson This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Fred |
last post by:
I just started using MySQL, and cannot find how to
configure host access in the my.cnf file. I want
to be able to allow access to a MySQL database
from a remote host, and also from a particular
network. How do you configure access of this sort?
-Thanks
|
by: MLH |
last post by:
Using MS Access, I have attached to MySQL servers in other states
and other countries on the other side of my router. But when I use the
MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN,
the driver tells me it cannot make the connection. Here are the ODBC
driver connection parms:
Data Source Name: (free field - name my "my linux box" will do nicely)
Host/Server Name (or IP) - something like MSQLUserName@ServerName.net...
|
by: claire |
last post by:
I'm trying to open and configure a serial/comm port to talk to another
device. I've used the Win32 methods described on MSDN but I get an
unexpected error message when I try to configure the port -
SetCommState returns error 127 (which I think is
ERROR_PROC_NOT_FOUND).
Can anyone find the mistake in the code below, or suggest any changes
I could make? Thanks for any help. I've only included the relevant
sections of code - the...
|
by: Gayathri Subramaniam |
last post by:
hai,
im a student. i am assigned a task to instruct a robot. for this i
want to write and read from com1. i do not know how to configure the
port using DCB structure. i have a data rate of 9600bps, odd parity, 7
data bits, hardware flow control. i do not know how to do this in c#.
thanks in advance.
|
by: Zean Smith |
last post by:
I have a SMTP server running on port 9025, but seems like this doesn't
work.
SmtpMail.SmtpServer = "192.168.34.15:9025";
SmtpMail.Send( mail );
I couldn't find any properties on SmtpMail let me configure the port number,
any idea?
| |
by: vorange |
last post by:
Hello,
I have a problem I have been unable to solve for quite some
time now. I'm using the Serialport class and opening the port and
writing a byte to it. The byte is successfully received by the other
device. The other device then sends back a response.
But what I get back is the same character I sent! e.g. if i send 2, i
get back 2.
What is going on here? Why are things being echoed back. My code is
|
by: apasj06 |
last post by:
hello everyone:
I am trying to send email via php. I using window XP home edition.
My mail client is
outlook express. I configured mail client to send email via my aol
email account.
mail server information: mail account: imap.aol.com
|
by: hemavathisivakumar |
last post by:
can we write c/c++program to configure a port or sent some instruction to the port while using windows operating system...
if yes can you plz let me know the code....
|
by: Steve McKewen |
last post by:
Is there a way to call up the Communications Port Properties dialog for a
particular com port from my program?
I want to be able to configure the port, and making another dialog seems
silly.
Thanks
VS2005 .NET2
Steve
|
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: 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...
| |
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: 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();...
|
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: 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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |