send the rest of the SQL without the isolation.






"Joann_Tobin" <db2udbdba-ezmlmshield-x99296242.[Email address protected]
03/18/2008 01:10 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Fw: Deadlock DB2 UDB







can't type in the syntax for uncommittted read. The mail gets rejected by
the robot sniper monitoring this site for some reason cuz it thinks I am
using phone text for "you are"..

So, I am using the syntax for uncommitted read on my View. The View has an
order by.

Why would I get a deadlock? No imports occur on the underlying tables in
the view defintion.

Thanks, JoAnn




This message is intended for the recipient only and is not meant to be
forwarded or distributed in any other format. This communication is for
informational purposes only. It is not intended as an offer or
solicitation for the purchase or sale of any financial instrument, or
security, or as an official confirmation of any transaction. Putnam does
not accept purchase or redemptions of securities, instructions, or
authorizations that are sent via e-mail. All market prices, data and other
information are not warranted as to completeness or accuracy and are
subject to change without notice. Any comments or statements made herein
do not necessarily reflect those of Putnam Investments, LLC (DBA Putnam
Investments) and its subsidiaries and affiliates. If you are not the
intended recipient of this e-mail, please delete the e-mail.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page