Problem with locks

[Damir Wilder]

Hello,
does someone know what kind of a lock is an "END" type lock and how/when
does it appear?
How can one avoid it?

This lock in my case appears during a multi-row update on a table (see the
end of this post for the example), where I would only expect to see an IX
lock on the table (present) and one X row lock for each row updated (also
present).
DB2 version is 7.2, EE, fixpak 8
OS = AIX 4.3.3 (ML11)

Any suggestions, links, ...?

Best regards,
Damir Wilder

Snapshot for locks (excerpt):
-----------------------------
Application handle = 0
TABLE NAME TYPE MODE LOCK_ID STATUS ESC TABLESPACE TABLE
SCHEMA
------------------ ------ ---- --------- ------- --- ------------ ----------
--
TR_GEN End X 498 Granted NO USERSPACE1 DB2ADMIN
TR_GEN Row X 1252098 Granted NO USERSPACE1 DB2ADMIN
....
TR_GEN Table IX 87 Granted NO USERSPACE1 DB2ADMIN
----------------------------------------------------------------------------
---

[PM \(pm3iinc-nospam\)]

Could be the end of table object.

PM

"Damir Wilder" <da**********@etna.hr> a écrit dans le message de
news:bv**********@ls219.htnet.hr...

Hello,
does someone know what kind of a lock is an "END" type lock and how/when
does it appear?
How can one avoid it?

This lock in my case appears during a multi-row update on a table (see the
end of this post for the example), where I would only expect to see an IX
lock on the table (present) and one X row lock for each row updated (also
present).
DB2 version is 7.2, EE, fixpak 8
OS = AIX 4.3.3 (ML11)

Any suggestions, links, ...?

Best regards,
Damir Wilder

Snapshot for locks (excerpt):
-----------------------------
Application handle = 0
TABLE NAME TYPE MODE LOCK_ID STATUS ESC TABLESPACE TABLE
SCHEMA
------------------ ------ ---- --------- ------- --- ------------ -------- -- --
TR_GEN End X 498 Granted NO USERSPACE1 DB2ADMIN
TR_GEN Row X 1252098 Granted NO USERSPACE1 DB2ADMIN
...
TR_GEN Table IX 87 Granted NO USERSPACE1 DB2ADMIN
-------------------------------------------------------------------------- -- ---

[Fan Ruo Xin]

"Damir Wilder" <da**********@etna.hr> wrote in message
news:bv**********@ls219.htnet.hr...

Hello,
does someone know what kind of a lock is an "END" type lock and how/when
does it appear?B ===
It is "End of Table". That because you UPDATE the last record of this table.
How can one avoid it? ====
Two ways:
(1). upgrade to Version8.x, which will use type-2 index. Most of the next
key locks will be disappear ...
(2). If you continue use V7.2, then set DB2_RR_TO_RS=yes


This lock in my case appears during a multi-row update on a table (see the
end of this post for the example), where I would only expect to see an IX
lock on the table (present) and one X row lock for each row updated (also
present).
DB2 version is 7.2, EE, fixpak 8
OS = AIX 4.3.3 (ML11)

Any suggestions, links, ...?

Best regards,
Damir Wilder

Snapshot for locks (excerpt):
-----------------------------
Application handle = 0
TABLE NAME TYPE MODE LOCK_ID STATUS ESC TABLESPACE TABLE
SCHEMA
------------------ ------ ---- --------- ------- --- ------------ -------- -- --
TR_GEN End X 498 Granted NO USERSPACE1 DB2ADMIN
TR_GEN Row X 1252098 Granted NO USERSPACE1 DB2ADMIN
...
TR_GEN Table IX 87 Granted NO USERSPACE1 DB2ADMIN
-------------------------------------------------------------------------- -- ---