by Marius Mülle » Tue, 24 Jun 2003 02:33:46
i have to programm a java-code to connect to a IBM-DB2 database, but the
jdbc-driver has to use a listening-port from db2, because java tries to
connect like this way
jdbc:db2://111.222.333.444:PORT/database_name
the database and java runs on the same computer, but i dont have entered a
port for listing for statements.
Thanks for answering
by Mark » Tue, 24 Jun 2003 02:34:26
Are you asking what the port number is?Quote:> Hi people,
> i have to programm a java-code to connect to a IBM-DB2 database, but the
> jdbc-driver has to use a listening-port from db2, because java tries to
> connect like this way
> jdbc:db2://111.222.333.444:PORT/database_name
> the database and java runs on the same computer, but i dont have entered a
> port for listing for statements.
> Thanks for answering
by Marius Mülle » Tue, 24 Jun 2003 03:02:44
> Are you asking what the port number is?
by Mark » Tue, 24 Jun 2003 03:54:58
> > Are you asking what the port number is?
> yes
by Marius Mülle » Tue, 24 Jun 2003 04:16:54
it is not 50000.
maybe you can tell me, how i am able to look for the right port on my
db2-server
i have not change anything, but i cannot connect.
Quote:> Try 50000. That is the default unless it was changed.
by Mark » Tue, 24 Jun 2003 04:36:58
> it is not 50000.
> maybe you can tell me, how i am able to look for the right port on my
> db2-server
> i have not change anything, but i cannot connect.
If you are using version 7 Control Center, it might be in the communications
sections of the Database Manager configuration.
by Larry Menar » Tue, 24 Jun 2003 05:45:22
> > it is not 50000.
> > maybe you can tell me, how i am able to look for the right port on my
> > db2-server
> > i have not change anything, but i cannot connect.
> On version 8, Using the Control Center, Right Click on the instance name
> (such as db2inst1 or whatever is the instance name), then select "Setup
> communications." Then select the "properties" for TCP/IP.
> If you are using version 7 Control Center, it might be in the
communications
> sections of the Database Manager configuration.
by Mark » Tue, 24 Jun 2003 06:07:47
When I do a "db2 get dbm configuration" it shows the SVCENAME, but not theQuote:> See the SVCENAME parameter in the database manager configuration.
Also,
> there might already be an entry for your Instance in your "services" file.
> --
> Larry Menard
> IBM Workstation Database (DB2) Performance Team
> Defender of Geese and of All Things Natural
by Larry Menar » Tue, 24 Jun 2003 06:30:40
> When I do a "db2 get dbm configuration" it shows the SVCENAME, but not the
> port number. As I mentioned in the earlier post, the port number is
viewable
> via the Control Center.
by Knut Stolz » Tue, 24 Jun 2003 15:51:26
... or rather scriptable and, thus, much easier to reproduce. ;-)Quote:> Sure, no argument here. I'm just adding more info to what has been said.
> Some people shun GUIs, and prefer doing things manually.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
by Mark » Tue, 24 Jun 2003 19:00:42
When I run GET DATABASE MANAGER CONFIGURATION, there was no Port Number inQuote:> Larry Menard wrote on Sunday 22 June 2003 23:30:
> > Sure, no argument here. I'm just adding more info to what has been
said.
> > Some people shun GUIs, and prefer doing things manually.
> ... or rather scriptable and, thus, much easier to reproduce. ;-)
> --
> Knut Stolze
> Information Integration
> IBM Germany / University of Jena
by Larry Menar » Tue, 24 Jun 2003 22:36:17
Quote:> > Larry Menard wrote on Sunday 22 June 2003 23:30:
> > > Sure, no argument here. I'm just adding more info to what has been
> said.
> > > Some people shun GUIs, and prefer doing things manually.
> > ... or rather scriptable and, thus, much easier to reproduce. ;-)
> > --
> > Knut Stolze
> > Information Integration
> > IBM Germany / University of Jena
> When I run GET DATABASE MANAGER CONFIGURATION, there was no Port Number in
> the output. The only way I have found to view the Port Number is via the
> Control Center GUI. But maybe I missed something.
by Gert van der Kooi » Wed, 25 Jun 2003 02:08:16
If you are running on the same computer, you don't need the netQuote:> Hi people,
> i have to programm a java-code to connect to a IBM-DB2 database, but the
> jdbc-driver has to use a listening-port from db2, because java tries to
> connect like this way
> jdbc:db2://111.222.333.444:PORT/database_name
> the database and java runs on the same computer, but i dont have entered a
> port for listing for statements.
> Thanks for answering
If you really need to access it using the net driver, make sure the
db2jd is started. By default is listens to the 6789 port.
1. Java and DB2 Codeset Problem
Hello,
probably this kind of problem was posted 1000 times..but please help..:(
I have;
WebSphere Application Developer
DB2 7.2
Database in UTF-8 format
System Locale: 1250 (Croatia)
All I want is to get some of my local letters in database.. but nooooo......
I know that java is working internally with Unicode and that it is
communicating with outside world with utf-8... but all I get is bunch of
???? (and some other symbols....)
Application si normal java code started directly from Websphere, not a
servlet or jsp file...an using simple INSERT sql function ..nothing more....
4. JDBC-ODBC to Access-MDB on CDROM - Automatically installing/configuring ODBC DSN?
9. lightweight JDBC for java 1.0 (db2 and informix)
10. IBM Visualage for Java and DB2
11. Access App error in Visual Age Java and DB2 UDBv5
13. java and db2