Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256

    Unanswered: tracing application handle id to users

    Observe a application handle like:

    AC150B64.5805.030623113733

    Last part of the string relates to date and time application connected, the first part is constant for every handle (AC150).
    I there a way to derive user information from the remainder of the handle. Does it relate to some network thing?
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: tracing application handle id to users

    Yes, it does. Look into the System Monitor Guide for complete description.


    dollar

    Originally posted by blom0344
    Observe a application handle like:

    AC150B64.5805.030623113733

    Last part of the string relates to date and time application connected, the first part is constant for every handle (AC150).
    I there a way to derive user information from the remainder of the handle. Does it relate to some network thing?

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: tracing application handle id to users

    Using you app handle :

    AC150B64 - ipaddress in hex format ac.15.0b.64 equivalent to 172.21.11.100
    5805 - port number at the client (i think it is Hex)
    030623113733 - timestamp in CUT

    I normally do an application snapshot and get the following values:

    Inbound communication address - gives the above ip/port info in decimal form
    Client login Id - The user who is logged on in the client. For eg, on your windows, you logon as tblom and connect to the database db1 as maintusr, then this filed will indicate tblom.

    I use the following script to get a list of users I need to inform if I want to restart instance ....


    if [ "$1" == "" ]
    then
    echo "Usage : " $0 "<dbname>"
    exit
    fi
    dbname=$1
    echo "The following Clients are using the database $dbname"
    db2 get snapshot for applications on $dbname | grep 'Client login' | nawk '{print $NF}' | sort -u

    HTH

    Sathyaram


    Originally posted by blom0344
    Observe a application handle like:

    AC150B64.5805.030623113733

    Last part of the string relates to date and time application connected, the first part is constant for every handle (AC150).
    I there a way to derive user information from the remainder of the handle. Does it relate to some network thing?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256

    Question

    I got the information I wanted through issuing :

    db2 get snapshot for application agentid <appl handle>

    for a certain application handle. (Lots of stuff, even if client is working with Win95 or with W2000)

    The script you run is that something UNIX like ? (GREP) From where do you run this script? .BAT file?
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Yeh ... It is a kron script for Unix

    Cheers

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •