Hi,

I'm an Oracle DBA switching to DB2 UDB (8.1.3)
I want to know how experienced DB2 DBA are managing development environments.

With Oracle 8i I can :
drop a column
increase the size of a number column
add a not null column to an empty table
decrease the size of a column (varchar2 and number)) if the table is empty.
With Oracle 9i I can
rename a column even if it is part of an index
....

With DB2 UDB I must drop and recreate the table, I hope that's because I do not know the product well yet.
Is there another way around or any tool that would make this work less time consuming ?

Thanks


Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 stephane.[Email Address Removed] <mailto:stephane.[Email Address Removed]

DB2 & UDB email list listserv db2-l LazyDBA home page