Hi

I have a table with a numeric Primary Key. This key is composed of NNRRRRRRRRR where NN is the week since the system went live and RR is a randomly generated number.

Multiple programs simultaneously try to read data from this table while others could be creating records on it at the same time. This causes the programs that only wants to read data to wait as the record might be on the same page as records being created/updated. We implement page locking and the DBA's are unwilling to implement record locking on this table.

We cannot randomise the key, because another process is running in multiple threads and depends on these records to be "grouped" in order not to content with each other.

When you do a WITH UR read everything works nice and fast, but I am reluctant to implement an uncommitted read on data that is used in transaction processing. O! and make the programming language Cobol.

What else can be done? I don't know DB2 that well and am running out of ideas.

Thanks in advance