SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 05:19 AM
| ||||
| ||||
 fixpak enhancements 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      |
|
02-27-2008, 05:19 AM
| ||||
| ||||
| Re: fixpak enhancements 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 |
Linear Mode
