Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2004
    Location
    UK
    Posts
    52

    Unanswered: how to indentify the TCP/IP or Node from db2 list applications

    Hi Friends,
    We are using db2v8.1 on Win2K. After issuing the "db2 list applications" command I got the following output. Now, my query is how to identify which "Application Id" is from which client/tcpip address. After going thru the online manual I came to know "Application Id" parameter denotes the same and converts the IP address into hexadecimal. But still it is not clear to me as how to get the IP address or node name. If anybody can explain the same to me it would be of great help.

    For example Application Id :
    17216851.1444.000B00180031
    or
    *LOCAL.DB2.040705055452

    what does this denote?

    db2 => list applications

    Auth Id Application Appl. Application Id DB # of
    Name Handle Name Agents

    -------- -------------- ---------- ------------------------------ -------- -----
    FFM db2syscs.exe 85 *LOCAL.DB2.040705055452
    FFM_ENTS 1
    FFM JDBC4DB2 80 17216851.1444.000B00180031 FFM_ENTS 1
    FFM db2syscs.exe 81 *LOCAL.DB2.040705055355 FFM_ENTS 1
    FFM db2syscs.exe 73 *LOCAL.DB2.040705055226 FFM_ENTS 1
    FFM JDBC4DB2 71 17216851.1398.000B00160018 FFM_ENTS 1
    Last edited by gpeee; 07-05-04 at 03:23.

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Applicaion ID 17216851.1444.000B00180031

    IP address (group two characters together and the convert from hex to dec - you can use Calculator program - just turn on Scientific option from View menu)
    17=23
    21=33
    68=104
    51=81

    So IP adress is 23.33.104.81

    Port number in hexa
    1444 = 5188

    LOCAL.DB2.040705055452
    Local means localhost so from within the same computer.

    The third part of Application ID is timestamp of connection. I just can't remember how to get it. Does anyone know how to get timestamp from application id? Within LOCAL I understand so the above time is: 2004-07-07-05:54:52. What about remote connection timestamp. It is in hexa so, how to get this timestamp from Application ID?

    Grofaty
    Last edited by grofaty; 07-05-04 at 04:02.

  3. #3
    Join Date
    Jan 2004
    Location
    UK
    Posts
    52
    Thanks a lot.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    The timestamp is in CUT (or GMT)
    The format is
    yymmddHHMMSS

    There is no hex in this filed

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

  5. #5
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    sathyaram_s your statement is true for local connections what about remote connections e.g.: Application ID: 17216851.1444.000B00180031

    So what does 000B00180031 means? Noties charachter "B" inside string?

    Thanks,
    Grofaty

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    That looks a strange number to me ...

    The date with year and day part 00 is strange ...

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

  7. #7
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    I have tested: db2 list application on Linux and there it works fine, but on Windows there are some strange numbers and characters in field 3. Why is there a difference?

    Grofaty

  8. #8
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by gpeee
    Hi Friends,
    We are using db2v8.1 on Win2K. After issuing the "db2 list applications" command I got the following output. Now, my query is how to identify which "Application Id" is from which client/tcpip address. After going thru the online manual I came to know "Application Id" parameter denotes the same and converts the IP address into hexadecimal. But still it is not clear to me as how to get the IP address or node name. If anybody can explain the same to me it would be of great help.

    For example Application Id :
    17216851.1444.000B00180031
    or
    *LOCAL.DB2.040705055452

    what does this denote?

    db2 => list applications

    Auth Id Application Appl. Application Id DB # of
    Name Handle Name Agents

    -------- -------------- ---------- ------------------------------ -------- -----
    FFM db2syscs.exe 85 *LOCAL.DB2.040705055452
    FFM_ENTS 1
    FFM JDBC4DB2 80 17216851.1444.000B00180031 FFM_ENTS 1
    FFM db2syscs.exe 81 *LOCAL.DB2.040705055355 FFM_ENTS 1
    FFM db2syscs.exe 73 *LOCAL.DB2.040705055226 FFM_ENTS 1
    FFM JDBC4DB2 71 17216851.1398.000B00160018 FFM_ENTS 1
    Why not do a snapshot for applications? That gives you the IP too, in a less cryptic format.

    There's also the new query-able snapshot stuff:
    SELECT INBOUND_COMM_ADDRESS FROM TABLE( SNAPSHOT_APPL( 'SAMPLE', -1 )) as SNAPSHOT_APPL

    See the Monitoring Guide for full details of all the available columns, it's pretty extensive.
    Last edited by J Petruk; 07-05-04 at 10:54.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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