now to prevent space management page deadlocks???

Discussion created by ca.portal.admin on Jul 12, 2010
Latest reply on Jul 12, 2010 by ca.portal.admin
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 wh=
ich 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 3rd-party providers 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.) Changing the storage method to a random CALC key will usually solve the problem.