what happens if a long calculation (update) is working on a table
using "alter table not logged initially" and other users try to access
the same table within other connections (and not using "not logged
initially")?

JH

On May 5, 6:32*am, John Hopfield <Hopfi... (AT) freemail (DOT) it> wrote:
When an application executes ALTER TABLE ... ACTIVATE NOT LOGGED
INITIALLY, it gets a super-exclusive (Z) lock on the table.

No other access to the table will be allowed until the application
that issued the ALTER TABLE statement commits. Other applications
will go into lock-wait state until they either time out (SQL0911N
RC=68) or they are granted the locks they need.