Hi, and thanks in advance... I have about zero experience with DB2, and I
need help diagnosing a transaction-related problem...
   What SQL can I run to find what transactions (XA) may be in process
in the DBMS, and which(or how many) dynamic sections may be associated

what commands can I use to find out what connection is causing a lock?
where can i change the verbosity level of db2 logfiles?
where are those logfiles?
Greetings & Thanks

I was reading the FixPackReadme.txt file in preparation for installing v8.1
Alternate FP7. The prerequisites section says that all DB2 processes must be
stopped and doesn't differentiate between regular an alternate fixpacks. I
was hoping the alternate fixpack would help to avoid ...