fixpak enhancements

[aj]

DB2 WSE 8.1 FP5
Red Hat AS 2.1

I'm currently on 8.1 FP5 ("If it ain't broke, don't fix it..").
However, I'm looking at a change to the 2.6 kernel and an
accompanying FP upgrade.

It looks like 2.6 support started in 8.1 FP9 (aka 8.2 FP2).

I have read all of the official release notes subsequent to FP5,
but saw nothing about the following enhancements:
-dropping a column from a table
-adding an identity column to an existing table
-making an existing NULLable column NOT NULL
-adding a default value to an existing column
-changing the type of an existing column
-making an existing CHAR (not VARCHAR) column wider

Have any of these enhancements been added? I'm especially
interested in the first one - dropping a column.

TIA

aj

[Serge Rielau]

aj wrote:

DB2 WSE 8.1 FP5
Red Hat AS 2.1

I'm currently on 8.1 FP5 ("If it ain't broke, don't fix it..").
However, I'm looking at a change to the 2.6 kernel and an
accompanying FP upgrade.

It looks like 2.6 support started in 8.1 FP9 (aka 8.2 FP2).

I have read all of the official release notes subsequent to FP5,
but saw nothing about the following enhancements:
-dropping a column from a table DB2 V8.2 (FP7) introduces a Wizard and a stored proc (ALTOBJ) which
takes care of this in many cases. It's not "native", but it simplifies
the management of schema evolution (dropping, recreating dependent
objects, granting access, export/load, etc..)
-adding an identity column to an existing table Supported natively and online.
-making an existing NULLable column NOT NULL See dropping. ALTOBJ takes care of it.
-adding a default value to an existing column Supported natively and online.
-changing the type of an existing column See dropping. -making an existing CHAR (not VARCHAR) column wider

See dropping.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab