Delete DB2 TaskCenter history entries in the journal

Only required from time to time but can really improve the stability of the DB2 Task Center especially if you have scheduled numerous tasks which run every day.

A lot of entries in the journal of the DB2 Task Center utility can be make it very unstable and let it crash on a regular basis with a JVM Out Of Memory error message.

You have the option to remove them manually but you can also purge them in one batch
with the following db2javit command.

db202:/opt/ibm/db2/V9.7/bin # ./db2javit -j:com.ibm.db2.tools.taskcenter.TCClearHistory -a:”DB202.INTRA.ACME.COM db2admin password Y 90″

For an explanation of the parameters please see the following IBM Technote.

http://www-01.ibm.com/support/docview.wss?uid=swg21208104

 

This entry was posted in db2 and tagged , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

Please leave these two fields as-is:

Protected by Invisible Defender. Showed 403 to 807,320 bad guys.