Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2003
    Posts
    12

    Unanswered: How to read db2 log file on NT/XP

    I'm using db2 udb v7.2 on NT and
    when I open log file I can't read it clearly.

    what's the problem?
    what I wrong?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Which log file are you talking about? If it is db2diag.log try opening with MS Wordpad.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Dec 2003
    Posts
    12
    The files under SQLOGDIR folder.
    For example S0000000.LOG.


    Originally posted by Marcus_A
    Which log file are you talking about? If it is db2diag.log try opening with MS Wordpad.
    Attached Files Attached Files

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Those are the log files that are used for DB2 recovery. They are for internal use by DB2 and are not meant to be read in text format.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Dec 2003
    Posts
    12
    Thank you for your reply.
    My problem is where i can read transactions on db?


    Originally posted by Marcus_A
    Those are the log files that are used for DB2 recovery. They are for internal use by DB2 and are not meant to be read in text format.

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Unless you log changes yourself to another table (perhaps with a trigger), you can't easily see the before or after images on the log. There may be some 3rd party tools that can read the log. I would check with BMC Software for starters.

    Going forward, you might be able to use a monitor or trace to track transactions that have run and the SQL statements, but I am not sure what information you want (name of transaction, SQL statements, or actual changes to the data).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Nov 2003
    Posts
    14
    u can not read it

  8. #8
    Join Date
    Oct 2003
    Location
    Rome
    Posts
    15
    I think that you can read the statement of your applications with
    db2 get snapshot for dynamic sql on ...

  9. #9
    Join Date
    Mar 2012
    Posts
    1
    I'm having the problem here. I need to read the SQL Statements that have just been executed in the DB2.

    I have ran the 'db2 get snapshot for dynamic sql on ...' but it seens that the information he returned is not cronologicaly ordered.

    Is there a way to have this statement ordered cronologicaly?

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Try event monitor for statements

Posting Permissions

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