How to display from ISPF DB2 connection locks, open transactions, connection status.
The only command I found so far is -display thread (*).

You can use the DB2I application to issue DB2 commands. The -DISPLAY THREAD command will give you most of what you want;
http://publib.boulder.ibm.com/infoce...playthread.htm

To get LOCKing information, you'll have to issue the -DISPLAY DATABASE command for the database you want to inspect. See here:
http://publib.boulder.ibm.com/infoce...aydatabase.htm

Todd

Thank you, Todd
You are very helpful.
Coming from Oracle/Sybase/Microsoft background DB2
can be challenging sometimes