ALTER TABLE <name> ADD COLUMN Hangs

[Samuel Stearns <SStearns@xxxxxxxxxxxxxxxx>]

Howdy,

 

I’m running in an 8.3.3 environment.  What could cause, or how can I diagnose, why an ‘ALTER TABLE <name> ADD COLUMN’ statement runs for hours eventually locking users out and requiring to be killed in the end?

 

Thanks,

 

Sam