Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: as view logs generated by a query

    Good morning,
    I'm using DB2 8 and AIX 5.3.
    I'm running a query and I need to know who is generating logs this query, can someone tell me how to see them?

    Greetings.
    DBA DB2 for LUW

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by georgipa View Post
    I'm running a query and I need to know who is generating logs this query
    I think the answer is in the question itself.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2008
    Posts
    147
    Are you asking , how to see the details of the transaction logs? as broken down per query?
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  4. #4
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Excuse me, my inglesh is very bad, When i execute one select this create logs on the database, my question is how view the logs generated by the execution of the select?

    Greetings.
    DBA DB2 for LUW

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Firstly, selects do not generate logs as they probably don't change any data. Secondly, you cannot easily view log records belonging to a particular SQL statement (non-SELECT). Log records are identified by transaction IDs, and each transaction can consist of multiple statements. You will also need to track transaction IDs to be able to map log records to the application transactions.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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