Hey all - I was wondering if anyone has come accross this situation before. We have a relatively simple table (below). And it seems that during high insert loads, we see long running transactions and locking. But what I was surprised to see was that the lock was coming out of the SYSCOLUMNS table. The only thing I was suspect of was whether or not that it's the IDENTITY on the first field that might be contributing here.
Some additional info follows, but if there is a specific piece that would also help, let me know and I can reply with it.
CREATE TABLE "TEST"."INFO" (
"SEQUENCE" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),