Re:now to prevent space management page deadlocks???

Discussion created by ca.portal.admin on Jul 12, 2010
i think we all know the bad programming code that can lead to db-key
deadlocks - but are SMP deadlocks just a matter of coincidence?
can they just occur because of where record occurrence STORES or DELETES
(or MODIFYs) are intended to take place?

Chris Hoelscher
IDMS/DB2 System & Database Architect
Humana Inc

you only need to test the programs that you want to work correctly

The information transmitted is intended only for the person or entity to
which it is addressed and may contain CONFIDENTIAL material. If you
receive this material/information in error, please contact the sender
and delete or destroy the material/information.
IDMS Public Discussion Forum


Re: now to prevent space management page deadlocks???

They sure can. Try doing an EXTEND SPACE on a busy area without following =
it up with a proper UNLOAD/RELOAD, and watch what happens. It's not pretty=

You will see a series of lock manager abends on one space management page. =
After a while, they will switch to the next SMP. Then to the next one.

These are technically not deadlocks, but lock manager timeouts.

You can get a similar effect by defining the storage mode of a busy record =
type as DIRECT or VIA an index. (By ""busy"", I mean lots of stores.) Chang=
ing the storage method to a random CALC key will usually solve the problem.