DB2 Fixpak 9 now available for LUW

[Mark A]

Also, noticed there is now a separate fixpak 9 for Linux 2.6 Kernel in
addition to the regular Linux fixpaks.

[Buck Nuggets]

unfortunately, it's labeled as fixpack 8 for the aix 5 version:
http://www-306.ibm.com/software/data...ownloadv8.html

any idea of how much of an impact the direct & concurrent io tempspaces
will have on warehousing apps?

buck

[bwmiller16]

Can IBM explain why this is necessary, please?

Bruce

Buck Nuggets wrote:

unfortunately, it's labeled as fixpack 8 for the aix 5 version:
http://www-306.ibm.com/software/data...ownloadv8.html
any idea of how much of an impact the direct & concurrent io tempspaces will have on warehousing apps?

buck

[Serge Rielau]

bw********@yahoo.com wrote:

Can IBM explain why this is necessary, please?

Bruce

Buck Nuggets wrote:

unfortunately, it's labeled as fixpack 8 for the aix 5 version:

http://www-306.ibm.com/software/data...ownloadv8.html

any idea of how much of an impact the direct & concurrent io

tempspaces

will have on warehousing apps?

buck

Are you referring to buck's question (which I can't answer) or the
obvious typo (which I have reported)?

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[bwmiller16]

I'm referring to the separate FP9 for Linux 2.6 kernals...this seems
very unusual. Will we be thread specific in the future?

Bruce

[Larry]

Perhaps there is maintenance specific for the Linux 2.6 kernel or
perhaps there is something about the Linux 2.6 kernel that requires
something in the fixpak install to be different. I don't think IBM would
go out of its way to have fixpaks that are thread specific if it wasn't
necessary. But perhaps Serge or Darin can find out more.

Larry Edelstein

bw********@yahoo.com wrote:

I'm referring to the separate FP9 for Linux 2.6 kernals...this seems
very unusual. Will we be thread specific in the future?

Bruce

[Mark A]

<bw********@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I'm referring to the separate FP9 for Linux 2.6 kernals...this seems
very unusual. Will we be thread specific in the future?

Bruce

The reason is to support asynchronous I/O and vector I/O performance
enhancements that are only available with the 2.6
kernel. I don't believe it is mandatory that you use the special fixpak for
2.6 kernel if you don't need the I/O enhancements (not 100% sure).

The enhancement is described in "New in this Release" section of the Release
Notes. However there is an errata in the FixPackReadme.txt that comes with
the Fixpack in section: "3.1.2 Correction to the Version 8.2.2 Release Notes
(Linux)."
..

[Darin McBride]

bw********@yahoo.com wrote:

I'm referring to the separate FP9 for Linux 2.6 kernals...this seems
very unusual. Will we be thread specific in the future?

To take full advantage of the 2.6 kernel on x86 and x86-64 platforms,
we need to compile with a newer compiler. We can also remove checks
for the kernel level from the code - the fact DB2 doesn't crash on
startup implies we're on a 2.6 kernel, and can take advantage of
certain features.

DB2 will continue to be kernel-specific on these platforms for the life
of version 8, so that we can continue to support RHEL3, SLES8, and
other distributions that were supported at the GA of v8.2 (or v8.1).

I cannot speak to what future versions of DB2 will be like.

[bwmiller16]

I would definitely like to know if this is mandatory or not...I'd hate
to install the standard FP9 with our 2.6 kernal only to find out the
hard-way that the special FP9 for 2.6 was required.

Thanks guys,

Bruce

Mark A wrote:

<bw********@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I'm referring to the separate FP9 for Linux 2.6 kernals...this seems very unusual. Will we be thread specific in the future?

Bruce
The reason is to support asynchronous I/O and vector I/O performance
enhancements that are only available with the 2.6
kernel. I don't believe it is mandatory that you use the special

fixpak for 2.6 kernel if you don't need the I/O enhancements (not 100% sure).

The enhancement is described in "New in this Release" section of the Release Notes. However there is an errata in the FixPackReadme.txt that comes with the Fixpack in section: "3.1.2 Correction to the Version 8.2.2 Release Notes (Linux)."
.

[Serge Rielau]

Larry wrote:

Perhaps there is maintenance specific for the Linux 2.6 kernel or
perhaps there is something about the Linux 2.6 kernel that requires
something in the fixpak install to be different. I don't think IBM would
go out of its way to have fixpaks that are thread specific if it wasn't
necessary. But perhaps Serge or Darin can find out more.

Larry Edelstein

bw********@yahoo.com wrote:

I'm referring to the separate FP9 for Linux 2.6 kernals...this seems
very unusual. Will we be thread specific in the future?

