UDF on DB2 V7.2 and AIX V5.2

[Arne Dörnenburg]

Hello everybody,

we got new servers with AIX V5.2 and, as i was told,
for the combination DB2 V7.2 and AIX V5.2
a) the "old" Java versions like 1.1.8 cannot be installed anymore
b) the "new" Java runtime like 1.3.0/1.3.1 are not supported (and do not
run)

So, it seems, that my Java-UDF's (and possibly Stored Procedures too) will
not run anymore.
because, until all of our productive software is positively tested with V8
(will need about 4-6 months), i am not allowed to upgrade to V8.

My colleagues are not able to get this to run
(one possibility works:
1. install AIX 4.3 and Java 1.1.8
2. upgrade to AIX 5.2
but the servers we get, come with AIX 5.2 already installed,
and our policies do not allow to change them).

Any idea, how to get the UDF's to run?
Thx in advance.
Arne (somewhat desperated).

[Jan M. Nelken]

Arne Dörnenburg wrote:

Hello everybody,

we got new servers with AIX V5.2 and, as i was told,
for the combination DB2 V7.2 and AIX V5.2
a) the "old" Java versions like 1.1.8 cannot be installed anymore
b) the "new" Java runtime like 1.3.0/1.3.1 are not supported (and do not
run)

So, it seems, that my Java-UDF's (and possibly Stored Procedures too) will
not run anymore.
because, until all of our productive software is positively tested with V8
(will need about 4-6 months), i am not allowed to upgrade to V8.

My colleagues are not able to get this to run
(one possibility works:
1. install AIX 4.3 and Java 1.1.8
2. upgrade to AIX 5.2
but the servers we get, come with AIX 5.2 already installed,
and our policies do not allow to change them).

Any idea, how to get the UDF's to run?
Thx in advance.
Arne (somewhat desperated).

Best method is to install *SUPPORTED* version of DB2 - which is either V8.1 or
V8.2 (V8.2 = V8.1 + FP7a).

DB2 V7.2 End of Service was October 31, 2004.

Jan M. Nelken

[Jan M. Nelken]

Arne Dörnenburg wrote:

Hello everybody,

we got new servers with AIX V5.2 and, as i was told,
for the combination DB2 V7.2 and AIX V5.2
a) the "old" Java versions like 1.1.8 cannot be installed anymore
b) the "new" Java runtime like 1.3.0/1.3.1 are not supported (and do not
run)

So, it seems, that my Java-UDF's (and possibly Stored Procedures too) will
not run anymore.
because, until all of our productive software is positively tested with V8
(will need about 4-6 months), i am not allowed to upgrade to V8.

My colleagues are not able to get this to run
(one possibility works:
1. install AIX 4.3 and Java 1.1.8
2. upgrade to AIX 5.2
but the servers we get, come with AIX 5.2 already installed,
and our policies do not allow to change them).

Any idea, how to get the UDF's to run?
Thx in advance.
Arne (somewhat desperated).

Best method is to install *SUPPORTED* version of DB2 - which is either V8.1 or
V8.2 (V8.2 = V8.1 + FP7a).

DB2 V7.2 End of Service was September 30, 2004.

Jan M. Nelken

[Arne Dörnenburg]

Good morning.

Arne Dörnenburg wrote:

[ lots of explanations ]
[...problems...] because, until all of our productive software is positively tested with V8 (will need about 4-6 months), i am not allowed to upgrade to V8.

Jan M. Nelken wrote: Best method is to install *SUPPORTED* version of DB2 - which is either V8.1 or V8.2 (V8.2 = V8.1 + FP7a).

Yes Jan,
you are right. But sometimes, in a big company, things don't go as expected.
We are testing our SW since 2003 on V8 but did not finish as planned, in the
mids of 2004.

Anyway, the problem *is* there.
Arne.

[Jan M. Nelken]

Arne Dörnenburg wrote:

Good morning.

Arne Dörnenburg wrote:

[ lots of explanations ]
[...problems...] because, until all of our productive software is
positively tested with V8
(will need about 4-6 months), i am not allowed to upgrade to V8.

Jan M. Nelken wrote:

Best method is to install *SUPPORTED* version of DB2 - which is either

V8.1 or

V8.2 (V8.2 = V8.1 + FP7a).

Yes Jan,
you are right. But sometimes, in a big company, things don't go as expected.
We are testing our SW since 2003 on V8 but did not finish as planned, in the
mids of 2004.

Anyway, the problem *is* there.
Arne.

I am confused - as you are saying you are getting new servers with Aix 5.2
preinstalled. Until now were you running Aix 4.3.3?

Aix 4.3 is out of service for almost a year. So - in essence you were out of
service on both OS and database? Nice.

V7.2 was working with JDK 1.1.8, 1.2.2, 1.3.1:

Aix JDK JDBC 1.2 JDBC 2.0
--------------------------------------------------------
4.2.1 1.1.8 YES NO
4.3.3 1.1.8 YES NO
4.3.3 1.2.2 YES YES
4.3.3.10 1.3 YES YES

Aix 5.x only in 32-bit mode:
5 1.1.8 YES NO
5 1.2.2 YES YES
5.1 1.3 YES YES
5.1 1.4.1 SR1 YES YES
5.2 1.4.1 SR1 YES YES

JAVA stored procedures and UDF's were not supported in JDK 1.3.x on Aix
JAVA stored procedures were not supported in JDK 1.4.x on Aix 5.x

Did you try IBM JDK 1.2.2?

Jan M. Nelken