can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
yes possible. until the updation or selection is committed db2 table will not be restructured. new column definition will be there but it will not be included until all the tasks on the table are committed.