I don't know how to do it with CF, but DB2 includes "monitors" that are basically like traces in SQL. You should be able to run a test and examine the trace.
Mark -----Original Message----- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 10:59 AM To: CF-Talk Subject: SOT: DB2 table locking Is there a way to check for DB2 table locking via Cold Fusion? Looking for minimal impact on db design - preferrably using just an ODBC query. Thanks! _________________________ _________________________ ____________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists