How to rename columns on DB2 9.7
using the ALTER TABLE statement
The RENAME COLUMN clause is a new option on the ALTER TABLE statement. You can now rename an existing column in a base table to a new name without losing stored data
ALTER TABLE <tabname> RENAME COLUMN <column_name> TO <new_column_name>