Opportunistic Locking

Discussion in 'Server Networking' started by Terry, Aug 4, 2004.

  1. Terry

    Terry Guest

    I need to check that Opportunistic Locking is ON. How can I do that please?
    Regards
     
    Terry, Aug 4, 2004
    #1
    1. Advertisements

  2. Terry

    Dave Patrick Guest

    Dave Patrick, Aug 4, 2004
    #2
    1. Advertisements

  3. Terry

    Terry Guest

    Thanks Dave,
    Anything regarding Op Locks and Win98 clients with the AD update?
    Regards
     
    Terry, Aug 4, 2004
    #3
  4. Terry

    Dave Patrick Guest

    Sorry but I don't know what you're asking here.

    --
    Regards,

    Dave Patrick ....Please no email replies - reply in newsgroup.
    Microsoft Certified Professional
    Microsoft MVP [Windows]
    http://www.microsoft.com/protect

    :
    | Thanks Dave,
    | Anything regarding Op Locks and Win98 clients with the AD update?
    | Regards
     
    Dave Patrick, Aug 4, 2004
    #4
  5. Terry

    Terry Guest

    Hi Dave,
    I'm getting data corruptions in a database which are most probably due to
    opportunistic locking. If it is set as default on the server then the
    problem may be with the Win98 clients.
    Regards

     
    Terry, Aug 4, 2004
    #5
  6. Terry

    Dave Patrick Guest

    Back in the days when we were still using Access97/2000 I found that setting
    the Reg_Dword "EnableOplocks" to 0
    greatly reduced the corruption issues. The databases were almost never
    corrupt, just that the bit was set to mark it as suspect.

    HKLM\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters

    --
    Regards,

    Dave Patrick ....Please no email replies - reply in newsgroup.
    Microsoft Certified Professional
    Microsoft MVP [Windows]
    http://www.microsoft.com/protect

    :
    | Hi Dave,
    | I'm getting data corruptions in a database which are most probably due to
    | opportunistic locking. If it is set as default on the server then the
    | problem may be with the Win98 clients.
    | Regards
     
    Dave Patrick, Aug 5, 2004
    #6
  7. Terry

    Dave Patrick Guest

    Should have said on the file server.

    "setting the Reg_Dword "EnableOplocks" to 0"

    --
    Regards,

    Dave Patrick ....Please no email replies - reply in newsgroup.
    Microsoft Certified Professional
    Microsoft MVP [Windows]
    http://www.microsoft.com/protect
     
    Dave Patrick, Aug 5, 2004
    #7
  8. Terry

    Terry Guest

    Thanks Dave,
    I'll check that out. Also found that Win98 clients need the DWORD key
    HKLM\System\CurrentControlSet\Services\VxD\Vredir\DiscardCacheOnOpen =
    decimal 1
    Right back from the Win95/NT days apparently.
    Thanks for your help
    Regards
    Terry
     
    Terry, Aug 5, 2004
    #8
  9. Terry

    gr Guest

    Had lots of problem with Goldmine (using Borland BDE) running on XP pro
    as a server and both WIn 98 and xp clients, until I turned off
    opportunistic locking on the server (on or or didn't seem to make any
    difference on the clients)

    Here is some info related:
    -------

    http://www.bdesupport.com/stability.htm

    -----------------

    Answer: If the ACT database is stored on a network server, specifically
    Windows 2000, then I would bet there is a slowdown in network
    communication mechanisms causing the issues. I've seen similar problems
    with GoldMine in a networked environment, including database corruption.
    What it came down to was one of the things I've been harping on over the
    last year or so... SMB Signing and Opportunistic Locking. Microsoft
    really screwed up the signing via service packs, the Windows XP release,
    and some Group Policy involvement mixed in here and there. It's truly
    quite a mess. Here's a place to start:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q814112


    Files on Network Shares Open Slowly or Read-Only or You Receive an Error
    Message:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q814112
     
    gr, Aug 6, 2004
    #9
  10. Terry

    Terry Guest

    Interesting KB article
    Thanks
    Terry

     
    Terry, Aug 6, 2004
    #10
  11. Terry

    Terry Guest

    Hi Dave,
    That key does not exist on my W2K3 server. Should it?
    Regards
     
    Terry, Aug 6, 2004
    #11
  12. Terry

    Dave Patrick Guest

    Good question. I know that MS recognized the problem oplocks caused sometime
    back so it may be disabled by default in 2003. I kind of got away from
    keeping up with that stuff since I quit using access backends for multi-user
    databases three years ago. You might ask them in access.multiuser

    --
    Regards,

    Dave Patrick ....Please no email replies - reply in newsgroup.
    Microsoft Certified Professional
    Microsoft MVP [Windows]
    http://www.microsoft.com/protect

    :
    | Hi Dave,
    | That key does not exist on my W2K3 server. Should it?
    | Regards
     
    Dave Patrick, Aug 7, 2004
    #12
  13. Terry

    Roland Hall Guest

    in message : Thanks Dave,
    : I'll check that out. Also found that Win98 clients need the DWORD key
    : HKLM\System\CurrentControlSet\Services\VxD\Vredir\DiscardCacheOnOpen =
    : decimal 1
    : Right back from the Win95/NT days apparently.

    Since hex is the default, it will probably work and setting it to decimal to
    enter the 1 might not be required. Hex 1 and decimal 1 are treated the
    same, sometimes.

    Since 98 will soon be 7 years old...
    Here is something else that might be helpful...

    HKLM\System\CurrentControlSet\Services\VxD\Vredir\Upgrade98-XPOnOpen = 1

    You'll need to reboot after making the change.
    You'll be prompted with "Please insert Microsoft Windows XP Upgrade CD and
    press any key to continue" upon reboot. (O:=

    --
    Roland Hall
    /* This information is distributed in the hope that it will be useful, but
    without any warranty; without even the implied warranty of merchantability
    or fitness for a particular purpose. */
    Online Support for IT Professionals -
    http://support.microsoft.com/servicedesks/technet/default.asp?fr=0&sd=tech
    How-to: Windows 2000 DNS:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;308201
    FAQ W2K/2K3 DNS:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;291382
     
    Roland Hall, Aug 7, 2004
    #13
  14. Terry

    Terry Guest

    Hi Dave,
    Just an update having got some support for an Act database corruption. Sage
    Line100 (Dos program) and Act are both owned by Sage. The recommendation for
    the Line100 program is to enable OpLocks on the client and server. The
    recommendation for Act (other databases) is disable OpLocks on client and
    server. Conflicting advice from Sage considering that they are intergrating
    both products!

    Having made them aware of the issues they are now advising disabling OpLocks
    on client and server for both products. Lets hope it works. I will find out
    on Monday when I have had time to make all the necessary registry hacks and
    rebooted the server.

    Regards
     
    Terry, Aug 20, 2004
    #14
  15. Terry

    Dave Patrick Guest

    Terry,
    Thanks very much for the update on this.

    --
    Regards,

    Dave Patrick ....Please no email replies - reply in newsgroup.
    Microsoft Certified Professional
    Microsoft MVP [Windows]
    http://www.microsoft.com/protect

    :
    | Hi Dave,
    | Just an update having got some support for an Act database corruption.
    Sage
    | Line100 (Dos program) and Act are both owned by Sage. The recommendation
    for
    | the Line100 program is to enable OpLocks on the client and server. The
    | recommendation for Act (other databases) is disable OpLocks on client and
    | server. Conflicting advice from Sage considering that they are
    intergrating
    | both products!
    |
    | Having made them aware of the issues they are now advising disabling
    OpLocks
    | on client and server for both products. Lets hope it works. I will find
    out
    | on Monday when I have had time to make all the necessary registry hacks
    and
    | rebooted the server.
    |
    | Regards
     
    Dave Patrick, Aug 21, 2004
    #15
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.