Results 1 to 4 of 4

Thread: DB2 connections

  1. #1
    Join Date
    Jun 2004
    Posts
    21

    Unanswered: DB2 connections

    Hi Guys,

    I want to log all database's accesses in DB2. All: the successfully connections as well as the restricted connections. I want to see, which users try to connect to a db2 database. Where can I find/catch these information?



    Regards,
    Marcus

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338

    Smile

    OPTION 1>
    To track the applications which got connected to your database over a particular period of the time (few hours) you can use the db2 event monitor:

    see the syntax from the command reference:

    (CREATE EVENT MONITOR--event-monitor-name--FOR---------------->
    '-+-CONNECTIONS--+--+----------------------------+---------')

    OPTION 2>
    To see the connections at any particular moment,:

    db2 "list applications show detail" . This will list all the connections active at that moment.

    OPTION 3>
    If you want to track the connections for a much longer period: Then avoid using event monitor and try using db2audit tool with configuration : "VALIDATE"

    (see the syntax how to use db2audit in db2 information center).

    Thanks,
    Jayanta Datta
    New Delhi, India

  3. #3
    Join Date
    Jun 2004
    Posts
    21

    all connection...

    Can I see all tried connections? All, also the denied ones...

  4. #4
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    yes the db2audit utility will show you both successful/failed connection alongwith the user_id and application details.

    Thanks,

Posting Permissions

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