When altering a table to add a column – char(01) not null with default.
Question – does the table first need stopped at commit and started in UT status – then alter to add new column?
Or just add new column while table is in RW status?
Maybe it depends on how much the table is accessed? This is a very large table accessed by many applications on a 7x24 basis.
Thanks everyone for the helpful responses !