Hi Guys:

I ran the exact following statement:

Alter table THBK0 modify GL_ref char(9);

to alter the column gl_ref to char(9).. it was previously char(6). The table has around 20 columns and record count of 250,000. This statement ran for 3 hours and i had to kill it.

Can anyone help me, what is going on or wrong here? Thank you.