Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ODBC Connections

Posted on 2007-12-04
2
Medium Priority
?
1,159 Views
Last Modified: 2012-08-14
Greetings,

When I have determined that when I do a WRKACTJOB I can see ODBC Connections because they look like the following.
         
 Opt  Subsystem/Job  User        Type  CPU %  Function        Status            
        QZDASOINIT   QUSER       PJ       .0                   TIMW            
        QZDASOINIT   QUSER       PJ       .0                   TIMW            

In order to find the "User" whos connection one of those jobs belongs to, I have to do a 5 (work with job) and then 10 "Display Job log"
Then I get the IP address and from that go to our network guys and ask them whos computer it is.

Our users sign in with their own Username and password..  
Is there ANY way to get that to show up under the "User" column? instead of QUser?
If I cant do that, does anyone know of a report I could run that would show me active ODBC connections and the username and IP address?  
We do also have a product called Standguard, but I am unsure on how to use it. I know that product can be used to block access but I have a feeling that after it was installed, everything was left wide open..  The person in "Charge" of it quit about a month ago.
0
Comment
Question by:ScottParker
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
rward earned 2000 total points
ID: 20404863
Brian Dietz has a freeware utility called WRKODBCJOB that will do what you want.  You can find it at http://home.columbus.rr.com/jbmmdietz/wrkodbcjob.html
0
 
LVL 3

Author Closing Comment

by:ScottParker
ID: 31412630
Just what I was looking for.. Thanks.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What monsters are hiding in your child's room? In this article I will share with you a tech horror story that could happen to anyone, along with some tips on how you can prevent it from happening to you.
This week I attended a Startup Week Chattanooga talk on Gender Diversity in Technology. Check out what I learned.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question