I have a table in DB2 which is having 99 columns and 900,000 records of data.
I want to alter the table with one extra column as below:
ALTER TABLE MYSCHEMA.PRODUCT ADD UPDATE_DT DATE
However, the query never completes and the status of the table shows locked against my id in the APPLICATION LIST window from where I have to force kill it.
I believe this is because of the huge amount of data present.
Am I missing anything here ? How can I achieve what I am trying to do ?