Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2012

    Unanswered: Prune the db2diag.log file


    In my company we use TSM (backup tool) that uses DB2 as its database. At this
    time the DB2 log file is too large and need to reduce or prune it as soon as
    possible. My problem is that I've lost the user/password of the DB2 instance.

    I wonder if I can run the command (db2log -A) anyway, I meant run the
    command using administrator privileges.

    Do I really need the DB2 instance user/password in order to run this command?

    I need to know, How to reset the DB2 instance user/password?

    Thanks in advance

  2. #2
    Join Date
    Jan 2009
    Zoetermeer, Holland
    You'll need "root" access.
    As root: "su - db2inst1-or-whatever-your-intanceowner-is-called" and you're in. Then run the db2diag -A command and change the password (passwd).
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  3. #3
    Join Date
    Apr 2008
    Any way db2diag.log is just a file. See if you can zip or rename or create a new
    .log file by using OS level commands etc.

    Naval K

Posting Permissions

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