473,554 Members | 2,307 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Universal JDBC Driver ....

Read this about the Universal JDBC Driver....

"In a Type 2 mode, the Universal JDBC driver provides local
application performance gains (because it avoids using TCP/IP protocol
to communicate to the DB2 server). "

Wht does it mean by "local" application performance? In type 2 mode,
it is a pre-requisite that all the databases that the application
running at the client need to be cataloged (through CCA or otherwise)
on the client; Most of the installations I have seen using TCPIP
'nodes' for cataloging (with CATALOG TCPIP NODE... command); so how
does the driver avoid using TCP/IP protocol?

TIA
Raquel.
Nov 12 '05 #1
2 3738
aj
A type 2 jdbc driver (app driver) requires, at a minimum, a
DB2 runtime client to be installed at the client. The
application talks thru the runtime client directly to the
DB2 server.

A type 3 jdbc driver (net driver) does not require any
local runtime client, but does require a daemon at the
server. The application talks across the network thru
the daemon at the server to the DB2 server. The daemon
is called db2jd, btw. You start it w/ db2jstrt.

A type 4 jdbc driver (universal) does not require any
additional s/w on either the client or the server. The
application talks directly to the DB2 server using native
DB2 protocol. Because there is not an extra layer to go
thru on the client or the server, things are faster.

I'm not sure if its completely accurate to say that the type
4 jdbc driver avoids using the TCP/IP protocol - a better
was to think of it is that the type 4 driver operates
lower on the OSI stack - it is lower level..

HTH

allen
Raquel wrote:
Read this about the Universal JDBC Driver....

"In a Type 2 mode, the Universal JDBC driver provides local
application performance gains (because it avoids using TCP/IP protocol
to communicate to the DB2 server). "

Wht does it mean by "local" application performance? In type 2 mode,
it is a pre-requisite that all the databases that the application
running at the client need to be cataloged (through CCA or otherwise)
on the client; Most of the installations I have seen using TCPIP
'nodes' for cataloging (with CATALOG TCPIP NODE... command); so how
does the driver avoid using TCP/IP protocol?

TIA
Raquel.

Nov 12 '05 #2
Only *remote* nodes need to be cataloged using CATALOG TCPIP NODE. Your
local system automatically qualifies as a node. When you create a database,
it will be created on the local node. Do a "db2 list db directory" with a
local and a remote database cataloged and you'll see it looks like:

System Database Directory

Number of entries in the directory = 2

Database 1 entry:

Database alias = RMTSAMP
Database name = SAMPLE
Node name = RMTNODE
Database release level = a.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = SAMPLE
Database name = SAMPLE
Database drive = D:\DB2
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Note the different "Directory entry type".

Since you could (if you wanted to) use a T4 driver to connect to a local
database, the doc is saying that in that case you'd get better performance
from a T2 driver.
--
Larry Menard
IBM Workstation Database (DB2) Information Development, Samples Coordinator
Defender of Geese and of All Things Natural
"Raquel" <ra************ ****@yahoo.com> wrote in message
news:9a******** *************** ***@posting.goo gle.com...
Read this about the Universal JDBC Driver....

"In a Type 2 mode, the Universal JDBC driver provides local
application performance gains (because it avoids using TCP/IP protocol
to communicate to the DB2 server). "

Wht does it mean by "local" application performance? In type 2 mode,
it is a pre-requisite that all the databases that the application
running at the client need to be cataloged (through CCA or otherwise)
on the client; Most of the installations I have seen using TCPIP
'nodes' for cataloging (with CATALOG TCPIP NODE... command); so how
does the driver avoid using TCP/IP protocol?

TIA
Raquel.

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1860
by: Priya | last post by:
Hi, I am having some problem with DB2 Universal JDBC driver. 1. The method getColumnType(columnNumber)of ResultSetMetaData always returns zero. 2. The method getColumnDisplaySize(ColumnNum) raises an exception, with exception message - not supported. Version of DB2 - 7.1
4
6330
by: Dani | last post by:
Hi everyone Description of the problem: Using a PreparedStatement to write down an integer (int) plus a timestamp for testing purposes. When read out again the integer looks very different. We found that it was shifted three Bytes to the left, i.e. 4 becomes hex 4000000 which is 67108864 in decimal base. This means that the value written...
0
3074
by: Bing | last post by:
Hi, I am configuring the same DB2 v8.1 JDBC universal driver (db2jcc.jar and db2jcc_license_cisuz.jar) from DB2 SP5 fix pack under WSAD 5.1.x environment and WebSphere application Server 5.0.2 on Windows 2000 machines. I configured a connection pool data source using type 4 for a local test environment in WSAD 5.1.x, and a connection pool...
0
2928
by: aj | last post by:
DB2 v8 FP5 Red Hat AS/EL 2.1 I am specifying properties for a DB2 Universal JDBC Driver connection in my Java/JDBC app by creating a java.util.Properties object and passing it along in my connect() call.. For example, I use the "currentSchema" property to set the default schema, which is apparently equivalent to a "SET SCHEMA" command...
2
4456
by: charl | last post by:
Hi, My apologies in advance if my terminology is slightly confused, I am new to all this. We have previously been running some SQL on DB2 (v7) utilising a type 3 driver, and have made the change to DB2 v8 with a type 2 DB2 Universal JDBC Driver. SQL that ran successfully under the old setup now throws the following error...
1
13197
by: sbanil | last post by:
We have a JAVA application which uses following Database product name : DB2 Database product version : DSN07012 JDBC driver name : IBM DB2 JDBC Universal Driver Architecture JDBC driver version : 2.3.63 APplication Server:Websphere When the prepared statement cache for the JDBC driver is set to > 0 following query fails on DB2 OS/390...
1
1886
by: dunleav1 | last post by:
Does anyone know the link of IBM's web site for the Universal JDBC driver for DB2? I just can't find it. Thanks, JD
0
1397
by: dunleav1 | last post by:
How can I be sure that DB2_LINUXAIO is working properly in DB 9 FP3? The parameter db2_linuxaio was depreciated from the base version to FP3 and my performance tests have shown a decrease in performance between the versions. DB2 9 FP3 on windows compared to windows seems to be about 40% faster in my first test. I have a few more to run... ...
0
1939
by: rahulj | last post by:
Some of the queries, in our application, have trailing semicolon which works fine when the application uses DB2 CLI Native Driver. But when the driver is changed to DB2 Type 4 Universal Driver an error is thrown by the driver due to trailing semicolon (i.e removing the semicolon resolves the issue). The question is that what is the way to...
0
7612
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...
0
7536
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...
0
7814
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. ...
1
7576
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...
0
6163
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...
1
5443
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5165
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...
0
3583
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...
0
853
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...

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.