Row Locks When Transaction Logging is turned off

I was running an update statement with Transaction Logging (Buffered) turned off and noticed that HDR+IX type locks were being placed on rows. The odd thing is that it appears not all the rows are being locked. The SQL runs for a period of time with out locking any rows. Then all of a sudden "BAMMMMM!!!!", rows start getting locked. I ran the same SQL against a back up database, and not a single row was locked. I thought turning Transaction Logging off, prevented the utilization of locks. I'm running IDS 7.31.UC5 on an HP-UX operating system. Anthony Nino Ojeda Systems Administrator LATHAM & WATKINS LLP 520 South Grand Avenue, Suite 200 Los Angeles, CA 90071-2610 Direct Tel: (213) 891-7211 Fax: (213) 891-7123 E-mail: anthony.ojeda@lw.com www.lw.com This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. Latham & Watkins LLP

No --- transaction logging and locking are not the same thing. In fact without transaction logging, the role of locking is even more critical. M.P. "Anthony.Oje...." <Anthony.Ojeda@LW To: ids@iiug.org .com> cc: Sent by: Subject: Row Locks When Transaction Logging is turned off [719] forum.subscriber@ iiug.org 03/14/2003 11:35 AM I was running an update statement with Transaction Logging (Buffered) turned off and noticed that HDR+IX type locks were being placed on rows. The odd thing is that it appears not all the rows are being locked. The SQL runs for a period of time with out locking any rows. Then all of a sudden "BAMMMMM!!!!", rows start getting locked. I ran the same SQL against a back up database, and not a single row was locked. I thought turning Transaction Logging off, prevented the utilization of locks. I'm running IDS 7.31.UC5 on an HP-UX operating system. Anthony Nino Ojeda Systems Administrator LATHAM & WATKINS LLP 520 South Grand Avenue, Suite 200 Los Angeles, CA 90071-2610 Direct Tel: (213) 891-7211 Fax: (213) 891-7123 E-mail: anthony.ojeda@lw.com www.lw.com This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. Latham & Watkins LLP