http://www-01.ibm.com/support/docvie...id=swg24027906

For those enabling Oracle Apps to DB2 here's the loot:
* No more worries about the "purity level" of PL/SQL functions
DB2 will enforce READS SQL DATA by context now.
* Up to 10x NUMBER arithmetic performance improvements
* RATIO_TO_REPORT OLAP function
(A synonym for <expr>/SUM(<expr>) OVER(..)
* RAISE_APPLICATION_ERROR supports variables now
* 32K pagesize limitations can effectively be overcome
by LOBifying those VARCHAR2(4000) columns because
DB2 now supports LOB comparisons for small LOBS
* There are also a bunch of improvements to CLPPlus


Cheers
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

"Serge Rielau" <srielau (AT) ca (DOT) ibm.com> wrote

9.7 FP3 for Linux 64-bit, x86-64 on AMD64 and Intel EM64T is missing (looks
like the others are all there).

Also, the FP3 Fix List of APARs does not show any for FP3.

Hi,
the "Fix list" page seems to not have been updated - I can only see APARs
for FPs 01 and 02
(http://www-01.ibm.com/support/docvie...id=swg21412438)

I am particularly interested to find out if APAR IC69509 is included in
FP03.

Regards,
Damir


"Serge Rielau" <srielau (AT) ca (DOT) ibm.com> wrote

"Damir" <damirwilder (AT) yahoo (DOT) com> wrote

That was already mentioned, along with that the fixpack for Linux-64 bit for
AMD and Intel EMT is missing.

The page has (just) been updated, thank you!

Damir


---
"Damir" <damirwilder (AT) yahoo (DOT) com> wrote

"Damir" <damirwilder (AT) yahoo (DOT) com> wrote

But still no FP3 for Linux 64 bit on AMD and Intel

On 9/13/2010 11:19 AM, Mark A wrote:
When I spoke to those responsible yesterday they said they we in the
process of uploading.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

"Serge Rielau" <srielau (AT) ca (DOT) ibm.com> wrote

Linux 64-bit AMD/Intel is now available.

Serge Rielau wrote:
On that page there is a link called "FP3 HIPER and Security APARs" linking
to http://www.ibm.com/support/docview.wss?uid=swg21446455

However, following the link leads to a page:

============================
Fejl

Dokumentet er ikke fundet
============================

- which is Danish for

Failure
Document not found

--
Troels

On 9/16/2010 7:34 AM, Troels Arvin wrote:
http://www-01.ibm.com/support/docvie...id=swg21446455
Abstract
Fix Pack 3 for DB2 V9.7 is now available which includes fixes for some
security vulnerabilities and HIPER APARs. These fixes, where applicable,
are also available in Fix Pack 9 for DB2 Version 9.1 and Fix Pack 6 for
DB2 Version 9.5.

IBM® recommends that you review the APAR descriptions and deploy one of
the above fix packs to correct them on your affected DB2 installations.

Content
A set of security vulnerabilities was discovered in some DB2 database
products. These vulnerabilities were analyzed by the DB2 development
organization and a set of corresponding fixes was created to address the
reported issues. IBM is not currently aware of any externally reported
incidents where production DB2 installations have been compromised due
to these issues.
The affected DB2 UDB for Linux, UNIX, and Windows products are:

* DB2 Enterprise Server Edition
* DB2 Workgroup Server (all Editions)
* DB2 Express Server (all Editions)
* DB2 Personal Edition
* DB2 Connect Server (all Editions)


DB2 Client component and DB2 products or components other than those
listed above are not affected.

Due to the complexity of the fixes required to eliminate the reported
service issues, it is not feasible to retrofit the same fixes into
earlier DB2 Version 9.1, DB2 Version 9.5 and DB2 Version 9.7 fix packs.

The specifics of the Security APARs incorporated into the above DB2 fix
packs can be found in the following table:


Security APARs


V9.1
FP9

V9.5
FP6

V9.7
FP3

ABSTRACT
IC68015 SECURITY: FUNCTIONS ARE NOT INVALIDATED NOR DROPPED EVEN WHEN
THE OWNER LOSES SUFFICIENT PRIVILEGE TO ACCESS UNDERLYING OBJECTS.
IC70406 SECURITY: UPDATE AGAINST A TABLE VIA A COMPOUND SQL (COMPILED)
STATEMENT MAY BE EXECUTED BY USER WTHOUT REQUIRED PRIVILEGES



In addition to the Security APARs, here is a list of HIPER APARs
included in these fix packs of which you should be aware.


HIPER APARs


V9.1
FP9

V9.5
FP6

V9.7
FP3

ABSTRACT
IC69772 POTENTIAL CORRUPTION WHEN REPLAYING LOG RECORDS THAT INSERT
KEYS INTO AN INDEX AND TRIGGER PAGE SPLITS



DB2 fix packs for all supported versions can be downloaded at the
following site: http://www.ibm.com/support/docview.wss?uid=swg27007053

The DB2 team will continue to have a strong focus on delivering timely
fixes for newly discovered issues along with information that helps our
customers to decide on an appropriate course of action. The DB2 team
regrets the inconvenience that these issues are causing to you, our
customers. We believe that our actions are the most prudent steps to
address your concerns and remain open to suggestions on how to further
improve our processes.

My Notifications
Sign-up to receive e-mail notification of changes to this document.
1. Sign in to My Notifications
2. select Subscribe tab
3. select "Information Management" from the Software column
4. select the check box for "DB2 9 for Linux, UNIX and Windows"
click the Continue button.
5. select the check box for "Flashes" and all other document types
click the Submit button.

For more information about My Notifications please click on

* the Benefits and features or
* Read the overview or
* take an guided tour of My Notifications.
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab