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 18379
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: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |