Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    14

    Unanswered: Deleting Journal - Task History

    Hi,
    My Control Center hangs when I try to view Task History in the journal. I want to delete task history.
    I found this link on IBM but I dont know what values to put for the params.
    The command is
    Code:
    db2javit -j:com.ibm.db2.tools.taskcenter.TCClearHistory -a:"<systemName> <taskOwner> <password> <autoDelete>"
    What is systemName? I have tried three options, machine name, Database name and Instance Name. Task Center displays a field "Run System" whose value is the same as machine name.
    I have used a comman of the type:
    Code:
    db2javit -j:com.ibm.db2.tools.taskcenter.TCClearHistory -a:"db2server db2admin password Y"
    I still cant open task history.
    What should I do?
    TIA
    Kar

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look in table mdthistoryty00 (the schema depends on how you created the tools catalog).

    Andy

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    My guess that it is because you have 75K rows that there are too many to show in that table. You can delete the older / unwanted rows using straight SQL.

    Andy

Posting Permissions

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