Record Locking Problems
Sean Hadnum upgraded to IDS 9.41 on Red Hat 8 and found row-lock-mode tables apparently locking other rows too. Konstantin Kaduk suggested index key locking and asking for the ISAM error. Richard Snoke called it a known problem, to check for the fix to bug 166507 and ask support about IFMX_UNDOC_B151523. Hamid Habzi suggested checking isolation level. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi,
I have just upgraded from SCO Unix and IDS 7.31 to Linux Redhat 8 and IDS 9.41.
The problem i'm having is tables created with 'lock mode row', it isn't doing
what it says and appears to be page level locking. I've used 'oncheck' and it
confirms the table is set to "lock mode row".
when I lock a single row for update it is locking other rows aswell, not all
rows but some!!
Is there a problem with using "lock mode row" on this version of IDS and/or
redhat 8??
Any help would be much appreciated.
Thanks
Sean
Hi.
Do you have any indexes on the table?
Do you attempt to update indexed row?
If yes, server can lock a rows which have same index keys with your row.
Can you give ISAM error. It can make clear the situation.
Best regards, Konstantin
----- Original Message -----
From: "SEAN HADNUM" <seanh@shoepack.com>
To: <ids@iiug.org>
Sent: Tuesday, November 16, 2004 10:49 AM
Subject: Record Locking Problems [3695]
> Hi,
>
> I have just upgraded from SCO Unix and IDS 7.31 to Linux Redhat 8 and IDS
> 9.41.
>
> The problem i'm having is tables created with 'lock mode row', it isn't
> doing what it says and appears to be page level locking. I've used
> 'oncheck' and it confirms the table is set to "lock mode row".
>
> when I lock a single row for update it is locking other rows aswell, not
> all rows but some!!
>
> Is there a problem with using "lock mode row" on this version of IDS
> and/or redhat 8??
>
> Any help would be much appreciated.
>
> Thanks
> Sean
>
>
>
>
Hi,
I have seen this before. Its a known problem. Check that you have the
fix to bug 166507, and ask tech support about the IFMX_UNDOC_B151523
environment variable.
Cheers,
Dick Snoke
Consulting IT Specialist
dsnoke@us.ibm.com
404 487 1595
"SEAN HADNUM" <seanh@shoepack.com>
Sent by: forum.subscriber@iiug.org
11/16/2004 03:49 AM
To
ids@iiug.org
cc
Subject
Record Locking Problems [3695]
Hi,
I have just upgraded from SCO Unix and IDS 7.31 to Linux Redhat 8 and IDS
9.41.
The problem i'm having is tables created with 'lock mode row', it isn't
doing what it says and appears to be page level locking. I've used
'oncheck' and it confirms the table is set to "lock mode row".
when I lock a single row for update it is locking other rows aswell, not
all rows but some!!
Is there a problem with using "lock mode row" on this version of IDS
and/or redhat 8??
Any help would be much appreciated.
Thanks
Sean
Hi,
Check for the isolation level.
-----Message d'origine-----
De : Richard Snoke [mailto:dsnoke@us.ibm.com]
Envoyé : mardi 16 novembre 2004 13:44
À : ids@iiug.org
Objet : Re: Record Locking Problems [3699]
Hi,
I have seen this before. Its a known problem. Check that you have the
fix to bug 166507, and ask tech support about the IFMX_UNDOC_B151523
environment variable.
Cheers,
Dick Snoke
Consulting IT Specialist
dsnoke@us.ibm.com
404 487 1595
"SEAN HADNUM" <seanh@shoepack.com>
Sent by: forum.subscriber@iiug.org
11/16/2004 03:49 AM
To
ids@iiug.org
cc
Subject
Record Locking Problems [3695]
Hi,
I have just upgraded from SCO Unix and IDS 7.31 to Linux Redhat 8 and IDS
9.41.
The problem i'm having is tables created with 'lock mode row', it isn't
doing what it says and appears to be page level locking. I've used
'oncheck' and it confirms the table is set to "lock mode row".
when I lock a single row for update it is locking other rows aswell, not
all rows but some!!
Is there a problem with using "lock mode row" on this version of IDS
and/or redhat 8??
Any help would be much appreciated.
Thanks
Sean