tables are appearing at least twice

[Former Member]

Hi!

Is it OK if SM12's "LOCK Entry List" looks like as follows:

Some tables are appearing at least twice ore more with the lock mode E.

Is it acceptable.

Please give me a hint, is it possible that such a scenario may cause

an error output

Some of the selected &1 are being processed

*see se91

Error Type: E

Id: C$

Message Number: 162

regards

sas

011	Thealy	21:19:47	E	CCIHT_ACH	01100000000000000153354####################	1	0
011	Thealy	21:19:47	E	CCIHT_IP	01100000000000000153325####################	1	0
011	Thealy	21:19:47	E	CCIHT_IPEVA	01100000000000000153326####################	1	0
011	Thealy	21:19:47	E	ESTDF	01100000000000000153354####################	1	0
011	Thealy	21:26:00	E	CCIHT_IAL	01100000000000000153354####################	1	1
011	Thealy	21:26:00	E	CCIHT_IHVA	01100000000000000153354####################	1	1
011	Thealy	21:26:00	E	CCIHT_IP	01100000000000000153354####################	2	1
011	Thealy	21:26:00	S	KSSKX	011100YXE_RET_MAL_0010  O0000000000000015355700000000000000004348	0	3
011	Thealy	21:26:00	S	KSSKX	011100YXE_RET_MAL_0089    O0000000000000015355800000000000000004349	0	3




011	Thealy	00:38:27	E	CCIHT_IP	01100000000000000153325####################	1	0
011	Thealy	00:38:27	E	CCIHT_IP	01100000000000000153354####################	1	0
011	Thealy	00:38:27	E	CCIHT_IP	01100000000000000153358####################	1	0
011	Thealy	00:38:27	E	CCIHT_IPEVA	01100000000000000153326####################	1	0
011	Thealy	00:38:27	E	CCIHT_IPEVA	01100000000000000153375####################	1	0
011	Thealy	01:16:56	E	CCIHT_ACH	01100000000000000153015####################	1	1
011	Thealy	01:16:56	E	CCIHT_IAL	01100000000000000153015####################	1	1
011	Thealy	01:16:56	E	CCIHT_IHVA	01100000000000000153015####################	1	1
011	Thealy	01:16:56	E	CCIHT_IP	01100000000000000153015####################	2	1
011	Thealy	01:16:56	E	CCIHT_IPEVA	01100000000000000153016####################	2	1
011	Thealy	01:16:56	E	CCIHT_IPEVA	01100000000000000153017####################	2	1
011	Thealy	01:16:56	E	CCIHT_IPEVA	01100000000000000153018####################	2	1
011	Thealy	01:16:56	E	ESTDF	01100000000000000153015####################	1	1

[former_member485701 · Accepted solution]

Hi,

E stands for exclusive lock means at that time no body else can get lock on that table.

S stands for shared lock means others can not get exclusive lock but others can get shared lock.

For same table it is showing two locks. but those locks are at different time.So this looks fine to me.

Regards,

Praveen

[Former Member]

Hi Kumar,

ok but look at these lines

011	Thealy	01:16:56	E	CCIHT_ACH	01100000000000000153015####################	1	1
011	Thealy	01:16:56	E	CCIHT_IAL	01100000000000000153015####################	1	1
011	Thealy	01:16:56	E	CCIHT_IHVA	01100000000000000153015####################	1	1
011	Thealy	01:16:56	E	CCIHT_IP	01100000000000000153015####################	2	1
011	Thealy	01:16:56	E	CCIHT_IPEVA	01100000000000000153016####################	2	1
011	Thealy	01:16:56	E	CCIHT_IPEVA	01100000000000000153017####################	2	1
011	Thealy	01:16:56	E	CCIHT_IPEVA	01100000000000000153018####################	2	1
011	Thealy	01:16:56	E	ESTDF	01100000000000000153015####################

CCIHT_IPEVA is appearing three times to the same time .

Regards

sas

Edited by: erdem sas on Mar 10, 2008 10:50 AM