Problem solve Get help with specific problems with your technologies, process and projects.

ODBC user connection

How can I discover what object is accessing a user who is using a ODBC connection? What methods can I use to track this kind of connection?

First, you will need to find the job servicing the profile. Use this command:

wrkobjlck 'USSER PROFILE NAME' *usrprf.

Then look in the job QZDASOINIT it will have open files in option number 14. You can also enable debug (see this document for instructions) this will display also performance related data.

Last, you can define an exit program (or buy one) to log all incoming request and also control these requests. For explanation to exit programs see the information center.


Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.

Check out this Search400.com Featured Topic: Networking and the iSeries

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

Dig Deeper on Physical connections to iSeries

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.