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  18380 
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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.
...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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,...
|
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...
| |
