We have 2 applications accessing the same table.
I have all my insert queries within a transaction which is committed at the end.
However if my transaction is in process and i try to run a select on the same table, it seems like my application is locking the table.I don't want this behavior since the other application would be affected, we are using identity columns so we are fine with multiple applications inserting data at the same time.I have tried changing the isolation level which doesnt help either.Any input will be appreciated.We are using DB2 database.

Thanks