Deleting Journal - Task History

rao_karthik · #1 (**permalink**) 09-05-08, 13:28

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

ARWinner · #2 (**permalink**) 09-05-08, 13:48

Look in table mdthistoryty00 (the schema depends on how you created the tools catalog).

Andy

ARWinner · #3 (**permalink**) 09-10-08, 08:03

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

Internet Services

Web Development

Digital Marketing

Consumer Tech