Hi,

What are the possible ways to change the data type of a column from
BigInt to Integer?

the normal command
Alter table <tabname> alter column <colname> set data type Integer
gives the error
SQL0190N  ALTER TABLE <table> specified attributes for column "VALUE"
that are not compatible with the existing column.  SQLSTATE=42837

Why is it failing, when i have only 2 records in the table which are
less than the value that Integer will take.

What could be other possible ways of changing the data type?
Dropping and recreating the column could be an option but the data
might be lost in such a case..

Also, what considerations need to be taken (while altering the data
type or while dropping it and recreating it) if there are indexes
existing on that column.

Thanks a lot.

Rahul Babbar