JDBC Type 3 vs Type 4 
Author Message
 JDBC Type 3 vs Type 4

Hi all,

I am running weblogic against UDB6.1. The original deployment used the IBM
type 3 JDBC drivers. After much heavy loading ( 200-300 SQL selects/sec
returing small sets of upto 8 rows ) the java heap ( 512 Mb) was continually
used! In a desperate attempt to reduce the heap usage i used the HIT type 4
drivers.
The difference in the heap usage is now *only* 5% of the 512Mb heap is used
at the similar load! This obviously meant that the system could be load much
harder until other kernal resources were exceeded.

Question:
Is this behaviour expected from the IBM drivers? Given that the above
comparison was performed on the idneitcal evironments.

-lucio



Sat, 25 Jan 2003 03:00:00 GMT
 JDBC Type 3 vs Type 4

Use Type 2 driver to get good performance. Type 3 driver will always perform
worse then type 2.


Quote:
> Hi all,

> I am running weblogic against UDB6.1. The original deployment used the IBM
> type 3 JDBC drivers. After much heavy loading ( 200-300 SQL selects/sec
> returing small sets of upto 8 rows ) the java heap ( 512 Mb) was
continually
> used! In a desperate attempt to reduce the heap usage i used the HIT type
4
> drivers.
> The difference in the heap usage is now *only* 5% of the 512Mb heap is
used
> at the similar load! This obviously meant that the system could be load
much
> harder until other kernal resources were exceeded.

> Question:
> Is this behaviour expected from the IBM drivers? Given that the above
> comparison was performed on the idneitcal evironments.

> -lucio



Sat, 25 Jan 2003 03:00:00 GMT
 JDBC Type 3 vs Type 4
I think the type 3 drivers are the net drivers. Then the app drivers are
really type 2. So I'm guessing you really switched from type 3 to type 2.

Anyway, when you switch to using the app drivers it is supposed to be
faster. I'm not clear why and am interested to have it explained...



Quote:
> Hi all,

> I am running weblogic against UDB6.1. The original deployment used the IBM
> type 3 JDBC drivers. After much heavy loading ( 200-300 SQL selects/sec
> returing small sets of upto 8 rows ) the java heap ( 512 Mb) was continually
> used! In a desperate attempt to reduce the heap usage i used the HIT type 4
> drivers.
> The difference in the heap usage is now *only* 5% of the 512Mb heap is used
> at the similar load! This obviously meant that the system could be load much
> harder until other kernal resources were exceeded.

> Question:
> Is this behaviour expected from the IBM drivers? Given that the above
> comparison was performed on the idneitcal evironments.

> -lucio



Sun, 26 Jan 2003 03:00:00 GMT
 JDBC Type 3 vs Type 4
Little question, db2java.zip from distribution is Type3 or Type2 ?
Quote:

> I think the type 3 drivers are the net drivers. Then the app drivers are
> really type 2. So I'm guessing you really switched from type 3 to type 2.

> Anyway, when you switch to using the app drivers it is supposed to be
> faster. I'm not clear why and am interested to have it explained...



> > Hi all,

> > I am running weblogic against UDB6.1. The original deployment used the IBM
> > type 3 JDBC drivers. After much heavy loading ( 200-300 SQL selects/sec
> > returing small sets of upto 8 rows ) the java heap ( 512 Mb) was continually
> > used! In a desperate attempt to reduce the heap usage i used the HIT type 4
> > drivers.
> > The difference in the heap usage is now *only* 5% of the 512Mb heap is used
> > at the similar load! This obviously meant that the system could be load much
> > harder until other kernal resources were exceeded.

> > Question:
> > Is this behaviour expected from the IBM drivers? Given that the above
> > comparison was performed on the idneitcal evironments.



Fri, 31 Jan 2003 03:00:00 GMT
 JDBC Type 3 vs Type 4
Both,

There are 2 drivers in that zip file. the .net. and .app. drivers. The
.net. driver connects to the daemon process on the server (db2jd if
memory serves) and the .app. driver uses the client libraries installed
on the client machine. Probably the .app. driver uses JNI to call the
client libs but maybe it uses a local named pipe or something similar.

So you can use either type. Depends on which one you load.

On 14 Aug 2000 02:46:41 GMT esteemed Serge Popov did'st hold forth
thusly:

Quote:
> Little question, db2java.zip from distribution is Type3 or Type2 ?



Sun, 02 Feb 2003 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. JDBC type vs. DATABASE type

2. sql data type vs vb data type

3. mssql data types vs JAVA data types

4. mssql data types vs JAVA data types

5. Array Data Type return what type in JDBC?

6. Informix JDBC driver? (type 4 or type 2)

7. Problems with JDBC and a DISTINCT Boolean Type in a Row Type

8. Informix JDBC driver? (type 4 or type 2)

9. Type, sub-type, and sub-sub-type database design

10. JDBC/ODBC bridge vs. type 3-4 driver

11. How to Create SQL Server Resource Type, SQL Server Agent Resource Type

12. Type Mismatch while using Activex Script Task with numeric data type


 
Powered by phpBB® Forum Software