In db2 how do i get

1) The list of users connected / node name /ip address etc.
2) The current sql statemnt executed by a particular user.
3) Before taking an offline backup what are the commands i need to execute .

3.A In oracle we have shutdwon immediate (save and shutdowns) / shutdown
transactional (waits till the user issues commit or rollback then the
database shuts down)

3.B After taking tha back how to find the back is ok ? any commands

3.C how to find the health of the containers. i.e In oracel we have the
command DBverify simillar one in db2

Thanks iN advance
Thiru




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