Bruce

This will likely continue into the future. From what I understand the
main issue is the "gcc ABI" (I'm parrotting I confess). To have a stream
that specifically exploit 2.6 features is a pleasant side-effect.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[bwmiller16]

I agree it is always nice to exploit 2.6 features...but will I be in
trouble if I do not apply the 2.6 FP9 to a Linux 2.6 installation?

If there is trouble then I hope the support center has been trained to
spot the error!

[Serge Rielau]

bw********@yahoo.com wrote:

I agree it is always nice to exploit 2.6 features...but will I be in
trouble if I do not apply the 2.6 FP9 to a Linux 2.6 installation?

If there is trouble then I hope the support center has been trained to
spot the error!

My gut feeling is that it's wise to go with that FP if you use the 2.6
Kernel. I doubt that the 2.4 install will be tested as thoroughly
against 2.6 as the 2.6 install...

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[bwmiller16]

Serge -

I agree. My point here I guess is that I personally didn't see the
2.6-specific FP9 release until I saw it mentioned here on the board and
I bet others may not see it as well, this evidently being the
first-time for a thread-specific release. I'll know next time to look
for it but this first time might cause some angst amongst folks.

-B

[Mark A]

<bw********@yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Serge -

I agree. My point here I guess is that I personally didn't see the
2.6-specific FP9 release until I saw it mentioned here on the board and
I bet others may not see it as well, this evidently being the
first-time for a thread-specific release. I'll know next time to look
for it but this first time might cause some angst amongst folks.

-B

Hi Bruce,

It was mentioned in the FixPackReadme.txt file.

[Darin McBride]

bw********@yahoo.com wrote:

I would definitely like to know if this is mandatory or not...I'd hate
to install the standard FP9 with our 2.6 kernal only to find out the
hard-way that the special FP9 for 2.6 was required.

Thanks guys,

Bruce

The 2.4-kernel-based fixpak should not permit an install on a 2.6
kernel system (on x86 and x86-64 only). Thus, if you use
installFixPak, you should already be protected.

Thus, yes, it is mandatory.

[Jurgen Haan]

Mark A wrote:

Also, noticed there is now a separate fixpak 9 for Linux 2.6 Kernel in
addition to the regular Linux fixpaks.

And why doesn't this one come in 64bit?

-R-

[Mark A]

"Jurgen Haan" <ju****@fake.dom> wrote in message
news:42*********************@news.xs4all.nl...

Mark A wrote:

Also, noticed there is now a separate fixpak 9 for Linux 2.6 Kernel in
addition to the regular Linux fixpaks.

And why doesn't this one come in 64bit?

-R-

There is one for AMD 64-bit, but not Intel 64-bit.

[Jurgen Haan]

Mark A wrote:

"Jurgen Haan" <ju****@fake.dom> wrote in message
news:42*********************@news.xs4all.nl...

Mark A wrote:

Also, noticed there is now a separate fixpak 9 for Linux 2.6 Kernel in
addition to the regular Linux fixpaks.

And why doesn't this one come in 64bit?

-R-

There is one for AMD 64-bit, but not Intel 64-bit.

An AMD 64bit 2.6 FP9? Didn't see it between the other FP.
Can you please tell me where I can find it?
(Running DB2 on an Opteron here :P)

-R-

[Mark A]

"Jurgen Haan" <ju****@fake.dom> wrote in message
news:42*********************@news.xs4all.nl...

There is one for AMD 64-bit, but not Intel 64-bit.

An AMD 64bit 2.6 FP9? Didn't see it between the other FP.
Can you please tell me where I can find it?
(Running DB2 on an Opteron here :P)

-R-

http://www-306.ibm.com/software/data...ownloadv8.html

[Jurgen Haan]

Mark A wrote:

"Jurgen Haan" <ju****@fake.dom> wrote in message
news:42*********************@news.xs4all.nl...

There is one for AMD 64-bit, but not Intel 64-bit.

An AMD 64bit 2.6 FP9? Didn't see it between the other FP.
Can you please tell me where I can find it?
(Running DB2 on an Opteron here :P)

-R-

http://www-306.ibm.com/software/data...ownloadv8.html

DOH! totally read over that one...
Thanks.

-R-

[Serge Rielau]

Buck Nuggets wrote:

unfortunately, it's labeled as fixpack 8 for the aix 5 version:
http://www-306.ibm.com/software/data...ownloadv8.html

any idea of how much of an impact the direct & concurrent io tempspaces
will have on warehousing apps?

buck

Typo should be fixed now. Tx for the notification.

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab